import mysql.connector
import os
from dotenv import load_dotenv

load_dotenv()

db = mysql.connector.connect(
    host=os.getenv("DB_HOST"),
    user=os.getenv("DB_USER"),
    password=os.getenv("DB_PASS"),
    database=os.getenv("DB_NAME")
)
cursor = db.cursor()
try:
    cursor.execute("ALTER TABLE users ADD COLUMN recommendations JSON DEFAULT NULL")
    db.commit()
    print("✅ recommendations kolonna pievienota.")
except Exception as e:
    print(f"❌ Kļūda: {e}")
db.close()