Changeset 2758

Timestamp:

02/27/06 15:28:53 (19 years ago)

Author:

jerome

Message:

Fixed incorrect initialization of page counters.

Files:

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

pykota/trunk/pykota/storages/sql.py

@@ -582 +582 @@
                                  self.doQuote(upq.WarnCount), \
                                  self.doQuote(upq.DateLimit), \
-                                 self.doQuote(upq.PageCounter), \
-                                 self.doQuote(upq.LifePageCounter), \
+                                 self.doQuote(upq.PageCounter or 0), \
+                                 self.doQuote(upq.LifePageCounter or 0), \
                                  self.doQuote(upq.MaxJobSize)))
         except PyKotaStorageError :                         
@@ -654 +654 @@
         """Saves the billing code to the database."""
         self.doModify("UPDATE billingcodes SET balance=%s, pagecounter=%s, description=%s WHERE id=%s" \
-                            % (self.doQuote(code.Balance), \
-                               self.doQuote(code.PageCounter), \
+                            % (self.doQuote(code.Balance or 0.0), \
+                               self.doQuote(code.PageCounter or 0), \
                                self.doQuote(self.userCharsetToDatabase(code.Description)), \
                                self.doQuote(code.ident)))
@@ -700 +700 @@
                                  self.doQuote(userpquota.WarnCount), \
                                  self.doQuote(userpquota.DateLimit), \
-                                 self.doQuote(userpquota.PageCounter), \
-                                 self.doQuote(userpquota.LifePageCounter), \
+                                 self.doQuote(userpquota.PageCounter or 0), \
+                                 self.doQuote(userpquota.LifePageCounter or 0), \
                                  self.doQuote(userpquota.MaxJobSize), \
                                  self.doQuote(userpquota.ident)))