def add(cls, account): DBSession.add(account) DBSession.flush() # This is required to set the ID.
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()