Spaces:
Running
Running
from sqlalchemy import create_engine | |
from sqlalchemy.orm import sessionmaker | |
from sqlalchemy.ext.declarative import declarative_base | |
from core.config import settings | |
DB_URL = settings.DATABASE_URL | |
# Crear una instancia de motor SQLAlchemy | |
engine = create_engine(DB_URL,pool_pre_ping=True) | |
# Crear una instancia de sessionmaker | |
SessionLocal = sessionmaker(autocommit=False,autoflush=False,bind=engine) | |
# Crear una clase base para las clases de modelo | |
Base = declarative_base() | |
# Funcino para crear la sesion de base de datos | |
def get_session(): | |
database = SessionLocal() | |
try: | |
yield database | |
finally: | |
database.close() |