iro/acounting.py
changeset 56 3718abbfffd6
child 60 5ca3aa8d75e1
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/iro/acounting.py	Wed Nov 03 01:19:26 2010 +0100
@@ -0,0 +1,43 @@
+# -*- coding: utf-8 -*-
+
+from database import Database
+
+class Acounting(Database):
+    def __init__(self,id, connection):
+        Database.__init__(self,connection)
+        self.id=id
+
+    def setId(self,id):
+        self.id=id
+
+    def getStatus(self):
+        self.connect()
+        self.cursor.execute ("SELECT status,tel FROM %s WHERE id='%s'" % (self.connection['table'], self.id))
+        ret= self.cursor.fetchall()
+        self.disconnect()
+        return ret
+
+    def addGood(self, good,disconnect=True):
+        if type(good) == list:
+            for i in good:
+                self.addGood(i)
+            if disconnect:
+                self.disconnect()
+        else:
+            self.connect()
+            self.cursor.execute("INSERT INTO %s (id,tel,status) VALUES('%s','%s','sended')" % (self.connection['table'], self.id, good))
+            if disconnect:
+                self.disconnect()
+            
+
+    def addFailed(self, failed,disconnect=True):
+        if type(failed) == list:
+            for i in failed:
+                self.addFailed(i,False)
+            if disconnect:
+                self.disconnect()
+        else:
+            self.connect()
+            self.cursor.execute ("INSERT INTO %s (id,tel,status) VALUES('%s','%s','failed')"%(self.connection['table'], self.id, failed))
+            if disconnect:
+                self.disconnect()