import pymysql

conn = pymysql.connect(
    host="127.0.0.1",
    user="root",
    password="ra8raffi!",
    database="gazenergie",
    charset="utf8mb4",
)
c = conn.cursor()
c.execute("SELECT id, company_name FROM companies WHERE company_name LIKE 'Aare%' LIMIT 1")
cid, name = c.fetchone()
print("company", cid, name)
c.execute(
    "SELECT period_type, total_sale_kwh, endconsumers_kwh, sector_private_households_kwh, sector_wkk_kwh "
    "FROM gas_reports WHERE company_id=%s AND report_year=2026",
    (cid,),
)
print("sectors", c.fetchone())
c.execute(
    "SELECT module_key, CHAR_LENGTH(payload_json) FROM module_forms "
    "WHERE company_id=%s AND report_year=2026 ORDER BY module_key",
    (cid,),
)
print("forms", c.fetchall())
c.execute(
    "SELECT username, email, first_name, last_name FROM supplier_contacts WHERE company_id=%s",
    (cid,),
)
print("contact", c.fetchall())
c.execute("SELECT COUNT(*) FROM users WHERE username='administrator_gazenergie'")
print("admin_ok", c.fetchone()[0])
c.execute("SELECT COUNT(*) FROM companies")
print("companies_total", c.fetchone()[0])
conn.close()