Flask SQLAlchemy AttributeError: 'str' object has no attribute '_sa_instance_state'

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

# routes.py
@app.route('/personal_blog', methods = ['GET', 'POST'])
def personal_blog():
    form = CommentForm()
    if form.validate_on_submit():
        user = User(username = form.username.data, email = form.email.data)        
        post = Post(body = form.comment.data, author = user.username)
        db.session.add(user)
        db.session.add(post)
        db.session.commit()
        flash('Your comment is now live!')  
        return redirect(url_for('personal_blog', _anchor='translate-hover'))  
    posts = Post.query.order_by(Post.timestamp.desc()).all()
    return render_template('personal_blog.html', title = 'Personal Blog', form = form, posts = posts)

#models.py
class User(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)
    posts = db.relationship('Post', backref='author', lazy='dynamic')

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    body = db.Column(db.String(500))
    timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) 
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

# routes.py @app.route('/personal_blog', methods = ['GET', 'POST']) def personal_blog(): form = CommentForm() if form.validate_on_submit(): user = User(username = form.username.data, email = form.email.data) post = Post(body = form.comment.data, author = user.username) db.session.add(user) db.session.add(post) db.session.commit() flash('Your comment is now live!') return redirect(url_for('personal_blog', _anchor='translate-hover')) posts = Post.query.order_by(Post.timestamp.desc()).all() return render_template('personal_blog.html', title = 'Personal Blog', form = form, posts = posts) #models.py class User(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) posts = db.relationship('Post', backref='author', lazy='dynamic') class Post(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(500)) timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'))