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)
