def createJob( self ):
     job = Hydra_job( pickledTicket = pickle.dumps( self ), 
                      priority = self.priority, 
                      project = self.project,
                      requirements = self.capability_pattern,
                      createTime = datetime.now())
     with transaction() as t:
         job.insert(transaction=t)
         
     return job
 def refreshHandler(self, *args):
     try:
         jobs = Hydra_job.fetch()
         self.jobTable.setRowCount(len(jobs))
         for pos, job in enumerate(jobs):
             ticket = pickle.loads(job.pickledTicket)
             self.jobTable.setItem(pos, 0, QTableWidgetItem_int(str(job.id)))
             self.jobTable.setItem(pos, 1, QTableWidgetItem_int(str(job.priority)))
             self.jobTable.setItem(pos, 2, QTableWidgetItem(ticket.name()))
     except sqlerror as err:
         logger.debug(str(err))
         aboutBox(self, "SQL error", str(err))