def add_answer(): content = request.form.get('answer_content') question_id = request.form.get('question_id') question = Question.query.filter(Question.id == question_id).first() answer = Answer(content=content) answer.author = g.user answer.question = question db.session.add(answer) return redirect(url_for('detail', question_id=question_id))
def add_answer(): content = request.form.get('answer_content') question_id = request.form.get('question_id') create_time = Answer.query.order_by('-create_time').first() answer = Answer(content=content) answer.author = g.user question = Question.query.filter(Question.id == question_id).first() answer.question = question db.session.add(answer) db.session.commit() return redirect(url_for('detail', question_id=question_id))
loop = False if safe_prompt(session, "Continue? ") in ("N",'n','No','no') else True continue data['question'] = safe_prompt(session, "Question: ") if not data['question']: loop = False if safe_prompt(session, "Continue? ") in ("N",'n','No','no') else True continue qa = Question(**data) qa.topic = current_topic session.add(qa) session.commit() if data['qtype'] in ('BC','bc','b'): true = Answer('Vero') true.question = qa false = Answer('Falso') false.question = qa session.add(true) session.add(false) else: subloop = True answer_id = 1 while subloop: answer = safe_prompt(session, 'Answer %s: ' % answer_id) if not answer: break answ = Answer(answer) answ.question = qa session.add(answ) answer_id += 1 session.add(qa)
print "Importing question in each topic..." # current_topic = select_topic(session, current_subject) # if not current_topic: # sys.exit(1) cur.execute("Select question, qtype, answers, topic_id from questions") rows = cur.fetchall() for row in rows: qa = Question(row['qtype'], row['question']) qa.topic_id = int(row['topic_id']) for answer in row['answers'].split('\n'): if answer: answ = Answer(answer[6:]) answ.question = qa session.add(answ) session.add(qa) session.commit() print "Importing classes..." cur.execute("Select name from classes") rows = cur.fetchall() for row in rows: ac = AlumnClass(name=row['name']) print "Select subject for class", ac ac.subject = select_subject(session) session.add(ac) session.commit()