# HG changeset patch # User Björn Ricks # Date 1306322769 -7200 # Node ID a25dab413260e2dd74c6b0683f265a4f3b7f7180 # Parent 34a0f5c533bd9098be5d53e7a4dfb1fee6a834fe Add new method to update a description of an entry in the database backend diff -r 34a0f5c533bd -r a25dab413260 getan/backend.py --- a/getan/backend.py Wed May 25 13:23:04 2011 +0200 +++ b/getan/backend.py Wed May 25 13:26:09 2011 +0200 @@ -82,6 +82,8 @@ MOVE_ENTRY = 'UPDATE entries SET project_id = ? WHERE id = ?' +UPDATE_ENTRY = 'UPDATE entries SET description = ? WHERE id = ?' + logger = logging.getLogger() class Backend: @@ -219,6 +221,19 @@ finally: close(cur) + def update_entry(self, entry): + if not entry: + return + + cur = None + try: + cur = self.con.cursor() + cur.execute(UPDATE_ENTRY, (entry.desc, entry.id)) + self.con.commit() + logger.debug("Updated entry: '%s' (%d)" % (entry.desc, entry.id)) + finally: + close(cur) + def close(cur): """ This function closes a database cursor if it is existing """ if cur: