initializedb.py

import sys
import transaction
from sqlalchemy import (engine_from_config,    )
from pyramid.paster import (
    get_appsettings,
    setup_logging,
    )

    
from ..models import * 
    
from opensipkd.base.scripts.initializedb import create_schema

def main(argv=sys.argv):
    config_uri = argv[1]
    setup_logging(config_uri)
    settings = get_appsettings(config_uri)
    engine = engine_from_config(settings, 'sqlalchemy.')
    Base.metadata.bind = engine
    create_schema(engine, 'eis')
    Base.metadata.create_all(bind=engine)
    DBSession.configure(bind=engine)

    transaction.commit()
    print('****EIS CREATED****')