summaryrefslogtreecommitdiff
path: root/feeder/asdf_db.py
diff options
context:
space:
mode:
authorPepper <pepper@scannerjammer.com>2015-05-20 11:16:13 -0400
committerPepper <pepper@scannerjammer.com>2015-05-20 11:16:13 -0400
commita4916103efb2d97896c456ff0e83064b21e85d25 (patch)
treeb3eb529e4b96375109626bbeada35d4f8a2667ee /feeder/asdf_db.py
parent3790eedc2f48c725c586b8c7b924875fedbeb7b4 (diff)
first commit in a while
Diffstat (limited to 'feeder/asdf_db.py')
-rwxr-xr-xfeeder/asdf_db.py31
1 files changed, 31 insertions, 0 deletions
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()
+