diff options
| author | Pepper <pepper@scannerjammer.com> | 2015-05-20 11:16:13 -0400 |
|---|---|---|
| committer | Pepper <pepper@scannerjammer.com> | 2015-05-20 11:16:13 -0400 |
| commit | a4916103efb2d97896c456ff0e83064b21e85d25 (patch) | |
| tree | b3eb529e4b96375109626bbeada35d4f8a2667ee /feeder/asdf_db.py | |
| parent | 3790eedc2f48c725c586b8c7b924875fedbeb7b4 (diff) | |
first commit in a while
Diffstat (limited to 'feeder/asdf_db.py')
| -rwxr-xr-x | feeder/asdf_db.py | 31 |
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() + |
