#!/usr/bin/env python
"""Initialize SQLite database with proper schema."""

import sys
from pathlib import Path

# Add backend to path
sys.path.insert(0, str(Path(__file__).parent.parent))

from sqlalchemy import create_engine

from core.models.base import Base


def init_database():
    """Create all database tables."""
    # Use SQLite database - path relative to project root
    database_url = "sqlite:///./fraud_detection.db"

    print(f"Creating database: {database_url}")
    engine = create_engine(database_url, echo=True)

    # Create all tables
    print("Creating tables...")
    Base.metadata.create_all(bind=engine)

    print("✅ Database schema created successfully!")
    print(f"Tables created: {list(Base.metadata.tables.keys())}")

if __name__ == "__main__":
    init_database()