# HG changeset patch
# User Björn Ricks <bjoern.ricks@intevation.de>
# Date 1355387452 -3600
# Node ID 36b9f2d31810f361b9ff8c22fcf098b19c5e21d2
# Parent  a5319bb1ac137ff08b8781c3ccaa5b2a34bb45ce
Add backend method to update a project in the database

Update the project key and description in the database.

diff -r a5319bb1ac13 -r 36b9f2d31810 getan/backend.py
--- a/getan/backend.py	Thu Dec 13 09:00:09 2012 +0100
+++ b/getan/backend.py	Thu Dec 13 09:30:52 2012 +0100
@@ -85,6 +85,8 @@
 
 UPDATE_ENTRY = 'UPDATE entries SET description = ? WHERE id = ?'
 
+UPDATE_PROJECT = "UPDATE projects SET key = ?, description = ? WHERE id = ?"
+
 logger = logging.getLogger()
 
 class InvalidProjectKeyError(Exception):
@@ -244,6 +246,20 @@
         finally:
             close(cur)
 
+    def update_project(self, project):
+        if not project:
+            return
+
+        cur = None
+        try:
+            cur = self.con.cursor()
+            cur.execute(UPDATE_PROJECT, (project.key, project.desc, project.id))
+            self.con.commit()
+            logger.debug("Updated project: (%d) %s %s" % (project.id,
+                project.key, project.desc))
+        finally:
+            close(cur)
+
 def close(cur):
     """ This function closes a database cursor if it is existing """
     if cur: