ylrz_saas_his_scrm/scripts/fix_dict2.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=%s", ("sys_job_group",))
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,%s,'','','N','0','admin',NOW())", ("默认分组","DEFAULT","sys_job_group"))
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,%s,'','','N','0','admin',NOW())", ("企微任务","QW_TASK","sys_job_group"))
conn.commit()
cur.execute("SELECT dict_value,dict_label,hex(dict_label) FROM sys_dict_data WHERE dict_type=%s", ("sys_job_group",))
for r in cur.fetchall():
    print(r)
cur.close()
conn.close()