extras-buildsys/utils plague-user-migration.py,1.1,1.2

[Daniel Williams (dcbw)]

Author: dcbw

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

Modified Files:
	plague-user-migration.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: plague-user-migration.py
===================================================================
RCS file: /cvs/fedora/extras-buildsys/utils/plague-user-migration.py,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- plague-user-migration.py	20 Nov 2005 18:42:40 -0000	1.1
+++ plague-user-migration.py	25 Nov 2005 22:10:24 -0000	1.2
@@ -88,12 +88,16 @@
             print >> sys.stderr, "Trying to export empty data set, exiting"
             sys.exit(1)
         for user in self.imported_users:
+            own_jobs = self.dest_dbcx.convert_boolean(user['own_jobs'])
+            job_admin = self.dest_dbcx.convert_boolean(user['job_admin'])
+            user_admin = self.dest_dbcx.convert_boolean(user['user_admin'])
+            server_admin = self.dest_dbcx.convert_boolean(user['server_admin'])
             # create sql insert statement
-            sql = 'INSERT INTO users (email, own_jobs, job_admin,' \
-                    ' user_admin, server_admin) VALUES (' \
-                    '"%s", %d, %d, %d, %d)' \
-                    % (user['email'], user['own_jobs'], user['job_admin'], \
-                    user['user_admin'], user['server_admin'])
+            sql = "INSERT INTO users (email, own_jobs, job_admin," \
+                    " user_admin, server_admin) VALUES (" \
+                    "'%s', %s, %s, %s, %s)" \
+                    % (user['email'], own_jobs, job_admin, \
+                    user_admin, server_admin)
             self.dest_curs.execute(sql)
             self.dest_dbcx.commit()
             print "Added user: %s" % user['email']