MySQL 数据库查询返回整数而不是行数据

Question

我正在尝试测试以表单提交的信息（电子邮件地址和密码）是否已存在于数据库中。如果电子邮件存在，我想检查数据库中相应的哈希密码是否与提交的密码的哈希版本匹配。这是我的登录路线的完整摘录：# Login [e-mail]("/login", methods=["GET", "POST"])def login():    """Log user in"""    # Forget any user_id    session.clear()    # User reached route via POST (as by submitting a form via POST)    if request.method == "POST":        # Create a cursor        cur = mysql.connection.cursor()        # Ensure email was submitted        if not request.form.get("email"):            return apology("must provide email", 403)        # Ensure password was submitted        elif not request.form.get("password"):            return apology("must provide password", 403)        # Store email in a variable        email = request.form.get("email")        # Query if email is within database        query = cur.execute("SELECT * FROM users WHERE email = %s", (email,))        # Ensure email exists and that the password is correct        if len(query) != 1 or not check_password_hash(query[0]["hashedpassword"], request.form.get("password")):            return apology("invalid email and/or password", 403)        # Remember which user has logged in        session["user_id"] = query[0]["id"]        # Redirect user to the homepage        return redirect("/")    # User reached route via GET (as by clicking a link or via redirect)    else:        return render_template("login.html")我遇到困难的部分是：        # Ensure email exists and that the password is correct        if len(query) != 1 or not check_password_hash(query[0]["hashedpassword"], request.form.get("password")):            return apology("invalid email and/or password", 403)在这里，我尝试从数据库中提取指定电子邮件地址的单行信息。我试图使用 len 来查看是否存在单行（不能存在两行，因为我已确保电子邮件地址列在数据库中是唯一的），因此应该只有单行或没有。

Answer 1

你缺少的部分是

rows = cursor.fetchall()

它将返回数据给您，您将能够在其上实现您的逻辑rows