阅读背景:

运行GAE开发服务器时,本地MySQLdb连接因paramstyle的AttributeError失败

来源:互联网 

I'm building a GAE Flask application with Flask-Alchemy, against Cloud SQL, and running dev_appserver to test the application as I build it.

我正在使用Flask-Alchemy构建一个针对Cloud SQL的GAE Flask应用程序,并在构建它时运行dev_appserver来测试应用程序。

However, if I set the SQLALCHEMY_DATABASE_URI to a mysql+gaerdbms:///appname?instance=instanceid URL, I get the following traceback when trying to call db.create_all():

但是,如果我将SQLALCHEMY_DATABASE_URI设置为mysql + gaerdbms:/// appname?instance = instanceid URL,则在尝试调用db.create_all()时会得到以下回溯:

Traceback (most recent call last):
  # earlier lines omitted for brevity
  File "/Project/app/foo.bar/foo/bar/admin/__init__.py", line 26, in init_db
    db.create_all()
  File "/Project/app/distlib/flask_sqlalchemy/__init__.py", line 856, in create_all
    self._execute_for_all_tables(app, bind, 'create_all')
  File "/Project/app/distlib/flask_sqlalchemy/__init__.py", line 848, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), tables=tables)
  File "/Project/app/distlib/flask_sqlalchemy/__init__.py", line 797, in get_engine
    return connector.get_engine()
  File "/Project/app/distlib/flask_sqlalchemy/__init__.py", line 473, in get_engine
    self._engine = rv = sqlalchemy.create_engine(info, **options)
  File "/Project/app/distlib/sqlalchemy/engine/__init__.py", line 332, in create_engine
    return strategy.create(*args, **kwargs)
  File "/Project/app/distlib/sqlalchemy/engine/strategies.py", line 69, in create
    dialect = dialect_cls(**dialect_args)
  File "/Project/app/distlib/sqlalchemy/dialects/mysql/base.py", line 1986, in __init__
    default.DefaultDialect.__init__(self, **kwargs)
  File "/Project/app/distlib/sqlalchemy/engine/default.py", line 124, in __init__
    self.paramstyle = self.dbapi.paramstyle
AttributeError: 'module' object has no attribute 'paramstyle'

What gives? Why is the (DB-API 2.0 required) paramstyle attribute missing?

是什么赋予了?为什么缺少(需要DB-API 2.0)paramstyle属性?

1 个解决方案

#1


11  

This means the MySQLdb module is missing and failed to import. The GAE SDK does not itself come with the MySQLdb client library; install MySQLdb (as instructed in the SDK documentation):

这意味着MySQLdb模块丢失且无法导入。 GAE SDK本身并不带有MySQLdb客户端库;安装MySQLdb(按照SDK文档中的说明):

venv/bin/pip install mysql-python

or use your OS package manager to install MySQLdb in your system python.

或使用您的OS包管理器在您的系统python中安装MySQLdb。

The error is caused by the Google google.appengine.api.rdbms_mysqldb module, acting as a stub, not having a paramstyle attribute when import MySQLdb fails. A stub connect() function is provided that'll raise a more helpful exception, but due to an unfortunate interaction with SQLAlchemy the error there is a lot less informative.

该错误是由Google google.appengine.api.rdbms_mysqldb模块引起的,该模块充当存根,导入MySQLdb失败时没有paramstyle属性。提供了一个stub connect()函数,它会引发一个更有用的异常,但由于与SQLAlchemy的不幸交互,错误的信息量很少。


分享到: