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