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]
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]
