import pymysql
import sys

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'")
conn.commit()

labels = [
    (0, u'\u9ed8\u8ba4\u5206\u7ec4', 'DEFAULT'),    # default group
    (1, u'\u4f01\u5fae\u4efb\u52a1', 'QW_TASK'),     # QW task
]

for sort, label, val in labels:
    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 (%s,%s,%s,%s,%s,%s,%s,%s,%s,NOW())',
        (sort, label, val, 'sys_job_group', '', '', 'N', '0', 'admin'))

conn.commit()

cur.execute("SELECT dict_code, dict_value, hex(dict_label), CHAR_LENGTH(dict_label) FROM sys_dict_data WHERE dict_type='sys_job_group'")
for r in cur.fetchall():
    code, val, hex_label, charlen = r
    ok = 'OK' if hex_label == ('E9BB98E8AEA4E58886E7BB84' if val == 'DEFAULT' else 'E4BC81E5BEAEE4BBBBE58AA1') else 'FAIL'
    sys.stdout.write('%s: code=%s val=%s hex=%s len=%s\n' % (ok, code, val, hex_label, charlen))

cur.close()
conn.close()