#! /usr/bin/env python
-__all__ = ['import_glst']
-
+from __future__ import print_function
import codecs
import os
from sqlobject import sqlhub, SQLObjectNotFound
from .db import Genre
+__all__ = ['import_glst']
+
def parse_glst_file(glst_filename):
glst_file = codecs.open(glst_filename, 'r', 'utf-8')
- genre_list = []
try:
for line in glst_file:
line = line.strip()
name, title = parts[1].split(';', 1)
except (IndexError, ValueError):
continue
- genre_list.append((name, title))
+ yield name, title
finally:
glst_file.close()
- return genre_list
def import_glst_file(glst_filename):
os.path.join(ml_dir, 'glst', 'genres_fb2.glst'))
old_nonfb2, new_nonfb2 = import_glst_file(
os.path.join(ml_dir, 'glst', 'genres_nonfb2.glst'))
- sqlhub.processConnection.query("VACUUM %s" % Genre.sqlmeta.table)
+ connection = sqlhub.processConnection
+ 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'))
+ print(parse_glst_file(os.path.join(ml_dir, 'glst', 'genres_fb2.glst')))
+
if __name__ == '__main__':
test()