Python中Flask-mysql fetchall的问题

Question

我需要些帮助。我不能通过python从mysql中获取所有结果。我得到了这个错误:这个页面不工作127.0.0.1意外关闭了连接。ERR_CONTENT_LENGTH_MISMATCH

下面是我的代码：

​

...
from flaskext.mysql import MySQL
...
app = Flask(__name__)
mysql=MySQL(app)
# config mysql
app.config['MYSQL_DATABASE_HOST'] = '****'
app.config['MYSQL_DATABASE_USER'] = '****'
app.config['MYSQL_DATABASE_PASSWORD'] = '****'
app.config['MYSQL_DATABASE_DB'] = '****'
app.config['MYSQL_DATABASE_PORT'] = ****
# Init
mysql.init_app(app)

...

@app.route('/myapps')
@is_logged_in
def myapps():
    cur = mysql.get_db().cursor()
    username = session['username']
    result = cur.execute("select * from appointments where username= %s",[username])
    if result > 0:
        myapps = cur.fetchall()
        return render_template('myapps.html', myapps = myapps)
    else:
        msg = 'No appointments found'
        return render_template('myapps.html', msg=msg)
    cur.close()

<tbody>
            {% for app in myapps %}
          <tr>
            <th scope="row">{{app.app_id}}</th>
            <td>{{app.services}}</td>
            <td>{{app.start_date}}</td>
            <td>{{app.end_date}}</td>
            <td>{{app.start_hour}}</td>
            <td>{{app.end_hour}}</td>
            <td>{{app.creation_date}}</td>
            <td>{{app.username}}</td>
          </tr>
          {% endfor %}
        </tbody>

​

任何帮助都将不胜感激！

Answer 1

mysql.get_db().cursor(buffered=True)

尝试将buffered参数设置为True inside cursor。

Answer 2

谢谢你们，但是我通过使用

导入pymysql