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'). Best, Geert -- Geert Vandeweyer, Ph.D. Department of Medical Genetics University of Antwerp Prins Boudewijnlaan 43 2650 Edegem Belgium Tel: +32 (0)3 275 97 56 E-mail: geert.vandeweyer@ua.ac.be http://ua.ac.be/cognitivegenetics http://www.linkedin.com/pub/geert-vandeweyer/26/457/726