Changeset 722 for pykota/trunk

Timestamp:

02/06/03 16:03:11 (22 years ago)

Author:

jalet

Message:

added a method to set the limit date

Location:

pykota/trunk/pykota

Files:

• storages/sql.py (modified) (2 diffs)
• tool.py (modified) (2 diffs)

pykota/trunk/pykota/storages/sql.py

@@ -15 +15 @@
 #
 # $Log$
+# Revision 1.10  2003/02/06 15:03:11  jalet
+# added a method to set the limit date
+#
 # Revision 1.9  2003/02/06 14:52:35  jalet
 # Forgotten import
@@ -123 +126 @@
             self.doQuery("UPDATE userpquota SET softlimit=%s, hardlimit=%s, datelimit=NULL WHERE userid=%s AND printerid=%s;" % (self.doQuote(softlimit), self.doQuote(hardlimit), self.doQuote(userid), self.doQuote(printerid)))
         
+    def setDateLimit(username, printername, datelimit) :
+        """Sets the limit date for a soft limit to become an hard one given (username, printername)."""
+        (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)))
+        
     def updateUserPQuota(self, username, printername, pagecount) :
         """Updates the used user Quota information given (username, printername) and a job size in pages."""

pykota/trunk/pykota/tool.py

@@ -15 +15 @@
 #
 # $Log$
+# Revision 1.10  2003/02/06 15:03:11  jalet
+# added a method to set the limit date
+#
 # Revision 1.9  2003/02/06 10:39:23  jalet
 # Preliminary edpykota work.
@@ -193 +196 @@
                          if datelimit is None :
                              datelimit = now + gracedelay
-                             self.storage.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(self.getUserId(username)), self.doQuote(self.getPrinterId(printername))))
+                             self.storage.setDateLimit(username, printername, datelimit)
                          if (now + gracedelay) < datelimit :
                              action = "WARN"