def by_id(assignment_id):
session = SessionFactory()
try:
return session.query(Assignment).filter(
Assignment.id == assignment_id).one()
finally:
session.close()
def by_id(uid):
session = SessionFactory()
try:
return session.query(User).filter(User.id == uid).one()
except NoResultFound:
return None
finally:
session.close()
def by_id(mid):
session = SessionFactory()
try:
return session.query(Match).filter(Match.id==mid).one()
except NoResultFound:
return None
finally:
session.close()
def set_last_online(self, when):
session = SessionFactory()
try:
user = session.query(User).filter_by(id=self.id).one()
user.last_online = when
session.add(user)
session.commit()
finally:
session.close()
def get_user(cls, username):
session = SessionFactory()
try:
user = session.query(User).filter_by(username=username).one()
return user
except NoResultFound:
user = User(username)
session.add(user)
session.commit()
print "Created new user entry in the database for user '{}'.".format(username)
finally:
session.close()
# If the entry for the user was just created then retreive the committed version
session = SessionFactory()
try:
user = session.query(User).filter_by(username=username).one()
return user
except NoResultFound:
return None
finally:
session.close()
def by_id(assignment_id):
session = SessionFactory()
try:
return session.query(Assignment).filter(Assignment.id==assignment_id).one()
finally:
session.close()
