Changeset 765

Timestamp:

02/08/03 23:12:09 (21 years ago)

Author:

jalet

Message:

Life time counter for users and groups added.

Location:

pykota/trunk

Files:

• initscripts/pykota-postgresql.sql (modified) (3 diffs)
• pykota/storages/sql.py (modified) (2 diffs)

pykota/trunk/initscripts/pykota-postgresql.sql

@@ -14 +14 @@
 --
 -- $Log$
+-- Revision 1.2  2003/02/08 22:12:09  jalet
+-- Life time counter for users and groups added.
+--
 -- Revision 1.1  2003/02/05 21:28:17  jalet
 -- Initial import into CVS
@@ -69 +72 @@
                         userid INT4 REFERENCES users(id),
                         printerid INT4 REFERENCES printers(id),
+                        lifepagecounter INT4 DEFAULT 0,
                         pagecounter INT4 DEFAULT 0,
                         softlimit INT4,
@@ -80 +84 @@
                          groupid INT4 REFERENCES groups(id),
                          printerid INT4 REFERENCES printers(id),
+                         lifepagecounter INT4 DEFAULT 0,
                          pagecounter INT4 DEFAULT 0,
                          softlimit INT4,

pykota/trunk/pykota/storages/sql.py

@@ -15 +15 @@
 #
 # $Log$
+# Revision 1.15  2003/02/08 22:12:09  jalet
+# Life time counter for users and groups added.
+#
 # Revision 1.14  2003/02/07 22:13:13  jalet
 # Perhaps edpykota is now able to add printers !!! Oh, stupid me !
@@ -171 +174 @@
         (userid, printerid) = self.getUPIds(username, printername)
         if (userid is not None) and (printerid is not None) :
-            self.doQuery("UPDATE userpquota SET pagecounter=pagecounter+(%s) WHERE userid=%s AND printerid=%s;" % (self.doQuote(pagecount), self.doQuote(userid), self.doQuote(printerid)))
+            self.doQuery("UPDATE userpquota SET lifepagecounter=lifepagecounter+(%s), pagecounter=pagecounter+(%s) WHERE userid=%s AND printerid=%s;" % (self.doQuote(pagecount), self.doQuote(pagecount), self.doQuote(userid), self.doQuote(printerid)))
         
     def buyUserPQuota(self, username, printername, pagebought) :