def save_result(result):
"""保存答题结果"""
sqlite.execute_sql(
'insert into ai_result (\
id, ai_type, result_index, result_text, result_type, result_prop, question_id) \
values (null, ?, ?, ?, ?, ?, ?)',
(result.ai_type, result.index, result.text, result.type, result.prop,
result.question_id))
def save_question(question):
"""保存答题结果"""
sqlite.execute_sql(
'insert into question (\
id, question_text, individual, round, phase) \
values (null, ?, ?, ?, ?)',
(question.text, question.individual, question.round, question.phase))
question_id = get_question_id(question.round, question.phase)
return question_id
def get_question_id(question_round, question_phase):
"""获取题目ID"""
question_ids = sqlite.execute_sql(
'select id from question where round=? and phase=?',
(question_round, question_phase))
if not question_ids:
return None
return question_ids[0][0]
def get_all_correct_result():
"""获取所有正确结果"""
correct_results = sqlite.execute_sql('select * from correct_result')
return correct_results
def save_correct_result(result):
"""保存正确的答案"""
sqlite.execute_sql(
'insert into correct_result (\
id, correct_text, question_id) \
values (null, ?, ?)', (result.text, result.question_id))
def get_all_result():
"""获取所有正确结果"""
ai_results = sqlite.execute_sql('select * from ai_result')
return ai_results