def check_quiz(): engine = db_connect() create_deals_table(engine) Session = sessionmaker(bind=engine) sess = Session() if request.method == 'POST': category = request.form['category'] answers = {} correct_answers = {} wrong_answers = {} if category == categories[1]: for r in request.form: if r != 'category': answers[r] = request.form.getlist(r) for k, v in answers.items(): answers[k] = '.,'.join(v) answers[k] += '.' for k, v in answers.items(): q = sess.query(Question).filter( Question.question_number == k).first() if v == q.correct_answer: correct_answers[v] = q else: wrong_answers[v] = q else: for r in request.form: if r != 'category': answers[r] = request.form[r] for k, v in answers.items(): q = sess.query(Question).filter( Question.question_number == k).first() if v in q.correct_answer: correct_answers[v] = q else: wrong_answers[v] = q return render_template( 'results.html', title='Results', correct_answers=correct_answers, wrong_answers=wrong_answers)
def check_quiz(): engine = db_connect() create_deals_table(engine) Session = sessionmaker(bind=engine) sess = Session() if request.method == 'POST': category = request.form['category'] answers = {} correct_answers = {} wrong_answers = {} if category == categories[1]: for r in request.form: if r != 'category': answers[r] = request.form.getlist(r) for k, v in answers.items(): answers[k] = '.,'.join(v) answers[k] += '.' for k, v in answers.items(): q = sess.query(Question).filter( Question.question_number == k).first() if v == q.correct_answer: correct_answers[v] = q else: wrong_answers[v] = q else: for r in request.form: if r != 'category': answers[r] = request.form[r] for k, v in answers.items(): q = sess.query(Question).filter( Question.question_number == k).first() if v in q.correct_answer: correct_answers[v] = q else: wrong_answers[v] = q return render_template('results.html', title='Results', correct_answers=correct_answers, wrong_answers=wrong_answers)
def get_data(): engine = db_connect() create_deals_table(engine) Session = sessionmaker(bind=engine) sess = Session() if request.method == 'GET': section = int(request.args.get('section')) category = int(request.args.get('category')) q = sess.query(Question).filter( Question.section == sections[section], Question.type_of_quiz == categories[category]).order_by( Question.question_number).all() return render_template('quiz.html', questions=q, title=sections[section] + ': ' + categories[category])
def get_data(): engine = db_connect() create_deals_table(engine) Session = sessionmaker(bind=engine) sess = Session() if request.method == 'GET': section = int(request.args.get('section')) category = int(request.args.get('category')) q = sess.query(Question).filter( Question.section == sections[section], Question.type_of_quiz == categories[category] ).order_by(Question.question_number).all() return render_template( 'quiz.html', questions=q, title=sections[section]+': '+categories[category])
def show_main(): engine = db_connect() create_deals_table(engine) Session = sessionmaker(bind=engine) sess = Session() if request.method == 'POST': section = int(request.form['section']) category = int(request.form['category']) q = sess.query(Question).filter( Question.section == sections[section], Question.type_of_quiz == categories[category]).order_by( func.random()).all()[:20] return render_template('quiz_form.html', questions=q, title=sections[section] + ': ' + categories[category]) else: return render_template('start_form.html')
def show_main(): engine = db_connect() create_deals_table(engine) Session = sessionmaker(bind=engine) sess = Session() if request.method == 'POST': section = int(request.form['section']) category = int(request.form['category']) q = sess.query(Question).filter( Question.section == sections[section], Question.type_of_quiz == categories[category] ).order_by(func.random()).all()[:20] return render_template( 'quiz_form.html', questions=q, title=sections[section]+': '+categories[category]) else: return render_template('start_form.html')