def __init__(self, chessfile, append_pgn=False):
self.chessfile = chessfile
self.append_pgn = append_pgn
self.db_handle = chessfile.handle
self.engine = chessfile.engine
self.conn = self.engine.connect()
self.CHUNK = 1000
self.cancel = False
self.count_source = select([func.count()]).select_from(source)
self.ins_event = event.insert()
self.ins_site = site.insert()
self.ins_player = player.insert()
self.ins_annotator = annotator.insert()
self.ins_source = source.insert()
self.ins_game = game.insert()
self.ins_tag_game = tag_game.insert()
self.event_dict = {}
self.site_dict = {}
self.player_dict = {}
self.annotator_dict = {}
self.source_dict = {}
self.next_id = [0, 0, 0, 0, 0, 0]
self.next_id[GAME] = self.ini_names(game, GAME)
self.next_id[EVENT] = self.ini_names(event, EVENT)
self.next_id[SITE] = self.ini_names(site, SITE)
self.next_id[PLAYER] = self.ini_names(player, PLAYER)
self.next_id[ANNOTATOR] = self.ini_names(annotator, ANNOTATOR)
self.next_id[SOURCE] = self.ini_names(source, SOURCE)
def initialize(self):
self.db_handle = self.chessfile.handle
self.engine = self.chessfile.engine
self.conn = self.engine.connect()
self.CHUNK = 1000
self.count_source = select([func.count()]).select_from(source)
self.ins_event = event.insert()
self.ins_site = site.insert()
self.ins_player = player.insert()
self.ins_annotator = annotator.insert()
self.ins_source = source.insert()
self.ins_game = game.insert()
self.ins_tag_game = tag_game.insert()
self.event_dict = {}
self.site_dict = {}
self.player_dict = {}
self.annotator_dict = {}
self.source_dict = {}
self.next_id = [0, 0, 0, 0, 0, 0]
self.next_id[GAME] = self.ini_names(game, GAME)
self.next_id[EVENT] = self.ini_names(event, EVENT)
self.next_id[SITE] = self.ini_names(site, SITE)
self.next_id[PLAYER] = self.ini_names(player, PLAYER)
self.next_id[ANNOTATOR] = self.ini_names(annotator, ANNOTATOR)
self.next_id[SOURCE] = self.ini_names(source, SOURCE)
def __init__(self, engine):
self.engine = engine
self.conn = self.engine.connect()
self.CHUNK = 1000
self.cancel = False
self.ins_event = event.insert()
self.ins_site = site.insert()
self.ins_player = player.insert()
self.ins_annotator = annotator.insert()
self.ins_source = source.insert()
self.ins_game = game.insert()
self.ins_bitboard = bitboard.insert()
self.ins_tag_game = tag_game.insert()
self.event_dict = {}
self.site_dict = {}
self.player_dict = {}
self.annotator_dict = {}
self.source_dict = {}
self.next_id = [0, 0, 0, 0, 0, 0]
self.next_id[GAME] = self.ini_names(game, GAME)
self.next_id[EVENT] = self.ini_names(event, EVENT)
self.next_id[SITE] = self.ini_names(site, SITE)
self.next_id[PLAYER] = self.ini_names(player, PLAYER)
self.next_id[ANNOTATOR] = self.ini_names(annotator, ANNOTATOR)
self.next_id[SOURCE] = self.ini_names(source, SOURCE)
s = select([player.c.fideid, player.c.id])
self.fideid_dict = dict([(p[0], p[1]) for p in self.conn.execute(s)])
self.perfix_stmt = select([player.c.id]).where(
player.c.name.startswith(bindparam('name')))