Fix(DB): Close connexions

diff --git a/ChangeLog b/ChangeLog
index 842d67ad827cf084a3f3130b438dc1ac0f865793..80643f1350fc150472970dd22842d1650fb3b750 100644 (file)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,6 +1,8 @@
 Version 5.1.1 (2024-02-24)
 
-   Python 3 Fix filesystem encoding.
+   Python 3: Fix filesystem encoding.
+
+   DB: Close connexions.
 
 Version 5.1.0 (2024-02-24)
 

diff --git a/xsetbg_db.py b/xsetbg_db.py
index 85cecc289f2b440df531adc1ee86e227ef9bac7f..ba5ab6c7630cccbdd55cd717000d8ab111f207a4 100755 (executable)
--- a/xsetbg_db.py
+++ b/xsetbg_db.py
@@ -49,9 +49,10 @@ class SQLiteMassInsert(object):
         return txn
 
     def __exit__(self, *args, **kw):
-        sqlhub.processConnection.commit()
+        sqlhub.processConnection.commit(close=True)
         connection = sqlhub.processConnection = self.connection
         connection.query("VACUUM")
+        connection.close()
 
 
 db_dirs = []