def get_type_id(self, exam_type=None, subject=None):
u'''
根据给定的汉字，获取对应的考试类型或科目类型id
:param exam_type:
:param subject:
:return:
'''
mysql = MySQL()
sql = {}
if exam_type:
fields = "id"
query = "SELECT " + fields + " FROM `exam_type` WHERE primary_categories='" + exam_type + "'"
print(query)
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
sql["exam_type_id"] = sql['id']
if subject:
fields = "id"
query = "SELECT " + fields + " FROM `subject` WHERE subject_name='" + subject + "'"
print(query)
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
sql["subject_id"] = sql['id']
sql.pop("id")
print(sql)
return sql
def update_user_clock_in_To_details(self, user_id, **kwargs):
mysql = MySQL()
sql = {}
string = ""
if 'exam_type_id' in list(kwargs.keys()):
string = string + " AND exam_type_id=" + str(kwargs['exam_type_id'])
if "subject_id" in list(kwargs.keys()):
string = string + " AND subject_id=" + str(kwargs['subject_id'])
fields = "id,clock_in_details"
query = "SELECT " + fields + " FROM `user_clock_in` WHERE DATE_FORMAT(create_date,'%Y%m') = DATE_FORMAT(NOW(),'%Y%m') AND user_id=" + str(
user_id) + string
print(query)
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
for i in range(len(sql['id'])):
id = sql['id'][i]
clock_in_details = sql['clock_in_details'][i]
index = re.search(str(datetime.datetime.now().day) + ":", clock_in_details).end()
clock_in_details = clock_in_details[:index] + "2" + clock_in_details[index + 1:]
query = "UPDATE `user_clock_in` SET clock_in_details='" + clock_in_details + "' WHERE id=" + str(
id) + " AND user_id=" + str(user_id)
print(query)
mysql.editData(query)
print("MySQL update success！")
def update_learning_plan_daily_To_compliance(self, user_id, **kwargs):
mysql = MySQL()
sql = {}
string = ""
if 'exam_type_id' in list(kwargs.keys()):
string = string + " AND exam_type_id=" + str(kwargs['exam_type_id'])
if "subject_id" in list(kwargs.keys()):
string = string + " AND subject_id=" + str(kwargs['subject_id'])
fields = "id,compliance"
query = "SELECT " + fields + " FROM `learning_plan_daily` WHERE DATE_FORMAT(create_date,'%Y%m%d') = DATE_FORMAT(NOW(),'%Y%m%d') AND user_id=" + str(
user_id) + string
print(query)
count = mysql.getRowCount(query)
print('count = ', count)
if count > 0:
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
for i in range(len(sql['id'])):
if ord(sql['compliance'][i]) > 0:
query = "UPDATE `learning_plan_daily` SET compliance=0,answer_sum=0,correct_answer_sum=0 WHERE id=" + str(
sql['id'][i])
print(query)
mysql.editData(query)
print("MySQL update success！")
def table_subject(self, **kwargs):
mysql = MySQL()
sql = {}
keys = list(kwargs.keys())
if "subject_id" in keys:
fields = "subject_name"
query = "SELECT " + fields + " FROM `subject` WHERE id=" + str(kwargs['subject_id'])
print(query)
result = mysql.getFistRow(query)
self._getSqlDict(sql, fields, result)
if "exam_type_id" in keys:
fields = "id"
query = "SELECT " + fields + " FROM `subject` WHERE exam_type_id=" + str(kwargs['exam_type_id'])
print(query)
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
if "subject_name" in keys:
fields = "id"
if 'exam_type_id' in keys:
query = "SELECT " + fields + " FROM `subject` WHERE subject_name='" + str(
kwargs['subject_name']) + "' and exam_type_id=" + str(kwargs['exam_type_id'])
else:
query = "SELECT " + fields + " FROM `subject` WHERE subject_name='" + str(kwargs['subject_name']) + "'"
print(query)
result = mysql.getFistRow(query)
self._getSqlDict(sql, fields, result)
print(sql)
return sql
def table_chapter(self, **kwargs):
mysql = MySQL()
sql = {}
fields = "id,question_sum,done_sum"
if "id" in kwargs.keys():
query = "SELECT " + fields + " FROM `chapter` WHERE id=" + str(kwargs['id'])
print(query)
result = mysql.getFistRow(query)
self._getSqlDict(sql, fields, result)
if "subject_id" in kwargs.keys():
query = "SELECT " + fields + " FROM `chapter` WHERE del_flag=0 AND subject_id=" + str(
kwargs['subject_id']) + " GROUP BY chapter_number ASC"
print(query)
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
print(sql)
return sql
def table_exam_question(self, **kwargs):
mysql = MySQL()
sql = {}
keys = kwargs.keys()
fields = "id,question_type,question_desc,correct_answer,options_desc,correct_answer_desc"
if "id" in keys:
query = "SELECT " + fields + " FROM `exam_question` WHERE id=" + str(kwargs['id'])
print(query)
result = mysql.getFistRow(query)
self._getSqlDict(sql, fields, result)
sql['options_desc'] = json.loads(sql['options_desc'])
if "chapter_id" in keys:
query = "SELECT " + fields + " FROM `exam_question` WHERE del_flag=0 AND chapter_id=" + str(
kwargs['chapter_id']) + " GROUP BY question_number ASC"
print(query)
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
sql['options_desc'] = json.loads(sql['options_desc'])
print(sql)
return sql
