extras-buildsys/server DBManager.py,1.4,1.5

[Daniel Williams (dcbw)]

Author: dcbw

Update of /cvs/fedora/extras-buildsys/server
In directory cvs-int.fedora.redhat.com:/tmp/cvs-serv846/server

Modified Files:
	DBManager.py 
Log Message:
2005-11-25  Dan Williams  <dcbw at redhat.com>

    * server/DBManager.py
      utils/plague-user-migration.py
        - Postgres requires single-quotes, not double
        - Postgres wants "True" for boolean fields rather
            that "1", so add coversion functions for all
            database types to do the right thing




Index: DBManager.py
===================================================================
RCS file: /cvs/fedora/extras-buildsys/server/DBManager.py,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- DBManager.py	20 Nov 2005 18:42:46 -0000	1.4
+++ DBManager.py	25 Nov 2005 22:10:18 -0000	1.5
@@ -102,6 +102,9 @@
     def get_uid_value_for_insert(self):
         raise Exception("Need to implement this function for derived classes.")
 
+    def convert_boolean(self, value):
+        raise Exception("Need to implement this function for derived classes.")
+
     def fetchall(self, cursor):
         raise Exception("Need to implement this function for derived classes.")
 
@@ -122,6 +125,9 @@
     def get_uid_value_for_insert(self):
         return "NULL,"
 
+    def convert_boolean(self, value):
+        return value
+
     def fetchall(self, cursor):
         """ sqlite returns the items in a dict-like class already """
         return cursor.fetchall()
@@ -164,6 +170,13 @@
     def get_uid_value_for_insert(self):
         return ""
 
+    def convert_boolean(self, value):
+        if value == 1 or value == True:
+            return True
+        elif value == 0 or value == False:
+            return False
+        return value
+
     def fetchall(self, cursor):
         """ We need to convert the returned data to a ResultSet object so
             we can access it as a dict 
@@ -213,6 +226,9 @@
     def get_uid_value_for_insert(self):
         return ""
 
+    def convert_boolean(self, value):
+        return value
+
     def fetchall(self, cursor):
         """ We need to convert the returned data to a ResultSet object so
             we can access it as a dict