# -*- 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',
    charset='utf8mb4',
)
cur = conn.cursor()

print('=== tenant_job_config for tenant 32 ===')
cur.execute("SELECT id, template_id, status, sync_status, sync_message FROM tenant_job_config WHERE tenant_id=32")
for r in cur.fetchall():
    print(r)

print('\n=== sys_job in tenant DB (ylrz_saas_tenant_1) ===')
cur.execute("USE ylrz_saas_tenant_1")
cur.execute("SELECT job_id, job_name, invoke_target, status, remark FROM sys_job WHERE remark LIKE 'TENANT_SYNC:%'")
for r in cur.fetchall():
    print(r)

conn.close()