Fix(sqlite): Execute VACUUM outside transaction

[m_librarian.git] / m_librarian / glst.py

diff --git a/m_librarian/glst.py b/m_librarian/glst.py
index f639c1b3b6d4cb58bb6c1e58e3262336376845e4..5864d7f9687ab4a318b4d39ad20e1d72d7a1a7f3 100755 (executable)
--- a/m_librarian/glst.py
+++ b/m_librarian/glst.py
@@ -48,18 +48,22 @@ def _import_glst():
     old_nonfb2, new_nonfb2 = import_glst_file(
         os.path.join(ml_dir, 'glst', 'genres_nonfb2.glst'))
     connection = sqlhub.processConnection
-    if connection.dbName in ('postgres', 'sqlite'):
+    if connection.dbName == 'postgres':
         connection.query("VACUUM %s" % Genre.sqlmeta.table)
     return old_fb2 + old_nonfb2, new_fb2 + new_nonfb2
 
 
 def import_glst():
     return sqlhub.doInTransaction(_import_glst)
+    connection = sqlhub.processConnection
+    if connection.dbName == 'sqlite':
+        connection.query("VACUUM")
 
 
 def test():
     ml_dir = os.path.dirname(__file__)
     print(parse_glst_file(os.path.join(ml_dir, 'glst', 'genres_fb2.glst')))
 
+
 if __name__ == '__main__':
     test()