import os
import pymysql
from dotenv import load_dotenv

load_dotenv("/home/maxi/Projekt/wtc.waiswuaschd.de/.env")

conn = pymysql.connect(
    host=os.getenv("MARIADB_HOST", "db.waiswuaschd.de"),
    user=os.getenv("MARIADB_USER", "v2_usr_wtc_cookbook"),
    password=os.getenv("MARIADB_PASS", "XKikHf&j6Wj!rs5%A8#ZzyvE#*A1hT"),
    database=os.getenv("MARIADB_NAME", "v2_db_wtc_cookbook"),
    charset="utf8mb4",
    cursorclass=pymysql.cursors.DictCursor
)

with conn.cursor() as cur:
    cur.execute("DESCRIBE recipes")
    columns = cur.fetchall()
    print("Columns in recipes:")
    for col in columns:
        print(f"  {col['Field']} - {col['Type']} (Null: {col['Null']})")

conn.close()