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)