flask-sqlalchemy插入数据报错sqlalchemy.exc.OperationalError

Question

使用flask-sqlalchemy 操作mysql数据库时，注册页面填写的信息无法添加到mysql数据库中。
代码如下：

db2.py

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import pymysql
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://comejack:123456@localhost:3306/flask'
db = SQLAlchemy(app)

class User(db.Model):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key = True)
    username = db.Column(db.String(80), unique = True, nullable = False)
    password = db.Column(db.String(80), nullable = False)
    email = db.Column(db.String(120), unique = True, nullable = False)

    def __repr__(self):
        return '<User %r>' % self.username
db.create_all()

forms.py

from wtforms.fields import BooleanField, TextField, StringField, PasswordField, SubmitField
from wtforms import validators
from wtforms.validators import DataRequired
from flask_wtf import FlaskForm

class RegForm(FlaskForm):
    username = StringField('username', validators = [DataRequired()])
    password = PasswordField('password', validators = [DataRequired()])
    email = StringField('email', validators = [DataRequired()])
    submit = SubmitField('Sign Up')

run.py

# -*- coding:UTF-8 -*---
from flask import Flask, render_template, flash, redirect, request
from forms import LoginForm, RegForm
from flask_wtf.csrf import CSRFProtect
from forms import *
from db2 import *
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True
db.init_app(app)
CSRFProtect(app)

@app.route('/reg/', methods = ['GET','POST'])
def reg():
    form = RegForm()
    if form.validate_on_submit():
        user1 = User(id = 1, username = form.username.data, password = form.password.data, email = form.email.data)
        print (user1)
        db.session.add(user1)
        db.session.commit()
    return render_template('reg.html', title = 'Sign up', form = form)

app.run(host = '0.0.0.0', port = 9000, debug = True)

reg.html

{% extends "base.html" %}
{% block content %}
<h1>reg</h1>
<form action="" method="POST" name="reg">
    {{form.csrf_token}}
    <p>please enter your username:<br>
    {{form.username}} <br>
    </p>
    <p>please enter your password:<br>
    {{form.password}}<br>
    </p>
    <p>please enter your email:<br>
    {{ form.email }}<br>
    </p>
    <p>{{ form.submit }}</p>
</form>
{% endblock %}

运行python3 run.py后，在reg页面输入注册的用户名 密码 邮箱后。点击提交，出现报错
sqlalchemy.exc.OperationalError
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: user [SQL: 'INSERT INTO user (id, username, password, email) VALUES (?, ?, ?, ?)'] [parameters: (1, '123123', '123123', '[e-mail]')] (Background on this error at: http://sqlalche.me/e/e3q8)

请问如何解决。

Answer 1

配置的是mysql, 报错的却是sqlite3, 你的数据库配置没有指对吧,倒底用的是什么库呢, db类如何定义的?提示没有user这个表,需要核对下倒底有没有

Answer 2

亲，这个问题解决了么，遇到了同样的问题