import os

from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker


engine = create_engine(
    'mysql+pymysql://{user}:{password}@{host}:{port}/{database_name}'.format(
        user=os.environ['MYSQL_DB_USER'],
        password=os.environ['MYSQL_DB_PASS'],
        host=os.environ['MYSQL_DB_HOST'],
        port=int(os.environ.get('MYSQL_DB_PORT', 3306)),
        database_name=os.environ['MYSQL_DB_NAME']))
session = scoped_session(sessionmaker(bind=engine))