mysql flask中的游标工作不正常

5gfr0r5j  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(267)

这是app.py文件的模块和配置部分。

from flask import Flask, render_template, flash, request, logging, redirect, 
url_for, session
from data import Blogs
from flaskext.mysql import MySQL
from wtforms import Form, StringField, TextAreaField, PasswordField, 
validators
from passlib.hash import sha256_crypt

mysql = MySQL()

app = Flask(__name__)
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PORT'] = 5000
app.config['MYSQL_DATABASE_PASSWORD'] = '123456'
app.config['MYSQL_DATABASE_DB'] = 'myflaskapp'
app.config['MYSQL_DATABASE_CURSORCLASS'] = 'DictCursor'

mysql.init_app(app)

这是@app.route部分

@app.route('/register', methods=['GET', 'POST'])
def register():

# have used wtforms

form = RegisterForm(request.form)
   if request.method == 'POST' and form.validate(): 
       id = form.id.data
       name = form.name.data
       username = form.username.data
       email = form.email.data
       password = sha256_crypt.encrypt(str(form.password.data))
       college = form.college.data
       year = form.year.data

       # Create cursor

       cur = mysql.get_db().cursor()

       # Execute query

       cur.execute("INSERT INTO users(id, name, username, email, password, 
       college, year) VALUES(%s, %s, %s, %s, %s, %s, %s)", (id, name, 
       username, email, password, college, year))

       flash('You are now registered and can log in', 'success')

       return redirect(url_for('login'))
    return render_template('register.html', form=form)

我正在获取不允许的方法请求的url不允许该方法。请帮我解决这个问题。
这是在macosx上
请帮帮我。谢谢您。

sd2nnvve

sd2nnvve1#

改变 VALUES(%s, %s, %s, %s, %s, %s, %s)", (id, name, username, email, password, college, year)) 收件人: VALUES('{}', '{}' ,'{}', '{}', '{}', '{}', '{}')".format(id, name, username, email, password, college, year))

相关问题