okuma-app / backend /database.py
Cihan Emre ŞAHİN
init with lfs
e94bb15
Raw History Blame Contribute Delete
1.43 kB
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from typing import Generator
import os
from dotenv import load_dotenv
load_dotenv()
# Get DATABASE_URL from environment
# Default to SQLite for PythonAnywhere compatibility
DATABASE_URL = os.environ.get("DATABASE_URL") or os.getenv("DATABASE_URL", "sqlite:///./okuma.db")
# Debug: Print the database URL (will show in logs)
print(f"DATABASE_URL configured: {DATABASE_URL[:50]}..." if DATABASE_URL else "DATABASE_URL not set!")
# SQLite requires special connect_args
connect_args = {"check_same_thread": False} if DATABASE_URL.startswith("sqlite") else {}
engine = create_engine(DATABASE_URL, connect_args=connect_args)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()
def get_db() -> Generator:
"""
Database session dependency for FastAPI routes
"""
db = SessionLocal()
try:
yield db
finally:
db.close()
def init_db():
"""
Initialize database tables
"""
# Import all models to ensure they are registered with Base
from models.user import User
from models.story import Story
from models.reading_activity import PreReading, Answer
from models.evaluation import TeacherEvaluation
from models.quiz import QuizQuestion
Base.metadata.create_all(bind=engine)