data = dict()
loop = True
while loop:
data['qtype'] = safe_prompt(session, "Type ('BC', 'SC', 'MC', 'OC'): ")
if not data['qtype']:
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)
except lite.Error, e:
print "Error %s" % e.args[0]
except Exception, e:
print "Error %s" % e
subject = select_subject(session)
selected_topic = select_topic(session, subject)
print "Importing question in to this topic...", selected_topic
con.row_factory = lite.Row
cur = con.cursor()
cur.execute("Select id, question, qtype from questions")
rows = cur.fetchall()
for row in rows:
qa = Question(row['qtype'], row['question'])
qa.topic = selected_topic
session.add(qa)
session.commit()
con.row_factory = lite.Row
cur2 = con.cursor()
cur2.execute("Select answer_text, correct from answers where question_id=%d" % row['id'])
for answer in cur2.fetchall():
answ = Answer(answer['answer_text'], answer['correct'])
answ.question = qa
session.add(answ)
session.add(qa)
session.commit()
