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))