def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
# Configure sqlalchemy engine
engine = engine_from_config(settings, 'sqlalchemy.')
# Create a sessionmaker
sessionmaker = sqla_sessionmaker()
sessionmaker.configure(bind=engine)
# Get us a dbsession
dbsession = sessionmaker()
# Register said dbsession against the transaction manager
zope.sqlalchemy.register(dbsession,
transaction_manager=transaction.manager)
# Using the metadata create all objects
Base.metadata.create_all(engine)
with transaction.manager:
u = User(email='*****@*****.**', credentials='testing')
dbsession.add(u)
def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
# Configure sqlalchemy engine
engine = engine_from_config(settings, 'sqlalchemy.')
# Create a sessionmaker
sessionmaker = sqla_sessionmaker()
sessionmaker.configure(bind=engine)
# Get us a dbsession
dbsession = sessionmaker()
# Register said dbsession against the transaction manager
zope.sqlalchemy.register(dbsession, transaction_manager=transaction.manager)
# Using the metadata create all objects
Base.metadata.create_all(engine)
with transaction.manager:
u = User(email='*****@*****.**', credentials='testing')
dbsession.add(u)
def _sessionmaker(self):
''' SQLAlchemy sessionmaker for the current `Thread`.
'''
orm_state = self.sqla_state
if self.serial_sessions:
sessionmaker = orm_state.sessionmaker
else:
sessionmaker = self._sessionmaker_raw
if sessionmaker is None:
sessionmaker = sqla_sessionmaker(bind=self.engine)
self._sessionmaker_raw = sessionmaker
orm_state.sessionmaker = sessionmaker # pylint: disable=attribute-defined-outside-init
return sessionmaker
def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
# Configure sqlalchemy engine
engine = engine_from_config(settings, 'sqlalchemy.')
# Create a sessionmaker
sessionmaker = sqla_sessionmaker()
sessionmaker.configure(bind=engine)
# Get us a dbsession
dbsession = sessionmaker()
# Register said dbsession against the transaction manager
zope.sqlalchemy.register(dbsession, transaction_manager=transaction.manager)
# Drop all tables/everything
Base.metadata.drop_all(engine)
def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
# Configure sqlalchemy engine
engine = engine_from_config(settings, 'sqlalchemy.')
# Create a sessionmaker
sessionmaker = sqla_sessionmaker()
sessionmaker.configure(bind=engine)
# Get us a dbsession
dbsession = sessionmaker()
# Register said dbsession against the transaction manager
zope.sqlalchemy.register(dbsession,
transaction_manager=transaction.manager)
# Drop all tables/everything
Base.metadata.drop_all(engine)
def build_sessionmaker(settings, prefix='sqlalchemy.'):
engine = engine_from_config(settings, prefix)
sessionmaker = sqla_sessionmaker()
sessionmaker.configure(bind=engine)
return sessionmaker
