ylrz_saas_his_scrm/scripts/verify_sync_status.py

# -*- 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()
cur.execute("SELECT id, tenant_id, template_id, status, sync_status, sync_time, sync_message FROM tenant_job_config WHERE tenant_id=32")
rows = cur.fetchall()
print('=== master DB tenant_job_config sync status ===')
for r in rows:
    print(r)
conn.close()