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, 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 __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')))
def __init__(self): self.conn = engine.connect() self.ins_collection = collection.insert() self.ins_event = event.insert() self.ins_site = site.insert() self.ins_player = player.insert() self.ins_annotator = annotator.insert() self.ins_game = game.insert() self.collection_dict = {} self.event_dict = {} self.site_dict = {} self.player_dict = {} self.annotator_dict = {} self.next_id = [0, 0, 0, 0, 0] self.next_id[COLLECTION] = self.ini_names(collection, COLLECTION) 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)