Ndtyjky

Hey I am having trouble with this little project I am doing.

Basically, I am trying to structure a therapist and his patients. I have two models of the database, therapist and patient. Therapist signs up or logs-in, I have both a registration Form and a Login Form for the therapist.

After therapist successfully logs in or registers, it is led to the home page where he can click a link to register patients. I have already set a patientregistrationform as well.

I am having trouble with two things.

On my project once I run it, and I put in fields on the registration form to create a user/therapist, I get an error. I believe it is an error in the model class, but I can't figure out why.

I just started doing this a week ago, so, I really would appreciate it if someone could help me with this.

• 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)

This is my models file

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)

and this is my forms file

from flask_wtf import FlaskForm

from wtforms import StringField, PasswordField, BooleanField, SubmitField

from wtforms.validators import ValidationError, DataRequired, EqualTo, Email

from app.models import User, Patient



class PatientSignUpForm(FlaskForm):

    firstname = StringField('First Name', validators=[DataRequired()])

    lastname = StringField('Last Name', validators=[DataRequired()])

    dateofbirth = StringField('Date of Birth', validators=[DataRequired()])

    typeoftherapy = StringField('Type of Therapy', validators=[DataRequired()])

    submit = SubmitField('Sign Up Patient')



class TherapistLoginForm(FlaskForm):

    username = StringField('Username', validators=[DataRequired()])

    password = PasswordField('Password', validators=[DataRequired()])

    remember_me = BooleanField('Remember Me')

    submit = SubmitField('Sign In')



class TherapistRegistrationForm(FlaskForm):

    username = StringField('Username', validators=[DataRequired()])

    email = StringField('Email', validators=[DataRequired(), Email()])

    password = PasswordField('Password', validators=[DataRequired()])

    password2 = PasswordField(

        'Repeat Password', validators=[DataRequired(), EqualTo('password')])

    submit = SubmitField('Register')



    def validate_username(self, username):

        user = User.query.filter_by(username=username.data).first()

        if user is not None:

            raise ValidationError('Please use a different username.')



    def validate_email(self, email):

        user = User.query.filter_by(email=email.data).first()

        if user is not None:

            raise ValidationError('Please use a different email address.')

This is my routes file

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)

The error from sqlite3 is very good, it tells you no such table: user which means exactly what it says - there is no table in your database called user. Have you initialised your database? Do you have a database file?

I suggest you use Flask-Migrate for your database init and migrations.