samedi 20 mars 2021

I'm getting a programming error any idea on how to fix it?

here are the files which contain my code:

this is models.py file

from . import db
from flask_login import UserMixin
from sqlalchemy import func

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(150), unique=True)
    password = db.Column(db.String(150))
    first_name = db.Column(db.String(150))
    notes = db.relationship('Note')

class Note(db.Model):
    time = func.now()
    id = db.Column(db.Integer, primary_key=True)
    data = db.Column(db.String(1000))
    date = db.Column(db.DateTime(timezone=True), default=time)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

and this is views.py

from flask import Blueprint, render_template, request
from flask_login import login_required, current_user
from .models import Note
from . import db

views = Blueprint('views', __name__)

@views.route('/notes', methods=['GET', 'POST'])
@login_required
def notes():
    if request.method == 'POST':
        note = request.form.get('note')
        new_note = Note(data=note, id=current_user.id)
        db.session.add(new_note)
        db.session.commit()
    return render_template('notes.html', user=current_user)

I got the error

sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError) 1054 (42S22): Unknown column 'user_id' in 'field list' [SQL: INSERT INTO note (id, data, date, user_id) VALUES (%(id)s, %(data)s, now(), %(user_id)s)] [parameters: {'id': 1, 'data': 'get a ', 'user_id': None}]

Any idea on where I messed

up and how to fix it ?




Aucun commentaire:

Enregistrer un commentaire