def get_test_by_id(id):
query = TestDAO.get_test_by_id(id)
response = sqlliteDButils.execute_select(query)
test = {}
if (response):
test['name'] = response['name']
test['text'] = {'id': response['text_id'],
'name': response['text_name'],
'content': response['content']
}
visualization_properties = {}
visualization_properties['id'] = response['v_id']
visualization_properties['type'] = response['type']
for row in response:
visualization_properties[row['property_name']] = converter.convert(row['property_value'],row['property_name'])
test['visualization'] = visualization_properties
return test
def get_test_properties(testName):
query = VisualiztionPropertiesDAO.get_test_properties(testName)
return sqlliteDButils.execute_select(query)
def get_texts():
query = TestDAO.get_all_tests()
return sqlliteDButils.execute_select(query)
def get_test_by_name(name):
query = test_typeDAO.get_test_by_name(name)
return sqlliteDButils.execute_select(query)
def get_student_details(testName):
query = StudentAnswersDAO.get_student_details(testName)
return sqlliteDButils.execute_select(query)
def get_answer_by_test_name_SUM(testName, visualization, set_num):
query = StudentAnswersDAO.get_answer_by_test_name_SUM(
testName, visualization, set_num)
return sqlliteDButils.execute_select(query)
def correct_answers_count(testName):
query = StudentAnswersDAO.correct_answers_count(testName)
return sqlliteDButils.execute_select(query)
def get_placing_by_test_name(testName):
query = StudentAnswersDAO.get_placing_by_test_name(testName)
return sqlliteDButils.execute_select(query)
def get_text_name(id):
query = TextDAO.get_text_name(id)
return sqlliteDButils.execute_select(query)
def get_max_question_id():
query = questionsDAO.get_max_question_id()
return sqlliteDButils.execute_select(query)
def get_questions_by_id(id):
query = questionsDAO.get_questions_by_id(id)
return sqlliteDButils.execute_select(query)
