#! /usr/bin/env python
+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):
return old, new
-def _import_data():
+def _import_glst():
ml_dir = os.path.dirname(__file__)
old_fb2, new_fb2 = import_glst_file(
- os.path.join(ml_dir, 'data', 'genres_fb2.glst'))
+ os.path.join(ml_dir, 'glst', 'genres_fb2.glst'))
old_nonfb2, new_nonfb2 = import_glst_file(
- os.path.join(ml_dir, 'data', 'genres_nonfb2.glst'))
+ os.path.join(ml_dir, 'glst', 'genres_nonfb2.glst'))
+ connection = sqlhub.processConnection
+ if connection.dbName in ('postgres', 'sqlite'):
+ connection.query("VACUUM %s" % Genre.sqlmeta.table)
return old_fb2 + old_nonfb2, new_fb2 + new_nonfb2
-def import_data():
- return sqlhub.doInTransaction(_import_data)
+def import_glst():
+ return sqlhub.doInTransaction(_import_glst)
-if __name__ == '__main__':
+def test():
ml_dir = os.path.dirname(__file__)
- print parse_glst_file(os.path.join(ml_dir, 'data', 'genres_fb2.glst'))
+ print(parse_glst_file(os.path.join(ml_dir, 'glst', 'genres_fb2.glst')))
+
+if __name__ == '__main__':
+ test()