zrd-nb666/campus_health_app/analytics/_init_daily_metrics.py

import pymysql
conn = pymysql.connect(host='localhost', port=3306, user='analytics', password='123456', database='campus_health', charset='utf8mb4')
with open(r"D:\workspace\Agi\zrd-nb666\campus_health_app\backend\database\daily_metrics.sql", encoding='utf-8') as f:
    sql = f.read()
with conn.cursor() as cur:
    for stmt in sql.split(';'):
        s = stmt.strip()
        if s:
            cur.execute(s)
conn.commit()
print('table daily_health_metrics created')
conn.close()