def is_mentor(name): with session_factory() as sess: try: sess.query(User).filter(User.slack == name, ).one() return True except NoResultFound: return False
def from_name(name): with session_factory() as sess: try: user = sess.query(User).filter(User.slack == name).one() sess.expunge(user) return user except NoResultFound: return None
def create(user, timestamp, request): with session_factory() as sess: Request(requester=user, assigned=-1, resolved=False, timestamp=timestamp, comment='', request=request).save()
def set_busy(name, busy): with session_factory() as sess: try: user = sess.query(User).filter(User.slack == name).one() user.is_busy = busy user.save() return True except NoResultFound: return False
def list(): with session_factory() as sess: users = sess.query(User).all() sess.expunge_all() return users