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()
