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

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

cur.execute("SELECT COUNT(*) FROM sys_job WHERE remark LIKE 'TENANT_SYNC:%'")
cnt = cur.fetchone()
print(f'\nTotal TENANT_SYNC records: {cnt[0]}')

conn.close()