def updateState(self, key, state): if self._states.has_key(key): self._states[key] = unicode(state) stmt = JobStateLog.update().where( JobStateLog.c.jobid == self._jobid.getId() and JobStateLog.c.owser == self._jobid.getOwner() and JobStateLog.c.pkey == unicode(key)).\ values(pvalue=unicode(state), time=datetime.now(UTC())) result = self._conn.execute(stmt) else: self._states[key] = unicode(state) ins = JobStateLog.insert().values(jobid=self._jobid.getId(), owner=self._jobid.getOwner(), pkey=unicode(key), pvalue=unicode(state), time=datetime.now(UTC())) result = self._conn.execute(ins)
def deleteStates(self): for key in self._states.keys(): delstate = JobStateLog.delete().where(JobStateLog.c.jobid == self._jobid.getId() and JobStateLog.c.owner == self._jobid.getOwner() and JobStateLog.c.pkey == unicode(key)) result = self._conn.execute(delstate)