def gen_q_from_var(qt_id, student, exam, position, version, variation): """ Generate a question given a specific variation. """ qvars = None q_id = DB.create_q(qt_id, DB.get_qt_name(qt_id), student, 1, variation, version, exam) try: q_id = int(q_id) assert (q_id > 0) except (ValueError, TypeError, AssertionError): L.error("OaDB.createQuestion(%s,...) FAILED" % qt_id) imageexists = DB.get_q_att_mimetype(qt_id, "image.gif", variation, version) if not imageexists: if not qvars: qvars = DB.get_qt_variation(qt_id, variation, version) qvars['Oasis_qid'] = q_id image = DB.get_qt_att(qt_id, "image.gif", version) if image: newimage = gen_q_image(qvars, image) DB.create_q_att(qt_id, variation, "image.gif", "image/gif", newimage, version) htmlexists = DB.get_q_att_mimetype(qt_id, "qtemplate.html", variation, version) if not htmlexists: if not qvars: qvars = DB.get_qt_variation(qt_id, variation, version) html = DB.get_qt_att(qt_id, "qtemplate.html", version) if html: qvars['Oasis_qid'] = q_id newhtml = gen_q_html(qvars, html) L.info("generating new qattach qtemplate.html for %s" % q_id) DB.create_q_att(qt_id, variation, "qtemplate.html", "application/oasis-html", newhtml, version) try: q_id = int(q_id) assert (q_id > 0) except (ValueError, TypeError, AssertionError): L.error("generateQuestionFromVar(%s,%s), can't find qid %s? " % (qt_id, student, q_id)) if exam >= 1: DB.add_exam_q(student, exam, q_id, position) return q_id
def practice_mark_question(topic_id, question_id): """ Mark the submitted question answersjust wa """ user_id = session['user_id'] course_id = Topics.get_course_id(topic_id) if not course_id: abort(404) course = Courses2.get_course(course_id) if not course: abort(404) topictitle = "UNKNOWN" try: topictitle = Topics.get_name(topic_id) except KeyError: abort(404) qt_id = DB.get_q_parent(question_id) q_title = DB.get_qt_name(qt_id) questions = Practice.get_sorted_questions(course_id, topic_id, user_id) q_pos = DB.get_qtemplate_topic_pos(qt_id, topic_id) blocked = Practice.is_q_blocked(user_id, course_id, topic_id, qt_id) if blocked: return render_template( "practicequestionblocked.html", mesg=blocked, topictitle=topictitle, topic_id=topic_id, qt_id=qt_id, course=course, q_title=q_title, questions=questions, q_pos=q_pos, ) marking = Practice.mark_q(user_id, topic_id, question_id, request) prev_id, next_id = Practice.get_next_prev(qt_id, topic_id) return render_template( "practicemarkquestion.html", topictitle=topictitle, topic_id=topic_id, qt_id=qt_id, course=course, q_title=q_title, questions=questions, q_pos=q_pos, q_id=question_id, marking=marking, next_id=next_id, prev_id=prev_id )
def practice_mark_question(topic_id, question_id): """ Mark the submitted question answersjust wa """ user_id = session['user_id'] course_id = Topics.get_course_id(topic_id) if not course_id: abort(404) course = Courses2.get_course(course_id) if not course: abort(404) topictitle = "UNKNOWN" try: topictitle = Topics.get_name(topic_id) except KeyError: abort(404) qt_id = DB.get_q_parent(question_id) q_title = DB.get_qt_name(qt_id) questions = Practice.get_sorted_questions(course_id, topic_id, user_id) q_pos = DB.get_qtemplate_topic_pos(qt_id, topic_id) blocked = Practice.is_q_blocked(user_id, course_id, topic_id, qt_id) if blocked: return render_template( "practicequestionblocked.html", mesg=blocked, topictitle=topictitle, topic_id=topic_id, qt_id=qt_id, course=course, q_title=q_title, questions=questions, q_pos=q_pos, ) marking = Practice.mark_q(user_id, topic_id, question_id, request) prev_id, next_id = Practice.get_next_prev(qt_id, topic_id) # TODO: need next_pos and prev_pos return render_template( "practicemarkquestion.html", topictitle=topictitle, topic_id=topic_id, qt_id=qt_id, course=course, q_title=q_title, questions=questions, q_pos=q_pos, q_id=question_id, marking=marking, next_id=next_id, prev_id=prev_id )
def qtlog_as_html(topic, qtid): """Show the most recent log errors for the given qtid. """ versionre = re.compile(r'version=(\d+),') variationre = re.compile(r'variation=(\d+),') priorityre = re.compile(r'priority=([^,]+),') facilityre = re.compile(r'facility=([^,]+),') messagere = re.compile(r'message=(.+)$', re.MULTILINE) out = "" name = DB.get_qt_name(qtid) out += "<h2>Log Entries for %s, topic %s</h2>" % (name, topic) out += "<p><i>These can be created from within __marker.py or __results.py by calling " out += "log(priority, mesg), for example:</i> " out += "<pre>log('error','User entered a value we can't parse.')</pre></p>" out += "<p><i>Typical priorities might be 'error', 'info', 'noise'</i></p>" out += "<table style='border: solid 1px black;' border='1'><tr><th>Time</th><th>Ver</th>" out += "<th>Variation</th><th>Pri</th><th>Fac</th><th>Message</th></tr>" entries = Audit.get_records_by_object(qtid, limit=100, offset=0) for entry in entries: try: version = versionre.findall(entry['message'])[0] except (IndexError, TypeError): version = '.' try: variation = variationre.findall(entry['message'])[0] except (IndexError, TypeError): variation = '.' try: priority = priorityre.findall(entry['message'])[0] except (IndexError, TypeError): priority = '.' try: facility = facilityre.findall(entry['message'])[0] except (IndexError, TypeError): facility = '.' try: message = messagere.findall(entry['message'])[0] except (IndexError, TypeError): message = '.' out += "<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>" % ( entry['time'].strftime("%Y/%b/%d %H:%M:%S"), version, variation, priority, facility, message) out += "</table>" return out
def qtlog_as_html(topic, qtid): """Show the most recent log errors for the given qtid. """ versionre = re.compile(r'version=(\d+),') variationre = re.compile(r'variation=(\d+),') priorityre = re.compile(r'priority=([^,]+),') facilityre = re.compile(r'facility=([^,]+),') messagere = re.compile(r'message=(.+)$', re.MULTILINE) out = "" name = DB.get_qt_name(qtid) out += "<h2>Log Entries for %s, topic %s</h2>" % (name, topic) out += "<p><i>These can be created from within __marker.py or __results.py by calling " out += "log(priority, mesg), for example:</i> " out += "<pre>log('error','User entered a value we can't parse.')</pre></p>" out += "<p><i>Typical priorities might be 'error', 'info', 'noise'</i></p>" out += "<table style='border: solid 1px black;' border='1'><tr><th>Time</th><th>Ver</th>" out += "<th>Variation</th><th>Pri</th><th>Fac</th><th>Message</th></tr>" entries = Audit.get_records_by_object(qtid, limit=100, offset=0) for entry in entries: try: version = versionre.findall(entry['message'])[0] except (IndexError, TypeError): version = '.' try: variation = variationre.findall(entry['message'])[0] except (IndexError, TypeError): variation = '.' try: priority = priorityre.findall(entry['message'])[0] except (IndexError, TypeError): priority = '.' try: facility = facilityre.findall(entry['message'])[0] except (IndexError, TypeError): facility = '.' try: message = messagere.findall(entry['message'])[0] except (IndexError, TypeError): message = '.' out += "<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>" % (entry['time'].strftime("%Y/%b/%d %H:%M:%S"), version, variation, priority, facility, message) out += "</table>" return out
def do_topic_page_commands(request, topic_id, user_id): """We've been asked to perform some operations on the Topic page. Expecting form fields: selected_QTID position_QTID name_QTID where QTID is a question template id. May receive many. new_position new_name new_type select_cmd = 'copy' | 'move' select_target = TOPICID of target topic """ form = request.form mesg = [] # Make a list of all the commands to run cmdlist = [] for command in request.form.keys(): (cmd, data) = command.split('_', 2) value = form[command] if not value == "none": cmdlist += [{'cmd': cmd, 'data': data, 'value': value}] # Now run them: # Titles first for command in [cmd for cmd in cmdlist if cmd['cmd'] == 'name']: qid = int(command['data']) title = command['value'] DB.update_qt_title(qid, title) # Then positions for command in [cmd for cmd in cmdlist if cmd['cmd'] == 'position']: qtid = int(command['data']) try: position = int(command['value']) except ValueError: position = 0 DB.update_qt_pos(qtid, topic_id, position) # Then commands on selected questions target_cmd = form.get('target_cmd', None) if target_cmd: qtids = [int(cmd['data']) for cmd in cmdlist if cmd['cmd'] == 'select'] try: target_topic = int(form.get('target_topic', 0)) except ValueError: target_topic = None if target_cmd == 'move': if target_topic: for qtid in qtids: qt_title = DB.get_qt_name(qtid) topic_title = Topics.get_name(target_topic) flash("Moving %s to %s" % (qt_title, topic_title)) DB.move_qt_to_topic(qtid, target_topic) Topics.flush_num_qs(topic_id) Topics.flush_num_qs(target_topic) if target_cmd == 'copy': if target_topic: for qtid in qtids: qt_title = DB.get_qt_name(qtid) topic_title = Topics.get_name(target_topic) flash("Copying %s to %s" % (qt_title, topic_title)) newid = DB.copy_qt_all(qtid) DB.add_qt_to_topic(newid, target_topic) Topics.flush_num_qs(target_topic) if target_cmd == 'hide': for qtid in qtids: position = DB.get_qtemplate_topic_pos(qtid, topic_id) if position > 0: # If visible, make it hidden DB.update_qt_pos(qtid, topic_id, -position) title = DB.get_qt_name(qtid) flash("Made '%s' Hidden" % title) Topics.flush_num_qs(topic_id) if target_cmd == 'show': for qtid in qtids: position = DB.get_qtemplate_topic_pos(qtid, topic_id) if position == 0: # If hidden, make it visible newpos = DB.get_qt_max_pos_in_topic(topic_id) DB.update_qt_pos(qtid, topic_id, newpos + 1) Topics.flush_num_qs(topic_id) title = DB.get_qt_name(qtid) flash("Made '%s' Visible" % title) if position < 0: # If hidden, make it visible DB.update_qt_pos(qtid, topic_id, -position) Topics.flush_num_qs(topic_id) title = DB.get_qt_name(qtid) flash("Made '%s' Visible" % title) if target_cmd == "export": if len(qtids) < 1: flash("No questions selected to export") else: data = External.qts_to_zip(qtids, fname="oa_export", suffix="oaq") if not data: abort(401) sio = StringIO.StringIO(data) return 2, send_file(sio, "application/oasisqe", as_attachment=True, attachment_filename="oa_export.zip") # Then new questions new_title = form.get('new_title', None) if new_title: if not (new_title == "[New Question]" or new_title == ""): new_position = form.get('new_position', 0) try: new_position = int(new_position) except ValueError: new_position = 0 new_qtype = form.get('new_qtype', 'raw') try: new_maxscore = float(form.get('new_maxscore', 0)) except ValueError: new_maxscore = 0 newid = DB.create_qt(user_id, new_title, "No Description", 1, new_maxscore, 0) if newid: mesg.append("Created new question, id %s" % newid) DB.update_qt_pos(newid, topic_id, new_position) DB.create_qt_att(newid, "qtemplate.html", "application/oasis-html", "empty", 1) DB.create_qt_att(newid, "qtemplate.html", "application/oasis-html", "empty", 1) if new_qtype == "oqe": mesg.append("Creating new question, id %s as OQE" % newid) DB.create_qt_att(newid, "_editor.oqe", "application/oasis-oqe", "", 1) if new_qtype == "raw": mesg.append("Creating new question, id %s as RAW (%s)" % (newid, new_qtype)) DB.create_qt_att(newid, "datfile.txt", "application/oasis-dat", "0", 1) else: mesg.append("Error creating new question, id %s" % newid) L.error("Unable to create new question (%s) (%s)" % (new_title, new_position)) Topics.flush_num_qs(topic_id) return 1, {'mesg': mesg}
def do_topic_page_commands(request, topic_id, user_id): """We've been asked to perform some operations on the Topic page. Expecting form fields: selected_QTID position_QTID name_QTID where QTID is a question template id. May receive many. new_position new_name new_type select_cmd = 'copy' | 'move' select_target = TOPICID of target topic """ form = request.form files = request.files mesg = [] # Make a list of all the commands to run cmdlist = [] for command in request.form.keys(): if '_' in command: (cmd, data) = command.split('_', 2) value = form[command] if not value == "none": cmdlist += [{'cmd': cmd, 'data': data, 'value': value}] # Now run them: # Titles first for command in [cmd for cmd in cmdlist if cmd['cmd'] == 'name']: qid = int(command['data']) title = command['value'] DB.update_qt_title(qid, title) # Then positions for command in [cmd for cmd in cmdlist if cmd['cmd'] == 'position']: qtid = int(command['data']) try: position = int(command['value']) except ValueError: position = 0 DB.update_qt_practice_pos(qtid, position) # Then commands on selected questions target_cmd = form.get('target_cmd', None) if target_cmd: qtids = [int(cmd['data']) for cmd in cmdlist if cmd['cmd'] == 'select'] try: target_topic = int(form.get('target_topic', 0)) except ValueError: target_topic = None if target_cmd == 'move': if target_topic: for qtid in qtids: qt_title = DB.get_qt_name(qtid) topic_title = Topics.get_name(target_topic) flash("Moving %s to %s" % (qt_title, topic_title)) DB.move_qt_to_topic(qtid, target_topic) Topics.flush_num_qs(target_topic) if target_cmd == 'copy': if target_topic: for qtid in qtids: qt_title = DB.get_qt_name(qtid) topic_title = Topics.get_name(target_topic) flash("Copying %s to %s" % (qt_title, topic_title)) position = DB.get_qtemplate_practice_pos(qtid) newid = DB.copy_qt_all(qtid) DB.move_qt_to_topic(newid, target_topic, position) Topics.flush_num_qs(target_topic) if target_cmd == 'hide': for qtid in qtids: position = DB.get_qtemplate_practice_pos(qtid) if position > 0: # If visible, make it hidden DB.update_qt_practice_pos(qtid, -position) title = DB.get_qt_name(qtid) flash("Made '%s' Hidden" % title) if target_cmd == 'show': for qtid in qtids: position = DB.get_qtemplate_practice_pos(qtid) if position == 0: # If hidden, make it visible newpos = DB.get_qt_max_pos_in_topic(topic_id) DB.update_qt_practice_pos(qtid, newpos + 1) title = DB.get_qt_name(qtid) flash("Made '%s' Visible" % title) if position < 0: # If hidden, make it visible DB.update_qt_practice_pos(qtid, -position) title = DB.get_qt_name(qtid) flash("Made '%s' Visible" % title) if target_cmd == "export": if len(qtids) < 1: flash("No questions selected to export") else: data = External.qts_to_zip(qtids) if not data: abort(401) sio = StringIO.StringIO(data) return 2, send_file(sio, "application/oasisqe", as_attachment=True, attachment_filename="oa_export.zip") # Then new questions new_title = form.get('new_title', None) if new_title: if not (new_title == "[New Question]" or new_title == ""): new_position = form.get('new_position', 0) try: new_position = int(new_position) except ValueError: new_position = 0 new_qtype = form.get('new_qtype', 'raw') try: new_max_score = float(form.get('new_maxscore', 0)) except ValueError: new_max_score = 0 new_id = DB.create_qt(owner=user_id, title=new_title, desc="No Description", marker=1, score_max=new_max_score, status=0, topic_id=topic_id) if new_id: mesg.append("Created new question, id %s" % new_id) if new_position and new_position >= 1: DB.update_qt_practice_pos(new_id, new_position) if new_qtype == "qe2": mesg.append("Creating new question, id %s as QE2" % new_id) QEditor2.create_new(new_id, new_title) if new_qtype == "raw": mesg.append("Creating new question, id %s as RAW (%s)" % (new_id, new_qtype)) QEditor.create_new(new_id, new_title) else: mesg.append("Error creating new question, id %s" % new_id) L.error("Unable to create new question (%s) (%s)" % (new_title, new_position)) L.info("request.files = %s" % (repr(request.files.keys()))) # Did they upload a file to import? if 'import_file' in request.files: L.info("File upload to topic %s by user %s" % (topic_id, user_id)) data = files['import_file'].read() if len(data) > 1: for msg in _import_questions_from_file(data, topic_id): mesg.append(msg) Topics.flush_num_qs(topic_id) return 1, {'mesg': mesg}
def do_topic_page_commands(request, topic_id, user_id): """We've been asked to perform some operations on the Topic page. Expecting form fields: selected_QTID position_QTID name_QTID where QTID is a question template id. May receive many. new_position new_name new_type select_cmd = 'copy' | 'move' select_target = TOPICID of target topic """ form = request.form mesg = [] # Make a list of all the commands to run cmdlist = [] for command in request.form.keys(): (cmd, data) = command.split('_', 2) value = form[command] if not value == "none": cmdlist += [{'cmd': cmd, 'data': data, 'value': value}] # Now run them: # Titles first for command in [cmd for cmd in cmdlist if cmd['cmd'] == 'name']: qid = int(command['data']) title = command['value'] DB.update_qt_title(qid, title) # Then positions for command in [cmd for cmd in cmdlist if cmd['cmd'] == 'position']: qtid = int(command['data']) try: position = int(command['value']) except ValueError: position = 0 DB.update_qt_pos(qtid, topic_id, position) # Then commands on selected questions target_cmd = form.get('target_cmd', None) if target_cmd: qtids = [int(cmd['data']) for cmd in cmdlist if cmd['cmd'] == 'select'] try: target_topic = int(form.get('target_topic', 0)) except ValueError: target_topic = None if target_cmd == 'move': if target_topic: for qtid in qtids: qt_title = DB.get_qt_name(qtid) topic_title = Topics.get_name(target_topic) flash("Moving %s to %s" % (qt_title, topic_title)) DB.move_qt_to_topic(qtid, target_topic) Topics.flush_num_qs(topic_id) Topics.flush_num_qs(target_topic) if target_cmd == 'copy': if target_topic: for qtid in qtids: qt_title = DB.get_qt_name(qtid) topic_title = Topics.get_name(target_topic) flash("Copying %s to %s" % (qt_title, topic_title)) newid = DB.copy_qt_all(qtid) DB.add_qt_to_topic(newid, target_topic) Topics.flush_num_qs(target_topic) if target_cmd == 'hide': for qtid in qtids: position = DB.get_qtemplate_topic_pos(qtid, topic_id) if position > 0: # If visible, make it hidden DB.update_qt_pos(qtid, topic_id, -position) title = DB.get_qt_name(qtid) flash("Made '%s' Hidden" % title) Topics.flush_num_qs(topic_id) if target_cmd == 'show': for qtid in qtids: position = DB.get_qtemplate_topic_pos(qtid, topic_id) if position == 0: # If hidden, make it visible newpos = DB.get_qt_max_pos_in_topic(topic_id) DB.update_qt_pos(qtid, topic_id, newpos + 1) Topics.flush_num_qs(topic_id) title = DB.get_qt_name(qtid) flash("Made '%s' Visible" % title) if position < 0: # If hidden, make it visible DB.update_qt_pos(qtid, topic_id, -position) Topics.flush_num_qs(topic_id) title = DB.get_qt_name(qtid) flash("Made '%s' Visible" % title) if target_cmd == "export": if len(qtids) < 1: flash("No questions selected to export") else: data = External.qts_to_zip(qtids) if not data: abort(401) sio = StringIO.StringIO(data) return 2, send_file(sio, "application/oasisqe", as_attachment=True, attachment_filename="oa_export.zip") # Then new questions new_title = form.get('new_title', None) if new_title: if not (new_title == "[New Question]" or new_title == ""): new_position = form.get('new_position', 0) try: new_position = int(new_position) except ValueError: new_position = 0 new_qtype = form.get('new_qtype', 'raw') try: new_max_score = float(form.get('new_maxscore', 0)) except ValueError: new_max_score = 0 newid = DB.create_qt(user_id, new_title, "No Description", 1, new_max_score, 0) if newid: mesg.append("Created new question, id %s" % newid) DB.update_qt_pos(newid, topic_id, new_position) DB.create_qt_att(newid, "qtemplate.html", "application/oasis-html", "empty", 1) DB.create_qt_att(newid, "qtemplate.html", "application/oasis-html", "empty", 1) if new_qtype == "oqe": mesg.append("Creating new question, id %s as OQE" % newid) DB.create_qt_att(newid, "_editor.oqe", "application/oasis-oqe", "", 1) if new_qtype == "raw": mesg.append("Creating new question, id %s as RAW (%s)" % (newid, new_qtype)) DB.create_qt_att(newid, "datfile.txt", "application/oasis-dat", "0", 1) else: mesg.append("Error creating new question, id %s" % newid) L.error("Unable to create new question (%s) (%s)" % (new_title, new_position)) Topics.flush_num_qs(topic_id) return 1, {'mesg': mesg}