def init_tag_database(self, importer=None): """ Create/open .sqlite database of game header tags """ # Import .pgn header tags to .sqlite database sqlite_path = self.path.replace(".pgn", ".sqlite") if os.path.isfile( self.path) and os.path.isfile(sqlite_path) and getmtime( self.path) > getmtime(sqlite_path): metadata.drop_all(self.engine) metadata.create_all(self.engine) ini_schema_version(self.engine) size = self.size if size > 0 and self.tag_database.count == 0: if size > 10000000: drop_indexes(self.engine) if self.progressbar is not None: from gi.repository import GLib GLib.idle_add(self.progressbar.set_text, _("Importing game headers...")) if importer is None: importer = PgnImport(self) importer.initialize() importer.do_import(self.path, progressbar=self.progressbar) if size > 10000000 and not importer.cancel: create_indexes(self.engine) return importer
def init_tag_database(self, importer=None): """ Create/open .sqlite database of game header tags """ # Import .pgn header tags to .sqlite database sqlite_path = self.path.replace(".pgn", ".sqlite") if os.path.isfile(self.path) and os.path.isfile(sqlite_path) and getmtime(self.path) > getmtime(sqlite_path): metadata.drop_all(self.engine) metadata.create_all(self.engine) ini_schema_version(self.engine) size = self.size if size > 0 and self.tag_database.count == 0: if size > 10000000: drop_indexes(self.engine) if self.progressbar is not None: GLib.idle_add(self.progressbar.set_text, _("Importing game headers...")) if importer is None: importer = PgnImport(self) importer.initialize() importer.do_import(self.path, progressbar=self.progressbar) if size > 10000000 and not importer.cancel: create_indexes(self.engine) return importer
and_( game.c.event_id==a1.c.id, game.c.site_id==a2.c.id, game.c.white_id==a3.c.id, game.c.black_id==a4.c.id)).where(and_(a3.c.name.startswith(unicode("Réti")), a4.c.name.startswith(unicode("Van Nüss")))) result = self.conn.execute(s) games = result.fetchall() for g in games: print("%s %s %s %s %s %s %s %s %s %s %s %s" % (g['id'], g['event'], g['site'], g['white'], g['black'], g[5], g[6], g[7], g['eco'], reprResult[g['result']], g['white_elo'], g['black_elo'])) if __name__ == "__main__": if 1: metadata.drop_all(engine) metadata.create_all(engine) imp = PgnImport() from .timer import Timer if len(sys.argv) > 1: arg = sys.argv[1] with Timer() as t: if arg[-4:].lower() in (".pgn", ".zip"): if os.path.isfile(arg): imp.do_import(arg) elif os.path.exists(arg): for file in sorted(os.listdir(arg)): if file[-4:].lower() in (".pgn", ".zip"): imp.do_import(os.path.join(arg, file))
game.c.black_id == a4.c.id)).where( and_(a3.c.name.startswith(unicode("Réti")), a4.c.name.startswith(unicode("Van Nüss")))) result = self.conn.execute(s) games = result.fetchall() for g in games: print("%s %s %s %s %s %s %s %s %s %s %s %s" % (g['id'], g['event'], g['site'], g['white'], g['black'], g[5], g[6], g[7], g['eco'], reprResult[g['result']], g['white_elo'], g['black_elo'])) if __name__ == "__main__": if 1: metadata.drop_all(engine) metadata.create_all(engine) imp = PgnImport() from .timer import Timer if len(sys.argv) > 1: arg = sys.argv[1] with Timer() as t: if arg[-4:].lower() in (".pgn", ".zip"): if os.path.isfile(arg): imp.do_import(arg) elif os.path.exists(arg): for file in sorted(os.listdir(arg)): if file[-4:].lower() in (".pgn", ".zip"): imp.do_import(os.path.join(arg, file))
def tearDown(self): metadata.drop_all(self.engine) metadata.create_all(self.engine)
def tearDown(self): if self.test_db is None: metadata.drop_all(self.engine) metadata.create_all(self.engine)