cur = mysql.connector.cursor() AttributeError：“MySQL”对象没有“”connector“”属性“”

Question

我正尝试在pycharm IDE中使用python、flask和mysql数据库创建一个简单的登录表单。

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


mysql = MySQL()

app = Flask(__name__)

app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = 'root'
app.config['MYSQL_DATABASE_DB'] = 'regform'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'

mysql.init_app(app)


@app.route('/')
def reg():
    return render_template('login.html')

@app.route('/home', methods=['POST', 'GET'])
def reg2():
    email = request.form['uname']
    password = request.form['psw']
    cursor = mysql.connect().cursor()
    # cursors.execute('SELECT * FROM signup WHERE email = '"+email+"'and password = '"+ password +"'')
    cursor.execute('SELECT * FROM signup WHERE email = %s AND password = %s', (email, password))

    data = cursor.fetchone()
    if data is None:
        return 'no user'
    else:
        return 'welcome'

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

没有错误，但没有输出。我做错什么了？

Answer 1

根据Flask-MySQL (https://flask-mysql.readthedocs.io/en/latest/)的官方文档，您必须执行以下操作才能获得光标：

mysql = MySQL()
mysql.init_app(app)
cursor = mysql.get_db().cursor()