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)
