diff options
| author | yo mama <pepper@scannerjammer.com> | 2015-08-12 16:08:28 -0700 |
|---|---|---|
| committer | yo mama <pepper@scannerjammer.com> | 2015-08-12 16:08:28 -0700 |
| commit | 0a90d5fb89bb5baa0bc34fb0dcea134d6bc8e220 (patch) | |
| tree | 5544c44f60fd689f8dd7bac1c7beee4a8a972ee1 /pb/lib/db.py | |
| parent | 1340ec9d6986bbdec92d0d5c12df9ae2d78ec651 (diff) | |
cleanup successful, still testing
Diffstat (limited to 'pb/lib/db.py')
| -rwxr-xr-x | pb/lib/db.py | 54 |
1 files changed, 0 insertions, 54 deletions
diff --git a/pb/lib/db.py b/pb/lib/db.py deleted file mode 100755 index 66db35d..0000000 --- a/pb/lib/db.py +++ /dev/null @@ -1,54 +0,0 @@ -import MySQLdb -USER = "asdfus" -PASSWORD = "gTYgT&M6q" -DATABASE = "asdfus" - -class Db(object): - def __init__ (self): - self.conn = None - self.cursor = None - self.connect() - - def connect (self): - self.conn = MySQLdb.connect (host = "localhost", - user = USER, - passwd = PASSWORD, - db = DATABASE - ) - 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 self.conn.insert_id() - - def insert_cmd ( - self, - date=time.time(), - remote_addr="NULL", - username="NULL", - url="NULL", - directory="NULL", - oldfile="NULL", - newfile="NULL", - cmd="NULL", - dataobj="NULL", - tag="NULL"): - try: - sql = "INSERT INTO im_cmd " - sql += "(date, remote_addr, name, url, dir, oldfile, newfile, cmd, dataobj, tag) " - sql += "VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)" - #or "NULL" - args = (date, remote_addr, username, url, directory, oldfile, newfile, cmd, dataobj, tag) - #args = (now(), os.environ['REMOTE_ADDR'], name, url, dir, oldfile, newfile, " ".join(cmd),dataobj) - self.execute(sql, args) - except Exception as e: - sys.stderr.write(str(e)) - return |
