finished the params class, almost done with pb master class

1 files changed, 6 insertions, 5 deletions

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))