fixed some basics

1 files changed, 29 insertions, 0 deletions

diff --git a/im/cgi-bin/db.py b/im/cgi-bin/db.py
new file mode 100755
index 0000000..4da7b83
--- /dev/null
+++ b/im/cgi-bin/db.py
@@ -0,0 +1,29 @@
+import MySQLdb
+import time
+
+def now ():
+        return int(time.mktime(time.localtime()))
+class db:
+        def __init__ (self):
+                self.conn = None
+                self.cursor = None
+                self.connect()
+
+        def connect (self):
+                self.conn = MySQLdb.connect (host = "127.0.0.1",
+          user = "asdfus",
+          passwd = "gTYgT&M6q",
+                                        db = "asdfus")
+                self.cursor = self.conn.cursor ()
+
+        def execute (self,sql,args=()):
+                try:
+                        self.cursor.execute(sql,args)
+                except MySQLdb.Error, e:
+                        print "Error %d: %s" % (e.args[0], e.args[1])
+                        # sys.exit (1)
+                        self.connect()
+                        self.cursor.execute(sql,args)
+
+        def lastinsertid (self):
+                return DB.conn.insert_id()