def doLogin(login, password): session = TorneiraSession() try: user = session.query(User).filter(User.login == login).filter( User.password == password).one() return user except NoResultFound: return None
def save(self): session = TorneiraSession() if not self.id: session.add(self) session.flush()
def delete(self): session = TorneiraSession() session.delete(self) session.flush()
def all(cls, limit=None): session = TorneiraSession() if limit: return session.query(cls).all()[limit[0]:limit[1]] return session.query(cls).all()
def fetch_by(cls, **kw): session = TorneiraSession() return session.query(cls).filter_by(**kw)
def get(cls, id): session = TorneiraSession() return session.query(cls).get(id)