smart-reader-backend / app /db /database.py
Mohamed478's picture
Safely handle connection failure without crashing Uvicorn
84643f9
Raw History Blame Contribute Delete
1.94 kB
import os
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
db_url = os.environ.get("DATABASE_URL", "").strip().strip("\"'")
if db_url.startswith("postgres://"):
db_url = db_url.replace("postgres://", "postgresql://", 1)
if not db_url or db_url == "DATABASE_URL" or not (db_url.startswith("postgresql://") or db_url.startswith("sqlite://")):
print("[Database Info] DATABASE_URL is missing or invalid. Using default local SQLite database.")
SQLALCHEMY_DATABASE_URL = "sqlite:///./smart_reader.db"
else:
if "supabase" in db_url and "sslmode" not in db_url:
if "?" in db_url:
db_url += "&sslmode=require"
else:
db_url += "?sslmode=require"
SQLALCHEMY_DATABASE_URL = db_url
if SQLALCHEMY_DATABASE_URL.startswith("sqlite"):
engine = create_engine(
SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False}
)
else:
try:
temp_engine = create_engine(SQLALCHEMY_DATABASE_URL, pool_pre_ping=True, connect_args={"connect_timeout": 5})
with temp_engine.connect() as conn:
pass
engine = temp_engine
masked = SQLALCHEMY_DATABASE_URL
if "@" in masked:
p = masked.split("@")
masked = f"{p[0].split(':')[0]}:****@{p[1]}"
print(f"[Database Info] CONNECTED TO REMOTE POSTGRESQL: {masked}")
except Exception as e:
print(f"[Database Warning] Could not connect to PostgreSQL ({e}). Falling back to local SQLite database.")
SQLALCHEMY_DATABASE_URL = "sqlite:///./smart_reader.db"
engine = create_engine(SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False})
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()
def get_db():
db = SessionLocal()
try:
yield db
finally:
db.close()