Changeset 812 for pykota/trunk/pykota/storages/sql.py

Timestamp:

02/27/03 09:41:49 (21 years ago)

Author:

jalet

Message:

DATETIME is not supported anymore in PostgreSQL 7.3 it seems, but
TIMESTAMP is.

Files:

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

pykota/trunk/pykota/storages/sql.py

@@ -15 +15 @@
 #
 # $Log$
+# Revision 1.19  2003/02/27 08:41:49  jalet
+# DATETIME is not supported anymore in PostgreSQL 7.3 it seems, but
+# TIMESTAMP is.
+#
 # Revision 1.18  2003/02/10 12:07:31  jalet
 # Now repykota should output the recorded total page number for each printer too.
@@ -184 +188 @@
         (userid, printerid) = self.getUPIds(username, printername)
         if (userid is not None) and (printerid is not None) :
-            self.doQuery("UPDATE userpquota SET datelimit=%s::DATETIME WHERE userid=%s AND printerid=%s;" % (self.doQuote("%04i-%02i-%02i %02i:%02i:%02i" % (datelimit.year, datelimit.month, datelimit.day, datelimit.hour, datelimit.minute, datelimit.second)), self.doQuote(userid), self.doQuote(printerid)))
+            self.doQuery("UPDATE userpquota SET datelimit=%s::TIMESTAMP WHERE userid=%s AND printerid=%s;" % (self.doQuote("%04i-%02i-%02i %02i:%02i:%02i" % (datelimit.year, datelimit.month, datelimit.day, datelimit.hour, datelimit.minute, datelimit.second)), self.doQuote(userid), self.doQuote(printerid)))
         
     def updateUserPQuota(self, username, printername, pagecount) :