def conferences(): return Select( fields = Fields.conference(), source = Tables.conference(), filter = Filter(None), order = Order("abbreviation"), ).execute(cursor())
def conference(id = None, abbreviation = None): assert (id is not None) ^ (abbreviation is not None) filter = None if id is not None: filter = Filter("conference = %d" % id) else: filter = Filter("abbreviation = '%s'" % abbreviation) c = cursor() conferences = Select( fields = Fields.conference(), source = Tables.conference(), filter = filter, order = Order(None), ).execute(c) if len(conferences) == 0: return None else: return conferences[0].__dict__