数据库问题sqlite3。Flas的操作错误

Question

嘿，我做的这个小项目有点麻烦。在

基本上，我在试图构建一个治疗师和他的病人。我有两个数据库模型，治疗师和病人。治疗师注册或登录，我有治疗师的登记表和登录表。在

治疗师成功登录或注册后，会被引导到主页，在那里他可以单击链接来注册患者。我已经设置了patientregistrationform。在

我有两件事有麻烦。在

在我的项目中，一旦我运行了它，并且在注册表单上输入字段来创建一个用户/治疗师，我就得到了一个错误。我相信这是模型类中的一个错误，但我不知道为什么。在

我一周前才开始做这个，所以，如果有人能帮我的话，我真的很感激。在

• sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: user [SQL: 'SELECT user.id AS user_id, user.username AS user_username, user.email AS user_email, user.password_hash AS user_password_hash \nFROM user \nWHERE user.username = ?\n LIMIT ? OFFSET ?'] [parameters: ('yohannes', 1, 0)] (Background on this error at: http://sqlalche.me/e/e3q8)

这是我的模型文件

from app import db, login
from flask_login import UserMixin
from werkzeug.security import generate_password_hash, check_password_hash

class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(64), index=True, unique=True)
    email = db.Column(db.String(120), index=True, unique=True)
    password_hash = db.Column(db.String(128))
    patients = db.relationship('Patient', backref='author', lazy='dynamic')

    def __repr__(self):
        return '<User {}>'.format(self.username)

    def set_password(self, password):
        self.password_hash = generate_password_hash(password)

    def check_password(self, password):
        return check_password_hash(self.password_hash, password)


@login.user_loader
def load_user(id):
    return User.query.get(int(id))

class Patient(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    firstname = db.Column(db.String(64))
    lastname = db.Column(db.String(64))
    dateofbirth = db.Column(db.String(32))
    typeoftherapy = db.Column(db.String(64))
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

    def __repr__(self):
        return '<Patient {}>'.format(self.firstname)

这是我的表单文件

^{pr2}$

这是我的路由文件

from flask import render_template, flash, redirect, url_for, request
from flask_login import login_user, logout_user, current_user, login_required
from werkzeug.urls import url_parse
from app import app, db
from app.forms import PatientSignUpForm, TherapistLoginForm, TherapistRegistrationForm
from app.models import Patient, User

@app.route('/')
@app.route('/index')
@login_required

def index():
    patients = [
        {
            'doctor': {'username': 'Yohannes'},
            'treatment': 'Physical Therapy'
        },
        {
            'doctor': {'username': 'Henok'},
            'treatment': 'Mental Therapy'
        }

    ]
    return render_template('index.html', title ='Home', user=user, patients=patients)

@app.route('/patients')

def patients():
    patient = Patient.query.filter_by(firstname=firstname).all()
    patients = [
    {'Patient': patient}, {'Patient': patient}
    ]
    return render_template('base.html', patient=patient)


@app.route('/signup', methods=['GET', 'POST'])
def login():
    if current_user.is_authenticated:
        return redirect(url_for('index'))
    form = TherapistLoginForm()
    if form.validate_on_submit():
        user = Therapist.query.filter_by(username=form.username.data).first()
        if user is None or not Therapist.check_password(form.password.data):
            flash('Invalid username or password')
            return redirect(url_for('login'))
        login_user(user, remember=form.remember_me.data)
        next_page = request.args.get('next')
        if not next_page or url_parse(next_page).netloc != '':
            next_page = url_for('index')
        return redirect(next_page)
    return render_template('login.html', title='Sign In', form=form)

@app.route('/logout')
def logout():
    logout_user()
    return redirect(url_for('index'))

@app.route('/register', methods=['GET', 'POST'])
def register():
    if current_user.is_authenticated:
        return redirect(url_for('index'))
    form = TherapistRegistrationForm()
    if form.validate_on_submit():
        user = User(username=form.username.data, email=form.email.data)
        user.set_password(form.password.data)
        db.session.add(user)
        db.session.commit()
        flash('Congratulations, you are now a registered user!')
        return redirect(url_for('login'))
    return render_template('register.html', title='Register', form=form)

Answer 1

sqlite3的错误非常好，它告诉您no such table: user这正是它所说的-在您的数据库中没有名为user的表。你初始化数据库了吗？你有数据库文件吗？在

我建议您使用Flask-Migrate进行数据库初始化和迁移。在