# HG changeset patch
# User Björn Ricks <bjoern.ricks@intevation.de>
# Date 1300455804 -3600
# Node ID 062ce001abd1897b4a8808d702f05199b98ea293
# Parent  5f87604ea5ed61c99078737976da2cab3b490507
add backend method to create new projects

diff -r 5f87604ea5ed -r 062ce001abd1 getan/backend.py
--- a/getan/backend.py	Mon Feb 07 11:28:25 2011 +0100
+++ b/getan/backend.py	Fri Mar 18 14:43:24 2011 +0100
@@ -74,6 +74,10 @@
 VALUES(?,?,?,?)
 '''
 
+INSERT_PROJECT = '''
+INSERT INTO projects (id, key, description, active) VALUES (?,?,?,1)
+'''
+
 DELETE_PROJECT_ENTRY = 'DELETE FROM entries WHERE id = %i'
 
 MOVE_ENTRY = 'UPDATE entries SET project_id = ? WHERE id = ?'
@@ -175,6 +179,15 @@
         finally:
             close(cur)
 
+    def insert_project(self, project, key, description):
+        if project is None:
+            return
+        cur = None
+        try
+            cur = self.con.cursor()
+            cur.execute(INSERT_PROJECT, (project, key, description))
+            self.con.commit()
+            logger.debug("Added a new project '%s' into db" % project)
 
     def delete_entries(self, entries):
         if entries is None: return