def connect_database(self): """ Use sqlalchemy to connect directly to the database file on disk. """ from sqlalchemy import create_engine engine = create_engine("sqlite:///config/cookbook.sqlite") DBSession.configure(bind=engine) Base.metadata.create_all(engine) return DBSession
def main(argv=sys.argv): """ Create a completely empty database.""" if len(argv) < 2: usage(argv) config_uri = argv[1] options = parse_vars(argv[2:]) setup_logging(config_uri) settings = get_appsettings(config_uri, options=options) engine = engine_from_config(settings, "sqlalchemy.") DBSession.configure(bind=engine) Base.metadata.create_all(engine)
def main(global_config, **settings): """ This function returns a Pyramid WSGI application. """ engine = engine_from_config(settings, "sqlalchemy.") DBSession.configure(bind=engine) Base.metadata.bind = engine auth_tkt_pol = AuthTktAuthenticationPolicy authentication_policy = auth_tkt_pol(auth_policy_secret, callback=access_verifier, hashalg='sha512') authorization_policy = ACLAuthorizationPolicy() config = Configurator(settings=settings, root_factory="cookbook.models.RootFactory", authentication_policy=authentication_policy, authorization_policy=authorization_policy) config.include("pyramid_chameleon") # Static assets include thumbnails, turn off caching to ensure they # are reloaded in a timely fashion config.add_static_view("assets", "assets", cache_max_age=1) config.add_route("file_add", "/file_add/{checkout_id}") config.add_route("file_view", "/file_view/{checkout_id}/{filename}") config.add_route("checkout_list", "/checkout_list/") config.add_route("checkout_add", "/checkout_add/") config.add_route("checkout_view", "/checkout/{checkout_id}") config.add_route("checkout_delete", "/checkout_delete/{checkout_id}") config.add_route("login", "/login/google") config.add_route("logout", "/logout/google") config.add_route("user_view", "/user_view/") config.add_route("analyze_view", "/analyze/") config.add_route("analyze_long_term_view", "/analyze_long_term/") config.add_route("serial_view", "/{serial}") config.add_route("home_redirect", "/") config.scan("cookbook.views") return config.make_wsgi_app()