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