from sqlmodel import Session, create_engine, select
from database import settings
from models import User
from routers.auth import get_password_hash

engine = create_engine(settings.DATABASE_URL)

def seed_user():
    with Session(engine) as session:
        # Check if user exists
        existing = session.exec(select(User).where(User.username == "Mediatroy@gmail.com")).first()
        if not existing:
            user = User(
                username="Mediatroy@gmail.com",
                email="mediatroy@gmail.com",
                full_name="Media Troy",
                hashed_password=get_password_hash("password123")
            )
            session.add(user)
            session.commit()
            print("✅ User 'Mediatroy@gmail.com' created successfully with password 'password123'")
        else:
            print("ℹ️ User already exists.")

if __name__ == "__main__":
    seed_user()