ylrz_saas_his_scrm/scripts/fix_dict.py

import pymysql
conn = pymysql.connect(host='cq-cdb-8fjmemkb.sql.tencentcdb.com', port=27220, user='root', password='Ylrz_1q2w3e4r5t6y', database='ylrz_saas', charset='utf8mb4')
cur = conn.cursor()

cur.execute("DELETE FROM sys_dict_data WHERE dict_type='sys_job_group'")
print('deleted', cur.rowcount)

cur.execute("INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time) VALUES (0,%s,%s,'sys_job_group','','','N','0','admin',NOW())", ('Ĭ�Ϸ���','DEFAULT'))
cur.execute("INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time) VALUES (1,%s,%s,'sys_job_group','','','N','0','admin',NOW())", ('��΢����','QW_TASK'))
conn.commit()

for r in cur.execute('SELECT dict_value, dict_label, hex(dict_label) FROM sys_dict_data WHERE dict_type=%s', ('sys_job_group',)):
    for r2 in cur.fetchall():
        print(r2)
cur.close()
conn.close()