sql_alchemy_boilerplate.py

import sqlalchemy as sa
from sqlalchemy.ext.declarative import as_declarative, declared_attr
from sqlalchemy.orm import relationship, sessionmaker


engine = sa.create_engine('sqlite://')
Session = sessionmaker(bind=engine)


@as_declarative()
class Base(object):
    @declared_attr
    def __tablename__(cls):
        return cls.__name__.lower() + 's'

    id = sa.Column(sa.Integer, primary_key=True)