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

Timestamp:

06/06/04 00:03:50 (20 years ago)

Author:

jalet

Message:

Payments history is now stored in database

Files:

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

pykota/trunk/pykota/storages/sql.py

@@ -22 +22 @@
 #
 # $Log$
+# Revision 1.41  2004/06/05 22:03:50  jalet
+# Payments history is now stored in database
+#
 # Revision 1.40  2004/06/03 23:14:11  jalet
 # Now stores the job's size in bytes in the database.
@@ -342 +345 @@
             self.doModify("UPDATE users SET balance=%s WHERE id=%s" % (self.doQuote(newbalance), self.doQuote(user.ident)))
             
+    def writeNewPayment(self, user, amount) :        
+        """Adds a new payment to the payments history."""
+        self.doModify("INSERT INTO payments (userid, amount) VALUES (%s, %s)" % (self.doQuote(user.ident), self.doQuote(amount)))
+        
     def writeLastJobSize(self, lastjob, jobsize, jobprice) :        
         """Sets the last job's size permanently."""