When I delete my post that has a comment in it, and post the exact same thing again the comments will reappear on tutorial #4

[ZerubbabelT]

Am experiencing an issue, where deleted posts appear to be remembered with previous comments, could be related to how the database is handling deletions and caching. And I want the db to delete my comment associated with post.

I don't know if this is only for me.

try posting(for ex. 'test') and adding some comments. Now delete every post you made. Then post 'test'. If you are encountering the same problem as me and know how to fix this please help me.

[ZerubbabelT]

Fixed my problem by deleting the comments manually from the database when I delete my post.

`@views.route('/delete-post/')
@login_required
def delete_post(id):
post = Post.query.filter_by(id=id).first()
comments = Comment.query.filter_by(post_id=id).all()

if not post:
    flash("Post doesn\'t exists",category="error")
elif current_user.id != post.author:
    flash("You don\'t have permission to delete this post",category="error")
else:
    for comment in comments:
        if comment:
            db.session.delete(comment)
    db.session.delete(post)
    db.session.commit()
    flash("Post deleted!!",category="success")

return redirect(url_for("views.home"))`