def includeme(config):
engine = engine_from_config(config.registry.settings, 'sqlalchemy.')
dbsession = create_dbsession(engine)
zope.sqlalchemy.register(dbsession)
config.register_service(
dbsession,
name='db'
)
config.register_service_factory(
link_service_factory,
name='link'
)
config.register_service_factory(
hashid_service_factory,
name='hashid'
)
config.register_service_factory(
task_service_factory,
name='task'
)
config.register_service_factory(
file_service_factory,
name='file'
)
def db(request):
"""Session-scoped sqlalchemy database connection"""
engine = create_engine('postgresql://suma@/suma_test')
dbsession = create_dbsession(engine)
zope.sqlalchemy.register(dbsession)
# we drop before to be sure we didn't leave the previous state unclean
Base.metadata.drop_all()
Base.metadata.create_all()
dbsession.registry.clear()
request.addfinalizer(Base.metadata.drop_all)
return dbsession
def db(request):
"""Session-scoped sqlalchemy database connection"""
engine = create_engine("postgresql://suma@/suma_test")
dbsession = create_dbsession(engine)
zope.sqlalchemy.register(dbsession)
# we drop before to be sure we didn't leave the previous state unclean
Base.metadata.drop_all()
Base.metadata.create_all()
dbsession.registry.clear()
request.addfinalizer(Base.metadata.drop_all)
return dbsession
def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri, 'main')
engine = engine_from_config(settings, 'sqlalchemy.')
dbsession = create_dbsession(engine)
Base.metadata.create_all(engine)
alembic_cfg = Config(config_uri)
command.stamp(alembic_cfg, "head")
def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri, 'main')
engine = engine_from_config(settings, 'sqlalchemy.')
dbsession = create_dbsession(engine)
Base.metadata.create_all(engine)
alembic_cfg = Config(config_uri)
command.stamp(alembic_cfg, "head")
def dbsession(self):
if self._dbsession is None:
engine = create_engine(self.registry.settings['sqlalchemy.url'])
self._dbsession = create_dbsession(engine)
return self._dbsession
