コード例 #1
0
    def get_by_bracket_source_match(cls, bracket_id, source_match):
        db = DataInterface(CONSTANTS.DB_NAME)
        sql = "SELECT * FROM %s WHERE bracket_id = %d AND (bot1_source_match = '%s' OR bot2_source_match = '%s')" % (
            cls.__name__, int(bracket_id), source_match, source_match)

        result = db.fetch_one(sql)
        return cls(**(result)) if result else None
コード例 #2
0
    def get_by_bracket_round(cls, bracket_id, round):
        db = DataInterface(CONSTANTS.DB_NAME)
        sql = "SELECT * FROM %s WHERE bracket_id = %d and round='%s' ORDER BY number" % (
            cls.__name__, int(bracket_id), round)

        results = db.fetch_multiple(sql)
        return [cls(**(item)) for item in results if item]
コード例 #3
0
    def get_by_bracket_seed(cls, event_id, bracket_id, seed):
        db = DataInterface(CONSTANTS.DB_NAME)
        sql = "SELECT * FROM %s WHERE event_id = %d AND seed_number = %d AND bracket_id = %d" % (
            cls.__name__, int(event_id), seed, bracket_id)
        result = db.fetch_one(sql)

        return cls(**(result)) if result else None
コード例 #4
0
ファイル: bot.py プロジェクト: kaldonis/ft-event-manager
    def get_by_bracket_seed(cls, event_id, bracket_id, seed):
        db = DataInterface(CONSTANTS.DB_NAME)
        sql = "SELECT * FROM %s WHERE event_id = %d AND seed_number = %d AND bracket_id = %d" % (cls.__name__, int(event_id), seed, bracket_id)
        result = db.fetch_one(sql)

        return cls(**(result)) if result else None
コード例 #5
0
ファイル: match.py プロジェクト: kaldonis/ft-event-manager
    def get_by_bracket_source_match(cls, bracket_id, source_match):
        db = DataInterface(CONSTANTS.DB_NAME)
        sql = "SELECT * FROM %s WHERE bracket_id = %d AND (bot1_source_match = '%s' OR bot2_source_match = '%s')" % (cls.__name__, int(bracket_id), source_match, source_match)

        result = db.fetch_one(sql)
        return cls(**(result)) if result else None
コード例 #6
0
ファイル: match.py プロジェクト: kaldonis/ft-event-manager
    def get_by_bracket_round(cls, bracket_id, round):
        db = DataInterface(CONSTANTS.DB_NAME)
        sql = "SELECT * FROM %s WHERE bracket_id = %d and round='%s' ORDER BY number" % (cls.__name__, int(bracket_id), round)

        results = db.fetch_multiple(sql)
        return [cls(**(item)) for item in results if item]