From 4100860d10e2fb015db01d22bbf3f4735bcf10ec Mon Sep 17 00:00:00 2001 From: yo mama Date: Fri, 13 Feb 2015 01:33:31 -0800 Subject: first --- impattern/im/cgi-bin/db.py | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100755 impattern/im/cgi-bin/db.py (limited to 'impattern/im/cgi-bin/db.py') 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() -- cgit v1.2.3-70-g09d2