# -*- coding: utf-8 -*-
import pymysql

c = pymysql.connect(
    host='cq-cdb-8fjmemkb.sql.tencentcdb.com',
    port=27220,
    user='root',
    password='Ylrz_1q2w3e4r5t6y',
    database='ylrz_saas_tenant_1',
    charset='utf8mb4',
)
cur = c.cursor()
cur.execute("SELECT job_id, job_name, invoke_target, status, remark FROM sys_job WHERE remark LIKE '%TENANT_SYNC%'")
rows = cur.fetchall()
if rows:
    for r in rows:
        print(f'job_id={r[0]}, name={r[1]}, target={r[2]}, status={r[3]}, remark={r[4]}')
else:
    print('NO tenant sync records found in tenant DB')
c.close()