initialize_db.py

import sys
from sqlalchemy import engine_from_config
from pyramid.paster import get_appsettings
from ..models import Base


def main(argv=sys.argv[1:]):
    conf_file = argv[0]
    settings = get_appsettings(conf_file)
    engine = engine_from_config(settings, 'sqlalchemy.')
    engine.echo = True
    Base.metadata.create_all(engine)