Changeset 915 for pykota/trunk/pykota/storages/postgresql.py

Timestamp:

04/15/03 13:30:57 (21 years ago)

Author:

jalet

Message:

More work done on money print charging.
Minor bugs corrected.
All tools now access to the storage as priviledged users, repykota excepted.

Files:

• pykota/trunk/pykota/storages/postgresql.py (modified) (2 diffs)

pykota/trunk/pykota/storages/postgresql.py

@@ -21 +21 @@
 #
 # $Log$
+# Revision 1.7  2003/04/15 11:30:57  jalet
+# More work done on money print charging.
+# Minor bugs corrected.
+# All tools now access to the storage as priviledged users, repykota excepted.
+#
 # Revision 1.6  2003/03/29 13:45:27  jalet
 # GPL paragraphs were incorrectly (from memory) copied into the sources.
@@ -82 +87 @@
     def doQuery(self, query) :
         """Does a query."""
+        if type(query) in (type([]), type(())) :
+            query = ";".join(query)
+        query = query.strip()    
+        if not query.endswith(';') :    
+            query += ';'
+        self.database.query("BEGIN;")
         try :
-            return self.database.query(query)
+            result = self.database.query(query)
         except pg.error, msg :    
+            self.database.query("ROLLBACK;")
             raise PyKotaStorageError, msg
+        else :    
+            self.database.query("COMMIT;")
+            return result
         
     def doQuote(self, field) :