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
WO = "M500130841"

with pymysql.connect(**CONN) as c:
    with c.cursor() as cur:
        cur.execute(
            "SELECT RecID,Nbr,Type,TransType,WorkOrd FROM NbrMaster WHERE tenant_id=%s AND WorkOrd=%s",
            (TENANT, WO),
        )
        print("NbrMaster", cur.fetchall())
        cur.execute(
            "SELECT COUNT(*) AS c FROM WorkOrdDetail WHERE tenant_id=%s AND WorkOrd=%s",
            (TENANT, WO),
        )
        print("WorkOrdDetail", cur.fetchone())
        cur.execute("SHOW TABLES LIKE 'QadTracking'")
        print("QadTracking table", cur.fetchall())
        cur.execute(
            """
            SELECT COUNT(*) AS c FROM b_bom_child_examine bce
            INNER JOIN b_examine_result ber ON ber.Id = bce.examine_id
            WHERE ber.tenant_id=%s AND IFNULL(bce.lack_qty,0)>0 AND IFNULL(bce.erp_cls,3)=3
            """,
            (TENANT,),
        )
        cur.execute(
            """
            SELECT bce.item_number, bce.use_qty, bce.needCount, bce.num, bce.backflush, bce.erp_cls
            FROM b_examine_result ber
            INNER JOIN b_bom_child_examine bce ON ber.Id = bce.examine_id AND bce.is_use = 1
            WHERE ber.tenant_id=%s AND ber.morder_no=%s AND ber.IsDeleted=0
              AND ber.Id = (
                  SELECT br.Id FROM b_examine_result br
                  WHERE br.tenant_id=%s AND br.morder_no=%s AND br.IsDeleted=0
                  ORDER BY br.create_time DESC LIMIT 1
              )
            """,
            (TENANT, WO, TENANT, WO),
        )
        print("resource components", cur.fetchall())