models.py

from contextlib import contextmanager

from sqlalchemy import Column, ForeignKey, Integer, String, Boolean, DateTime, Text
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker, Session

Base = declarative_base()

engine = create_engine(database_url[0], echo=False)


@contextmanager
def session_scope():
    """Provide a transactional scope around a series of operations."""
    session = Session(bind=engine)
    try:
        yield session
    except:
        session.rollback()
        raise
    finally:
session.close()


class Names(Base):
    ....
    
..... DEFINE MODELS AS NORMAL ......

stuff.py

from models import session_scope, Names, <ModelNames we want to use>

with session_scope() as session:
  names = session.query(Names).all()