Ignore:
Timestamp:
25/06/10 14:29:20 (10 years ago)
Author:
astephen
Message:

fixing up jobs page and moving renderer code into renderer package

File:
1 edited

Legend:

Unmodified
Added
Removed
  • cows_wps/trunk/cows_wps/lib/request.py

    r6949 r7095  
    136136        # need to run another query on the database for each request returned. 
    137137         
    138         #!TODO:There must be a better way of achiving this using sqlalchemy 
    139         s = sqlalchemy.sql.text("""SELECT r.id, r.user_id, r.job_id, j.process, j.process_dir, j.status, j.type, sj.sge_id, sj.sge_queue, sj.last_polled 
     138        s = sqlalchemy.sql.text("""SELECT r.id, r.user_id, r.job_id, j.process, j.process_dir, j.status, j.type, j.created, sj.sge_id, sj.sge_queue, sj.last_polled  
    140139                    FROM request as r 
    141140                    JOIN job as j ON r.job_id = j.job_id 
    142141                    LEFT JOIN sge_job as sj ON r.job_id = sj.job_id""") 
    143142         
    144         columns = ["id", "user_id", "job_id", "process", "process_dir", "status", "type", "sge_id", "sge_queue", "last_polled"] 
     143        columns = ["id", "user_id", "job_id", "process", "process_dir", "status", "type", "created", "sge_id", "sge_queue", "last_polled"] 
    145144         
    146145        conn = self.engine.connect() 
     
    170169            job.type = r['type'] 
    171170            job.job_id = r['job_id'] 
     171            job.created = r['created'] 
    172172             
    173173            req = Request(r['id'], r['user_id']) 
Note: See TracChangeset for help on using the changeset viewer.