def insert_question_results(results): is_correct = results.answer time = results.time question_id = results.question_id student_id = int(results.student_id) test_name = results.test_name query = StudenInfoDAO.insert_question_results(student_id, question_id, is_correct, time, test_name) val = (student_id, question_id, is_correct, time, test_name) return sqlliteDButils.execute_run(query, val)
def insert_visualization_properties(properties): queryVisualizationID = VisualiztionDAO.get_visualiztion_by_type( "\"" + get_visualization_type(properties.visualizationType) + "\"") VisualizationID = sqlliteDButils.execute_select(queryVisualizationID) id = VisualizationID[0]["id"] queryVisualizationProperties = VisualiztionPropertiesDAO.insert( properties.testName, properties.textID, id, properties.propName, properties.propVal, properties.propType, properties.threshold, properties.setNum) val = [ properties.testName, properties.textID, id, properties.propName, properties.propVal, properties.propType, properties.threshold, properties.setNum ] return sqlliteDButils.execute_run(queryVisualizationProperties, val)
def insert_answer(option_id, question_id, text_id, is_correct, answer_content): query = AnswersDAO.insert_answer(option_id, question_id, text_id, is_correct, answer_content) val = (option_id, question_id, text_id, is_correct, answer_content) return sqlliteDButils.execute_run(query, val)
def insert_test(name, text_id, visualiztion_id): query = TestDAO.insert(name, text_id, visualiztion_id) val = (name, text_id, visualiztion_id) return sqlliteDButils.execute_run(query, val)
def delete_test_by_name(testName): query = VisualiztionPropertiesDAO.delete_test_by_name(testName) val = (testName, ) return sqlliteDButils.execute_run(query, val)
def insert_question(text_id, question_content): query = questionsDAO.insert_question(text_id, question_content) val = (text_id, question_content) return sqlliteDButils.execute_run(query, val)
def delete_test_by_name(name): query = TestDAO.delete_by_name(name) val = (name,) return sqlliteDButils.execute_run(query,val)
def delete_test(name): query = test_typeDAO.delete(name) print(query) val = (name, ) return sqlliteDButils.execute_run(query, val)
def insert_new_test(test_name, type): query = test_typeDAO.insert(test_name, type) print(query) val = (test_name, type) return sqlliteDButils.execute_run(query, val)
def update_rank(student_id, WithoutVisualization_place,gradualHighlight_place,highlight_place,increasedFont_place,gradualFont_place,summaryOnly_place): query = RankDAO.update_rank(student_id, WithoutVisualization_place,gradualHighlight_place,highlight_place,increasedFont_place, gradualFont_place,summaryOnly_place) val = (WithoutVisualization_place,gradualHighlight_place,highlight_place,increasedFont_place,gradualFont_place,summaryOnly_place, student_id) return sqlliteDButils.execute_run(query, val)
def insert_rank(student_id, withoutVisualization, gradualHighlight, highlight, increasedFont, gradualFont, summaryOnly, textId): query = RankDAO.insert_rank(student_id, withoutVisualization, gradualHighlight, highlight, increasedFont,gradualFont, summaryOnly, textId) val = (student_id, withoutVisualization, gradualHighlight, highlight, increasedFont, gradualFont, summaryOnly, textId) return sqlliteDButils.execute_run(query, val)
def insert_text(name, content): query = TextDAO.insert_text(name, content) val = (name, content) return sqlliteDButils.execute_run(query, val)
def delete_text(id): query = TextDAO.delete_text(id) val = (id, ) return sqlliteDButils.execute_run(query, val)
def update_text(id, name, content): query = TextDAO.update_text(id, name, content) return sqlliteDButils.execute_run(query)
def saveStudentSummary(studentId, text_id, summary, reading_time, summary_time): query = StudenInfoDAO.saveStudentSummary(studentId, text_id, summary, reading_time, summary_time) val = (studentId, text_id, summary, reading_time, summary_time) return sqlliteDButils.execute_run(query, val)
def update_test(name, text_id, visualiztion_id): query = TestDAO.update_test(name, text_id, visualiztion_id) val = (name,) return sqlliteDButils.execute_run(query, val)
def insert_info(student_id, age, gender, studentName, studentDivision): query = StudenInfoDAO.insert_info() val = (student_id, age, gender, studentName, studentDivision) return sqlliteDButils.execute_run(query, val)
def delete_question(id): query = questionsDAO.delete_question(id) val = (id, ) return sqlliteDButils.execute_run(query, val)