On 05/08/2013 05:38 PM, Geert Vandeweyer wrote:
self.sa_session.execute('UPDATE job SET runtime = :runtime WHERE id = :id',{'runtime':runtime,'id':galaxy_job_id})

does anybody have a solution to convert this statement to proper sqlalchemy syntax, for use in the check_watched_items function in pbs.py ?

Regarding Taylor's suggestion: A separate table is also an option, but would take more queries & joins to estimate walltime at startup (join table with job table for job type (on job-id), request two rows per "finished" jobid, substract end-start timestamp, average. An extra column in the job table only needs one query on one table (select runtime from jobs where type = 'x' and state = 'ok').




Geert Vandeweyer, Ph.D.
Department of Medical Genetics
University of Antwerp
Prins Boudewijnlaan 43
2650 Edegem
Tel: +32 (0)3 275 97 56
E-mail: geert.vandewe...@ua.ac.be

Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:

To search Galaxy mailing lists use the unified search at:

Reply via email to