def write_survey(course_name, course_session, starttime, endtime,
questions):
session = DBSession()
state = 'created'
if starttime < datetime.now():
state = 'review'
if endtime < datetime.now():
state = 'deactivate'
new_survey = models.Survey(course_name=course_name,
course_session=course_session,
starttime=starttime,
endtime=endtime,
state=state)
session.add(new_survey)
for qid in questions:
new_question = models.SurveyQStore(course_name=course_name,
course_session=course_session,
qid=qid)
session.add(new_question)
try:
session.commit()
except:
return False
session.close()
return True
def get_enrolment(user_id):
session = DBSession()
courses = session.query(
models.Enrolment).filter(models.Enrolment.uid == user_id).all()
session.close()
return courses
def get_respondents(course_name, course_session):
session = DBSession()
respondents = session.query(models.Enrolment).filter(
models.Enrolment.course_name == course_name).filter(
models.Enrolment.course_session == course_session).all()
# remove rows which are staff checked from the user table
session.close()
return len(respondents)
def get_responses(course_name, course_session):
session = DBSession()
responses = session.query(models.Responses).filter(
models.Responses.course_name == course_name).filter(
models.Responses.course_session == course_session).all()
session.close()
return responses
def get_unnaproved_guests():
session = DBSession()
guests = session.query(
models.Guest).filter(models.Guest.enrolled == 'False').all()
session.close()
return guests
def get_user(identifier):
session = DBSession()
user = session.query(
models.User).filter(models.User.uid == identifier).first()
session.close()
return user
def get_all_surveys():
session = DBSession()
surveys = session.query(models.Survey).all()
session.close()
for survey in surveys:
SurveyController.set_deactivate_after_end(survey)
SurveyController.set_review_after_start(survey)
return surveys
def get_question(id): # [id, question, answers, deleted]
session = DBSession()
question = session.query(
models.Question).filter(models.Question.id == id).first()
session.close()
return [
question.id, question.question,
QuestionController.reformat_ans(question.ans), question.deleted
]
def close_survey(course_name, course_session):
session = DBSession()
survey = session.query(models.Survey).filter(
models.Survey.course_name == course_name).filter(
models.Survey.course_session == course_session).first()
if survey.endtime < datetime.now():
survey.state = 'closed'
session.commit()
session.close
def num_answers(course_name: str, course_session: str, qid: int,
answer: int):
print(course_name, course_session, qid, answer)
session = DBSession()
responses = session.query(models.Responses.id).filter(
models.Responses.course_name == course_name).filter(
models.Responses.course_session == course_session).filter(
models.Responses.qid == qid).filter(
models.Responses.response == str(answer)).all()
n = len(responses)
session.close()
return n
def get_survey_questions(course_name, course_session):
session = DBSession()
q_stores = session.query(models.SurveyQStore).filter(
models.SurveyQStore.course_name == course_name).filter(
models.SurveyQStore.course_session == course_session).all()
questions = []
for q in q_stores:
questions.append(QuestionController.get_question(q.qid))
session.close()
return questions
def write_user(
user_rep
): # user_rep = [identifier, password, role] guest has an extra field for enrolment application
session = DBSession()
if user_rep[2] != 'guest':
new_user = models.User(uid=user_rep[0],
password=user_rep[1],
role=user_rep[2])
else:
new_user = models.Guest(uid=user_rep[0],
password=user_rep[1],
role=user_rep[2],
enrolled='False')
enrolment = user_rep[3].split(' ')
EnrolmentController.write_enrolment(
[enrolment[0], enrolment[1], user_rep[0]])
session.add(new_user)
success = True
try:
session.commit()
except:
success = False
session.close()
return success
def get_survey(course_name, course_session):
session = DBSession()
survey = session.query(models.Survey).filter(
models.Survey.course_name == course_name).filter(
models.Survey.course_session == course_session).first()
session.close()
try:
SurveyController.set_deactivate_after_end(survey)
SurveyController.set_review_after_start(survey)
except AttributeError:
print("no survey for {} {}".format(course_name, course_session))
return survey
def check_password(user_name, password):
session = DBSession()
user = session.query(
models.User).filter(models.User.uid == user_name).first()
session.close()
try:
if user.password == password:
return True
else:
return False
except AttributeError:
return False
def get_optional_questions():
session = DBSession()
questions = session.query(models.Question).filter(
models.Question.is_optional == 'True').all()
question_list = []
for question in questions:
question_list.append([
question.id, question.question,
QuestionController.reformat_ans(question.ans), question.deleted
])
session.close()
return question_list
def write_response(course_name, course_session, qid, response):
session = DBSession()
response = models.Responses(course_name=course_name,
course_session=course_session,
qid=qid,
response=response)
session.add(response)
try:
session.commit()
except:
session.close()
return False
session.close()
return True
def write_course(course_rep): # course_rep = [name, session]
session = DBSession()
new_course = models.Course(name=course_rep[0], session=course_rep[1])
session.add(new_course)
try:
session.commit()
except:
pass
session.close()
def delete_question(question_id):
session = DBSession()
question = session.query(
models.Question).filter(models.Question.id == question_id).first()
question.deleted = 'True'
session.commit()
session.close()
def survey_add_questions(course, questions):
session = DBSession()
course_list = course.split(" ")
for qid in questions:
new_question = models.SurveyQStore(course_name=course_list[0],
course_session=course_list[1],
qid=qid)
session.add(new_question)
session.commit()
session.close()
def approve_enrolment(user_id):
session = DBSession()
user = session.query(
models.Guest).filter(models.Guest.uid == user_id).first()
user.enrolled = "True"
session.commit()
session.close()
def set_survey_active(course_name, course_session):
session = DBSession()
survey = session.query(models.Survey).filter(
models.Survey.course_name == course_name).filter(
models.Survey.course_session == course_session).first()
survey.state = 'active'
session.commit()
session.close()
def set_survey_completed(course_name, course_session, user_id):
session = DBSession()
enrolment = session.query(
models.Enrolment).filter(models.Enrolment.uid == user_id).filter(
models.Enrolment.course_name == course_name).filter(
models.Enrolment.course_session == course_session).first()
enrolment.completed = 'True'
session.commit()
session.close()
def write_enrolment(
enrolment_rep
): # enrolment_rep = [course_name, course_session, user_id]
session = DBSession()
new_enrolment = models.Enrolment(course_name=enrolment_rep[0],
course_session=enrolment_rep[1],
uid=enrolment_rep[2],
completed='False')
session.add(new_enrolment)
try:
session.commit()
except:
pass
session.close()
def write_question(
question_rep
): # question_rep = [question_text, [answers], is_optional]
session = DBSession()
new_question = models.Question(question=question_rep[0],
ans="|".join(question_rep[1]),
deleted='False',
is_optional=question_rep[2])
session.add(new_question)
try:
session.commit()
except:
print('error: Question alread exists!')
return False
session.close()
return True
def check_guest_approved(identifier):
session = DBSession()
guest = session.query(
models.Guest).filter(models.Guest.uid == identifier).first()
if guest == None:
return True
if guest.enrolled == 'False':
session.close()
return False
else:
session.close()
return True
def set_review_after_start(survey):
if survey.starttime < datetime.now():
session = DBSession()
sur = session.query(models.Survey).filter(
models.Survey.course_name == survey.course_name).filter(
models.Survey.course_session ==
survey.course_session).first()
if sur.state == 'created':
sur.state = 'review'
session.commit()
session.close()
def set_deactivate_after_end(survey):
if survey.endtime < datetime.now():
session = DBSession()
sur = session.query(models.Survey).filter(
models.Survey.course_name == survey.course_name).filter(
models.Survey.course_session ==
survey.course_session).first()
if sur.state == 'created' or sur.state == 'review':
sur.state = 'deactivate'
elif sur.state == 'active':
sur.state = 'adeactivate'
session.commit()
session.close()
def get_all_questions(mandatory_only):
session = DBSession()
if mandatory_only == 'True':
questions = session.query(models.Question).filter(
models.Question.is_optional == 'False').all()
else:
questions = session.query(models.Question).all()
question_list = []
for question in questions:
question_list.append([
question.id, question.question,
QuestionController.reformat_ans(question.ans),
question.deleted, question.is_optional
])
session.close()
return question_list
def get_courses():
session = DBSession()
session.close()
return session.query(models.Course).all()