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]