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

Timestamp:

04/16/03 10:53:14 (21 years ago)

Author:

jalet

Message:

Printing can now be limited either by user's account balance or by
page quota (the default). Quota report doesn't include account balance
yet, though.

Files:

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

pykota/trunk/pykota/storages/sql.py

@@ -21 +21 @@
 #
 # $Log$
+# Revision 1.26  2003/04/16 08:53:14  jalet
+# Printing can now be limited either by user's account balance or by
+# page quota (the default). Quota report doesn't include account balance
+# yet, though.
+#
 # Revision 1.25  2003/04/15 21:58:33  jalet
 # edpykota now accepts a --delete option.
@@ -234 +239 @@
             return
         
+    def getUserLimitBy(self, userid) :    
+        """Returns the way in which user printing is limited."""
+        result = self.doQuery("SELECT limitby FROM users WHERE id=%s" % self.doQuote(userid))
+        try :
+            return self.doParseResult(result)[0]["limitby"]
+        except TypeError :      # Not found    
+            return
+        
+    def getGroupLimitBy(self, groupid) :    
+        """Returns the way in which group printing is limited."""
+        result = self.doQuery("SELECT limitby FROM groups WHERE id=%s" % self.doQuote(groupid))
+        try :
+            return self.doParseResult(result)[0]["limitby"]
+        except TypeError :      # Not found    
+            return
+        
     def setUserBalance(self, userid, balance) :    
         """Sets the account balance for a given user to a fixed value."""