summaryrefslogtreecommitdiff
path: root/pb/lib/db.py
diff options
context:
space:
mode:
authoryo mama <pepper@scannerjammer.com>2015-08-12 16:08:28 -0700
committeryo mama <pepper@scannerjammer.com>2015-08-12 16:08:28 -0700
commit0a90d5fb89bb5baa0bc34fb0dcea134d6bc8e220 (patch)
tree5544c44f60fd689f8dd7bac1c7beee4a8a972ee1 /pb/lib/db.py
parent1340ec9d6986bbdec92d0d5c12df9ae2d78ec651 (diff)
cleanup successful, still testing
Diffstat (limited to 'pb/lib/db.py')
-rwxr-xr-xpb/lib/db.py54
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