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 dbsession(self): if self._dbsession is None: engine = create_engine(self.registry.settings['sqlalchemy.url']) self._dbsession = create_dbsession(engine) return self._dbsession