1 files changed, 7 insertions, 3 deletions

diff --git a/atoidejouer/db/story.py b/atoidejouer/db/story.py
index d10cd87..426baa1 100644
--- a/atoidejouer/db/story.py
+++ b/atoidejouer/db/story.py
@@ -287,20 +287,19 @@ class DB(object):
 
         def __create(self):
             cur = self.con.cursor()
-            # remove all first
             try:
                 cur.execute("drop table %s" % self.name)
             except Exception, e:
                 pass
-            # create fresh db
             cur.execute(self.obj().create())
-            # and close
+            self.con.commit()
             cur.close()
 
         def add(self, obj):
             cur = self.con.cursor()
             cur.execute(obj.insert())
             count = cur.rowcount
+            self.con.commit()
             cur.close()
             return count
 
@@ -345,6 +344,7 @@ class DB(object):
             cur = self.con.cursor()
             cur.execute(obj.update())
             rowcount = cur.rowcount
+            self.con.commit()
             cur.close()
             return rowcount
 
@@ -353,9 +353,13 @@ class DB(object):
             obj = self.obj() if obj is None else obj
             cur.execute(obj.delete(all=all))
             rowcount = cur.rowcount
+            self.con.commit()
             cur.close()
             return rowcount
 
+        def close(self):
+            self.con.close()
+
     # singleton instance
     instance = None