summaryrefslogtreecommitdiff
path: root/impattern/im/cgi-bin/db.py
diff options
context:
space:
mode:
authoryo mama <pepper@scannerjammer.com>2015-02-13 01:33:31 -0800
committeryo mama <pepper@scannerjammer.com>2015-02-13 01:33:31 -0800
commit4100860d10e2fb015db01d22bbf3f4735bcf10ec (patch)
tree995b51fe3f8a6fe7fb58938c83463f3b09b5ee7c /impattern/im/cgi-bin/db.py
first
Diffstat (limited to 'impattern/im/cgi-bin/db.py')
-rwxr-xr-ximpattern/im/cgi-bin/db.py29
1 files changed, 29 insertions, 0 deletions
diff --git a/impattern/im/cgi-bin/db.py b/impattern/im/cgi-bin/db.py
new file mode 100755
index 0000000..4da7b83
--- /dev/null
+++ b/impattern/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()