From a4916103efb2d97896c456ff0e83064b21e85d25 Mon Sep 17 00:00:00 2001 From: Pepper Date: Wed, 20 May 2015 11:16:13 -0400 Subject: first commit in a while --- feeder/asdf_db.py | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100755 feeder/asdf_db.py (limited to 'feeder/asdf_db.py') diff --git a/feeder/asdf_db.py b/feeder/asdf_db.py new file mode 100755 index 0000000..981774e --- /dev/null +++ b/feeder/asdf_db.py @@ -0,0 +1,31 @@ +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 = "localhost", + #read_default_file = "~/.my.cnf", + user = "asdfus", + passwd = "3v3rcl34r", + 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