# HG changeset patch
# User Björn Ricks <bjoern.ricks@intevation.de>
# Date 1301912020 -7200
# Node ID 9cb57c37369a129b2ea66b82ebeee759088d3870
# Parent  3f97954868e48380ed0101f646535fd32bfc0730
fix insert new project sql statemenent and api

diff -r 3f97954868e4 -r 9cb57c37369a getan/backend.py
--- a/getan/backend.py	Wed Mar 23 11:04:28 2011 +0100
+++ b/getan/backend.py	Mon Apr 04 12:13:40 2011 +0200
@@ -75,7 +75,7 @@
 '''
 
 INSERT_PROJECT = '''
-INSERT INTO projects (id, key, description, active) VALUES (?,?,?,1)
+INSERT INTO projects (key, description, active) VALUES (?,?,1)
 '''
 
 DELETE_PROJECT_ENTRY = 'DELETE FROM entries WHERE id = %i'
@@ -179,15 +179,15 @@
         finally:
             close(cur)
 
-    def insert_project(self, project, key, description):
-        if project is None:
+    def insert_project(self, key, description):
+        if key is None or description is None:
             return
         cur = None
         try:
             cur = self.con.cursor()
-            cur.execute(INSERT_PROJECT, (project, key, description))
+            cur.execute(INSERT_PROJECT, (key, description))
             self.con.commit()
-            logger.debug("Added a new project '%s' into db" % project)
+            logger.debug("Added a new project '%s' into db" % description)
         finally:
             close(cur)