SQLAlchemy boilerplate for experiments

sa.py

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import scoped_session
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

# Define models here

engine = create_engine('sqlite:///:memory:', echo=True)
Base.metadata.create_all(engine)
Session = scoped_session(sessionmaker(bind=engine))

if __name__ == '__main__':
    session = Session()
    
    # Derp with SQL here