Changeset 3308 for pykota/trunk/pykota/storages/pgstorage.py
- Timestamp:
- 01/30/08 21:48:29 (16 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/pykota/storages/pgstorage.py
r3294 r3308 23 23 """This module defines a class to access to a PostgreSQL database backend.""" 24 24 25 import time26 25 from types import StringType 27 26 … … 76 75 def beginTransaction(self) : 77 76 """Starts a transaction.""" 78 self.before = time.time()79 77 self.database.query("BEGIN;") 80 78 self.tool.logdebug("Transaction begins...") … … 83 81 """Commits a transaction.""" 84 82 self.database.query("COMMIT;") 85 after = time.time()86 83 self.tool.logdebug("Transaction committed.") 87 #self.tool.logdebug("Transaction duration : %.4f seconds" % (after - self.before))88 84 89 85 def rollbackTransaction(self) : 90 86 """Rollbacks a transaction.""" 91 87 self.database.query("ROLLBACK;") 92 after = time.time()93 88 self.tool.logdebug("Transaction aborted.") 94 #self.tool.logdebug("Transaction duration : %.4f seconds" % (after - self.before))95 89 96 90 def doRawSearch(self, query) : … … 100 94 query += ';' 101 95 try : 102 before = time.time()103 96 self.querydebug("QUERY : %s" % query) 104 re sult =self.database.query(query)97 return self.database.query(query) 105 98 except PGError, msg : 106 raise PyKotaStorageError, str(msg) 107 else : 108 after = time.time() 109 #self.tool.logdebug("Query Duration : %.4f seconds" % (after - before)) 110 return result 99 raise PyKotaStorageError, repr(msg) 111 100 112 101 def doSearch(self, query) : … … 122 111 query += ';' 123 112 try : 124 before = time.time()125 113 self.querydebug("QUERY : %s" % query) 126 re sult =self.database.query(query)114 return self.database.query(query) 127 115 except PGError, msg : 128 116 self.tool.logdebug("Query failed : %s" % repr(msg)) 129 raise PyKotaStorageError, str(msg) 130 else : 131 after = time.time() 132 #self.tool.logdebug("Query Duration : %.4f seconds" % (after - before)) 133 return result 117 raise PyKotaStorageError, repr(msg) 134 118 135 119 def doQuote(self, field) :