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)
