AiDOPWarehouse/doc/_check_pr_occupy.py

import pymysql

CONN = dict(
    host="123.60.180.165",
    port=3306,
    user="aidopremote",
    password="1234567890aiDOP#",
    database="aidopdev",
    charset="utf8mb4",
    cursorclass=pymysql.cursors.DictCursor,
)
TENANT = 797403760988229

with pymysql.connect(**CONN) as c:
    with c.cursor() as cur:
        cur.execute(
            """
            SELECT COUNT(*) AS c FROM srm_pr_main
            WHERE tenant_id=%s AND IFNULL(state,0)=1
              AND IFNULL(analogcalcversion,'')=''
            """,
            (TENANT,),
        )
        print("pending_pr", cur.fetchone())
        cur.execute(
            """
            SELECT occ.Id, occ.polist_id, occ.type, pr.Id AS pr_id, pr.pr_billno
            FROM srm_po_occupy occ
            LEFT JOIN srm_pr_main pr ON pr.Id = occ.polist_id
            WHERE occ.tenant_id=%s
            LIMIT 5
            """,
            (TENANT,),
        )
        print("occupy sample", cur.fetchall())