Spaces:
Paused
Paused
File size: 803 Bytes
d29a5a0 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | #!/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()
|