Changeset 812

Show
Ignore:
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.

Location:
pykota/trunk
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • pykota/trunk/initscripts/pykota-postgresql.sql

    r811 r812  
    1414-- 
    1515-- $Log$ 
     16-- Revision 1.4  2003/02/27 08:40:14  jalet 
     17-- DATETIME is not supported anymore in PostgreSQL 7.3 it seems, but 
     18-- TIMESTAMP is. 
     19-- 
    1620-- Revision 1.3  2003/02/26 20:34:22  jalet 
    1721-- Default value for printer page counter set to 0 
    … …  
    7983                        softlimit INT4, 
    8084                        hardlimit INT4, 
    81                         datelimit DATETIME); 
     85                        datelimit TIMESTAMP); 
    8286                         
    8387-- 
    … …  
    9195                         softlimit INT4, 
    9296                         hardlimit INT4, 
    93                          datelimit DATETIME); 
     97                         datelimit TIMESTAMP); 
    9498                         
    9599--                         

  • pykota/trunk/pykota/storages/sql.py

    r791 r812  
    1515# 
    1616# $Log$ 
     17# Revision 1.19  2003/02/27 08:41:49  jalet 
     18# DATETIME is not supported anymore in PostgreSQL 7.3 it seems, but 
     19# TIMESTAMP is. 
     20# 
    1721# Revision 1.18  2003/02/10 12:07:31  jalet 
    1822# Now repykota should output the recorded total page number for each printer too. 
    … …  
    184188        (userid, printerid) = self.getUPIds(username, printername) 
    185189        if (userid is not None) and (printerid is not None) : 
    186             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))) 
     190            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))) 
    187191         
    188192    def updateUserPQuota(self, username, printername, pagecount) :