| 123456789101112131415161718 |
- import pymysql
- from pathlib import Path
- sql = Path(r"d:/Projects/Ai-DOP/SourceCode/ai-dop-platform/docs/db/V1__aidopcore_s1s3_kpi_init_data.sql").read_text(encoding='utf-8')
- conn = pymysql.connect(host='123.60.180.165', port=3306, user='aidopremote', password='1234567890aiDOP#', database='aidopdev', charset='utf8mb4', autocommit=True)
- try:
- with conn.cursor() as cur:
- for st in [s.strip() for s in sql.split(';') if s.strip()]:
- cur.execute(st)
- cur.execute("select count(*) from ado_s9_kpi_value_l1_day where tenant_id=1 and factory_id=1")
- c1 = cur.fetchone()[0]
- cur.execute("select count(*) from ado_s9_kpi_value_l2_day where tenant_id=1 and factory_id=1")
- c2 = cur.fetchone()[0]
- cur.execute("select count(*) from ado_s9_kpi_value_l3_day where tenant_id=1 and factory_id=1")
- c3 = cur.fetchone()[0]
- print(f"L1={c1}, L2={c2}, L3={c3}")
- finally:
- conn.close()
|
