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

Timestamp:

02/08/03 23:39:46 (21 years ago)

Author:

jalet

Message:

--reset command line option added

Files:

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

pykota/trunk/pykota/storages/sql.py

@@ -15 +15 @@
 #
 # $Log$
+# Revision 1.16  2003/02/08 22:39:46  jalet
+# --reset command line option added
+#
 # Revision 1.15  2003/02/08 22:12:09  jalet
 # Life time counter for users and groups added.
@@ -135 +138 @@
         
     def addUserPQuota(self, username, printername) :
+        """Initializes a user print quota on a printer, adds the printer and the user to the quota storage if needed."""
         (userid, printerid) = self.getUPIds(username, printername)
         if printerid is None :    
@@ -152 +156 @@
         (userid, printerid) = self.getUPIds(username, printername)
         if (userid is not None) and (printerid is not None) :
-            result = self.doQuery("SELECT pagecounter, softlimit, hardlimit, datelimit FROM userpquota WHERE userid=%s AND printerid=%s;" % (self.doQuote(userid), self.doQuote(printerid)))
+            result = self.doQuery("SELECT lifepagecounter, pagecounter, softlimit, hardlimit, datelimit FROM userpquota WHERE userid=%s AND printerid=%s;" % (self.doQuote(userid), self.doQuote(printerid)))
             try :
                 return self.doParseResult(result)[0]
@@ -163 +167 @@
         if (userid is not None) and (printerid is not None) :
             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 resetUserPQuota(self, username, printername) :    
+        """Resets the page counter to zero. Life time page counter is kept unchanged."""
+        (userid, printerid) = self.getUPIds(username, printername)
+        if (userid is not None) and (printerid is not None) :
+            self.doQuery("UPDATE userpquota SET pagecounter=0 WHERE userid=%s AND printerid=%s;" % (self.doQuote(userid), self.doQuote(printerid)))
         
     def setDateLimit(self, username, printername, datelimit) :