def update_exam_config(exam_config):
session_exam_config_app.query(ExamConfig).filter_by(
id=exam_config.id, exam_owner_id=exam_config.exam_owner_id).update({
'random_question':
exam_config.random_question,
'start_time':
exam_config.start_time,
'end_time':
exam_config.end_time,
'question_per_page':
exam_config.question_per_page,
'duration_minute':
exam_config.duration_minute,
'exam_title':
exam_config.exam_title,
'exam_name':
exam_config.exam_name,
'time_zone':
exam_config.time_zone,
'time_zone':
exam_config.time_zone,
'total_question':
exam_config.total_question
})
session_exam_config_app.commit()
def candidate_login(email, exam_config_id, password_hash):
candidate = session_candidate_app.query(Candidate).filter_by(
email=email,
exam_config_id=exam_config_id,
password_hash=password_hash).first()
session_candidate_app.commit()
dt = datetime.utcnow()
if candidate is not None:
if candidate.end_time is not None:
return "C"
exam_config = session_exam_config_app.query(ExamConfig).\
filter_by(id=candidate.exam_config_id, exam_owner_id=candidate.exam_owner_id).first()
session_exam_config_app.commit()
if exam_config.end_time < dt:
return "TO"
return candidate
def get_exam_config_by_id(exam_config_id):
exam_config = session_exam_config_app.query(ExamConfig).filter_by(
id=exam_config_id).first()
session_exam_config_app.commit()
return exam_config
def get_exam_config_all(exam_owner_id):
exam_config_all = session_exam_config_app.query(ExamConfig).filter_by(
exam_owner_id=exam_owner_id).all()
session_exam_config_app.commit()
return exam_config_all
def delete_exam_config(exam_config_id, exam_owner_id):
exam_config = ExamConfig.query.filter_by(
id=exam_config_id, exam_owner_id=exam_owner_id).first()
session_exam_config_app.delete(exam_config)
session_exam_config_app.commit()
def create_exam_config(exam_config):
session_exam_config_app.add(exam_config)
session_exam_config_app.commit()