Context Navigation

pgstorage.py

Timestamp:

02/21/06 18:15:40 (18 years ago)

Author:

jerome

Message:

Added timing information for SQL queries and transactions.

Files:

r2622	r2741
23	23	#
24	24
	25	import time
25	26	from types import StringType
26	27
…	…
64	65	def beginTransaction(self) :
65	66	"""Starts a transaction."""
	67	self.before = time.time()
66	68	self.database.query("BEGIN;")
67	69	self.tool.logdebug("Transaction begins...")
…	…
70	72	"""Commits a transaction."""
71	73	self.database.query("COMMIT;")
	74	after = time.time()
72	75	self.tool.logdebug("Transaction committed.")
	76	self.tool.logdebug("Transaction duration : %.4f seconds" % (after - self.before))
73	77
74	78	def rollbackTransaction(self) :
75	79	"""Rollbacks a transaction."""
76	80	self.database.query("ROLLBACK;")
	81	after = time.time()
77	82	self.tool.logdebug("Transaction aborted.")
	83	self.tool.logdebug("Transaction duration : %.4f seconds" % (after - self.before))
78	84
79	85	def doRawSearch(self, query) :
…	…
83	89	query += ';'
84	90	try :
	91	before = time.time()
85	92	self.tool.logdebug("QUERY : %s" % query)
86	93	result = self.database.query(query)
…	…
88	95	raise PyKotaStorageError, str(msg)
89	96	else :
	97	after = time.time()
	98	self.tool.logdebug("Query Duration : %.4f seconds" % (after - before))
90	99	return result
91	100
…	…
102	111	query += ';'
103	112	try :
	113	before = time.time()
104	114	self.tool.logdebug("QUERY : %s" % query)
105	115	result = self.database.query(query)
…	…
107	117	raise PyKotaStorageError, str(msg)
108	118	else :
	119	after = time.time()
	120	self.tool.logdebug("Query Duration : %.4f seconds" % (after - before))
109	121	return result
110	122