import pandas as pd
import mysql.connector

# Connessione al DB
conn = mysql.connector.connect(
    host='localhost',
    user='root',
    password= '5!1CYZP(DM?D',
    database='axess'
)

cursor = conn.cursor()

# Carica CSV
df = pd.read_csv("wh_data.csv", sep=';', quotechar='"')

# Query di insert
sql = """
    INSERT INTO wh_data (
        WHD_id, WHD_cht_id, WHD_org_name_l1, WHD_org_site, WHD_org_site_area,
        WHD_mac, WHD_signal, WHD_timestamp, WHD_day, WHD_hour,
        WHD_minute, WHD_second, WHD_is_random_mac, WHD_fingerprint, WHD_AP_mac
    ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
"""

# Inserisci riga per riga
for row in df.itertuples(index=False):
    cursor.execute(sql, tuple(row))

conn.commit()
cursor.close()
conn.close()