def get_by_event_and_class(cls, event_id, weightclass_code):
db = DataInterface(CONSTANTS.DB_NAME)
sql = "SELECT * FROM %s WHERE event_id = %d AND weightclass_code = '%s'" % (
cls.__name__, int(event_id), weightclass_code)
result = db.fetch_multiple(sql)
return [cls(**(item)) for item in result if item]
def get_by_bracket(cls, bracket_id, order=None):
db = DataInterface(CONSTANTS.DB_NAME)
sql = "SELECT * FROM %s WHERE bracket_id = %d" % (cls.__name__,
int(bracket_id))
if order:
sql = "%s ORDER BY %s" % (sql, order)
return [cls(**(item)) for item in db.fetch_multiple(sql)]
def get_by_event_and_class(cls, event_id, weightclass_code):
db = DataInterface(CONSTANTS.DB_NAME)
sql = "SELECT * FROM %s WHERE event_id = %d AND weightclass_code = '%s'" % (cls.__name__, int(event_id), weightclass_code)
result = db.fetch_multiple(sql)
return [cls(**(item)) for item in result if item]
def get_by_event(cls, event_id, order=None):
db = DataInterface(CONSTANTS.DB_NAME)
sql = "SELECT distinct w.* FROM weightclass w, bot b WHERE b.event_id = %d AND b.weightclass = w.code AND b.registered_ind = 'Y' ORDER BY w.code ASC" % int(event_id)
results = db.fetch_multiple(sql)
return [cls(**(item)) for item in results if item]
