Files
papi-py/db.py
stephen schuresko b9bf105939
All checks were successful
Build and Push to Private Registry101 / build (push) Successful in 33s
feat: update Dockerfile and Makefile for improved deployment; add integration testing instructions and version endpoint
2025-02-18 08:29:31 -05:00

24 lines
603 B
Python

from sqlalchemy import create_engine, Column, Integer,String, ForeignKey
from sqlalchemy.engine import URL
from sqlalchemy.orm import sessionmaker, Session, declarative_base
import os
# Database setup
DATABASE_URL = "sqlite:///./test.db"
if os.getenv("DATABASE_URL"):
DATABASE_URL = os.getenv("DATABASE_URL")
engine = create_engine(DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()
version = os.environ.get("VERSION", "0.0.0")
def get_db():
db = SessionLocal()
try:
yield db
finally:
db.close()