import os
from sqlalchemy import create_engine, text
from dotenv import load_dotenv

load_dotenv("../../.env")

db_url = os.getenv("DATABASE_URL")
if db_url.startswith("libsql://"):
    db_url = db_url.replace("libsql://", "sqlite+libsql://")

engine = create_engine(
    db_url,
    connect_args={'auth_token': os.getenv('DATABASE_AUTH_TOKEN')}
)

with engine.connect() as conn:
    conn.execute(text("DELETE FROM product_ideas WHERE id LIKE 'idea_mock_%'"))
    conn.commit()
    print("Mock data deleted successfully")