From f904b1b552134e6b8701d9d94c7fed321011ae94 Mon Sep 17 00:00:00 2001
From: yo mama <pepper@scannerjammer.com>
Date: Fri, 11 Sep 2015 18:54:37 -0700
Subject: finished the params class, almost done with pb master class

---
 Db/__init__.py | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

(limited to 'Db')

diff --git a/Db/__init__.py b/Db/__init__.py
index c42a7c5..f4ebc57 100644
--- a/Db/__init__.py
+++ b/Db/__init__.py
@@ -35,8 +35,7 @@ class Db(object):
       HOST,
       DATABASE
     ))
-    Session = sessionmaker(bind=engine)
-    self.session = Session()
+    self.Session = sessionmaker(bind=engine)
 
   def insert_cmd (
     self, 
@@ -62,6 +61,7 @@ class Db(object):
 #    sys.stderr.write("dataobj={}".format(str(dataobj)) + "\n")
 #    sys.stderr.write("tag={}".format(str(tag)) + "\n")
     try:
+      session = self.Session()
       entry = ImCmd(
         date=date,
         remote_addr=remote_addr,
@@ -74,8 +74,9 @@ class Db(object):
         dataobj=dataobj,
         tag=tag
       )
-      self.session.add(entry)
-      self.session.commit()
+      session.add(entry)
+      session.commit()
+      #FIXME session.close()....
     except Exception as e:
-      sys.stderr.write("Unable to commit database entry");
+      sys.stderr.write("Unable to commit database entry\n");
       sys.stderr.write(str(e))
-- 
cgit v1.2.3-70-g09d2