Batch processors

[Jan Aleman]

Make sure to have your cron-entry in a global startup method and you're all set. Something like this:
http://www.servoymagazine.com/home/2007 ... tho_1.html


Looks like Robert will be attending the ServoyWorld Batchprocessors session ;-)

[IT2Be]

Looks like Robert will be attending the ServoyWorld Batchprocessors session

Isn't that that single, very intense, 1:1 session against that ridicule rate

[ROCLASI]

Looks like Robert will be attending the ServoyWorld Batchprocessors session

Maybe I should.
I've been only using them since they were implemented (what was it? 2.1.x or so?)...or maybe it's the 3 hour drive I just had...

[grahamg]

Maybe I could join Robert in this 'intensive' session.

Have a WebClient solution for an Art Exhibition company that display 3 x GIFs of artists pictures on all the web pages and changes them every 10 seconds. Set the GIF rotation up as batch Processor on server and hums along beautifully.

However, we also have WebClient forms for potential exhibitors/visitors to apply for tickets etc and discovered that if they typing into a field when the GIFs are changed the field focus is lost - can get quite frustrating.

Doing an applicationSavedata() immediately before the rotation saves the field contents but would welcome ideas to avoid the Batch Processor inteferring with form filling.

Regards

Graham Greensall
Worxinfo Ltd

[IT2Be]

Maybe a stupid suggestion but why don't you make the gif an animated gif?

[Pierre-andre]

At the moment, the server is working on Windows. But this method have to work with Linux and Mac OS/X.

In first, I wanted to create a stored procedure in PostgreSQL and executed it from servoy. But Postres don't allow to create Procedure, only function. Unfortunately I can't execute a REINDEX, PG_DUMP OR VACUUM command on database in function because "REINDEX cannot be executed inside a transaction block."
http://www.postgresql.org/docs/8.2/inte ... index.html


So I choosed to use cronjob. I created a Startup script :

var jobname = "backup"
var cronTimings = "* 00 22 * * ?"
var startDate = new Date()
var endDate = new Date(startDate.getFullYear()+50,startDate.getMonth(),startDate.getDate())
var args = new Array(directory_postgres,directory_for_backup)

plugins.scheduler.addCronJob(jobname, cronTimings, globals.Backup_DB,startDate,endDate,args)

The method backup:

var directory_postgres = arguments[0]
var directory_for_backup= arguments[1]

//Returns the name of the operating system
var osname = application.getOSName();

if(osname.indexOf("Windows",0)>-1){

var file = plugins.file.convertToJSFile(directory_postgres +"/vacuumdb.exe")
if(file.exists())
application.executeProgram(directory_postgres +"/vacuumdb.exe","-h","localhost","-p","5432","-U","postgres","-d","sopavet")

var file = plugins.file.convertToJSFile(directory_postgres +"/reindexdb.exe")
if(file.exists())
application.executeProgram(directory_postgres +"/reindexdb.exe","-h","localhost","-p","5432","-U","postgres","-d","sopavet"

var file = plugins.file.convertToJSFile(directory_postgres +"/pg_dump.exe")
if(file.exists())
application.executeProgram(directory_postgres +"/pg_dump.exe","-i","-h","localhost","-p","5432","-U","postgres","-F","t","-f","\""directory_for_backup+"/database_save.backup\"","sopavet"

}

I have to add security rules with postgres's user and complete this method for Linux and Mac OS/X.

It's work fine on Windows XP with Postgres 8.1, but I didn't know that batch process use one client license .So I have to find another way to backup my database.

[IT2Be]

but I didn't know that batch process use one client license .So I have to find another way to backup my database.

But doesn't the cost of one client weight up to the ease of use (as you said yourself)?
Obviously I don't do any sales for Servoy but imho you can create a fully customizable tool against a low price.

[Pierre-andre]

But doesn't the cost of one client weight up to the ease of use (as you said yourself)?

hehe

I will try to convince my boss

[grahamg]

Hi Marcel

Yes we looked at animated GIFs but new Images are being added to the Artists database all the time and to be fair to everyone the GIFs have to be selected at random.

Now looking at grabbing say 50 at a time into a Media array (each GIF is only 40-50kb) then just selecting from that array rather than going back to the DB each time.


Graham Greensall
Worxinfo Ltd

[Pierre-andre]

I have a last question about batch processors.

Can I start / Stop / Add or remove a batch processor on Servoy'server in a method (With scheduler plugin for example)?

Thanks to that, I be able to start a Headless client without the webadmin and it will be completely transparent for the user.

thanks

[IT2Be]

The answer is no, so far I know.

Why would you btw, let it run

[pbakker]

There are no functions available to add batch processors other than manually through the admin pages.

But you could offcourse have a batchprocessor that runs multiple processes sequentially, based on configuration records that you store in a table.

That batchprocessor could also determine to start a certain process or not based on a value (read: status) in a certain column of the config records.

Paul

[ROCLASI]

Actually the answer is yes, with some work you can.

First of all you can remove cronjobs with a method.
The only thing you need to do is setup a table where you manage your cronjobs (records) together with a cronjob that periodically reads this table and checks for changes.
When a cronjob record has changed it removes the running cronjob and reapplies it with the new settings.
When a cronjob record was removed (or marked as such) it simply removes the cronjob.

So it all will be data driven.

Hope this helps.

[ROCLASI]

Ah, I should read better before I reply.
No indeed you can't add batchprocessors via a cronjob. BUT you can use 1 single batchprocessor and use the technique I described in previous post.

[IT2Be]

Glad you saw it! Did not want to correct you again