def list(cls): return DBSession.query(cls)
def by_name(cls, name): return DBSession.query(cls).filter(cls.name == name).first()
def like(cls, name): return DBSession.query(cls).filter(cls.name.like("%" + name + "%")).all()
def by_id(cls, id): return DBSession.query(cls).filter(cls.id == id).first()