不能使db在本地主机上用烧瓶工作

Question

我现在使用的是最基本的代码，它仍然不起作用：

from flask import Flask, render_template
from flaskext.mysql import MySQL

mysql = MySQL()
app = Flask(__name__)

# MySQL configurations
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = ''
app.config['MYSQL_DATABASE_DB'] = 'people'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
mysql.init_app(app)

@app.route('/test')
def test():
    conn = mysql.connect()
    cursor = conn.cursor()
    sql = "SELECT * from tbl_user"
    cursor.execute(sql)
    results = cursor.fetchall()
    cursor.close()
    conn.close()
    return results

if __name__ == "__main__":
    app.run(debug=True)

我尝试通过Mysql cli在本地主机上连接到我的db，它工作得很好。我使用了mysql -u根目录，它接受它，然后我使用用户，它工作得很好，然后我就可以做select语句了。

下面是我遇到的错误：

Traceback (most recent call last):
  File "C:\Python27\lib\site-packages\flask\app.py", line 1836, in __call__
    return self.wsgi_app(environ, start_response)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1820, in wsgi_app
    response = self.make_response(self.handle_exception(e))
  File "C:\Python27\lib\site-packages\flask\app.py", line 1403, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1817, in wsgi_app
    response = self.full_dispatch_request()
  File "C:\Python27\lib\site-packages\flask\app.py", line 1478, in full_dispatch_request
    response = self.make_response(rv)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1577, in make_response
    rv = self.response_class.force_type(rv, request.environ)
  File "C:\Python27\lib\site-packages\werkzeug\wrappers.py", line 847, in force_type
    response = BaseResponse(*_run_wsgi_app(response, environ))
  File "C:\Python27\lib\site-packages\werkzeug\wrappers.py", line 57, in _run_wsgi_app
    return _run_wsgi_app(*args)
  File "C:\Python27\lib\site-packages\werkzeug\test.py", line 871, in run_wsgi_app
    app_rv = app(environ, start_response)
TypeError: 'tuple' object is not callable

但是正如你所看到的，一旦我使用了烧瓶，我就会得到这个错误。

Answer 1

这个问题与flaskext.mysql和db连接无关。在@app.route('/test')语句中，返回一个元组，这是从数据库中选择的结果。在水瓶中，您应该返回一些适切。

Answer 2

视图应该返回一个模板或HTML代码(以字符串格式)。我猜您试图显示数据库查询的结果，所以正确的方法是使用render_template()函数通过模板传递数据。看看这里：http://flask.pocoo.org/docs/0.10/quickstart/#rendering-templates