WSGI应用程序sqlalchemy无法创建引擎

Question

我正试图用Werkzeug构建一个小型的WSGI应用程序。我遵循了这个tutorial它是如此简单明了。但是我遇到了这个错误：

File "/Users/username/my_app/assigment2/app.py", line 38, in __init__
self.database_engine = create_engine(db_uri)
File "/Users/Data/lib/python3.4/site-packages/sqlalchemy/engine/__init__.py", line 386, in create_engine
return strategy.create(*args, **kwargs)
File "/Users/../lib/python3.4/site-packages/sqlalchemy/engine/strategies.py", line 51, in create
dialect_cls = u.get_dialect()
AttributeError: 'function' object has no attribute 'get_dialect'

我已经导入了所有SqlAlchemy模块

^{pr2}$

应用程序在应用程序的init失败。在

class App(object):
def __init__(self):
    local.app = self
    self.database_engine = create_engine(SQLALCHEMY_DATABASE_URI )
    self.jinja_env = Environment(loader=PackageLoader('app', '/templates'))
    self.dispatch = SharedDataMiddleware(self.dispatch, {'/static':  STATIC_PATH})

def init_database(self):
    metadata.create_all(self.database_engine)

def dispatch(self, environ, start_response):
    local.app = self
    request = Response(environ)
    local.url_= adapter = url_map.bind_to_environ(environ)
    #adapter = url_map.bind_to_environ(environ)
    try:
        endpoint, value = adapter.match()
        handler = getattr(views, endpoint)
        response = handler(request, **values)
    except HTTPException as e:
        response = e
    return ClosingIterator(response(environ, strat_response),
                            [session.remove, local_manager.cleanup])

def __call__(self, environ, start_response):
    return self.dispatch(environ, start_response)

数据库的uri如下所示

SQLALCHEMY_DATABASE_URI = 'postgresql://user:password@localhost:5432/name_db'

STATIC_PATH = path.join(path.dirname('/static'), 'static')

为什么我不能像这样创建我的应用程序：

def make_app():
   my_app = app.App()
   return my_app

我在古尼康跑

gunicorn -b 127.0.0.1:9000 app:make_app

新错误：

TypeError: make_app() takes 0 positional arguments but 2 were given

Answer 1

这是错误的：

gunicorn -b 127.0.0.1:9000 app:App

有请求时会发生什么：

^{pr2}$

但你真正想要的是：

your_app = app.App(path, db_uri)
your_app(environ, start_response)

将gunicorn调用改为如下所示：

gunicorn -b 127.0.0.1:9000 'app:App("/static/path", "postgresql://...")'