sqlalchemy.exc.OperationalError: (OperationalError) no such table

Hello Miguel, I’ve finished your book and tried to build a “notebook” project without the help of the book. “Notebook” is a simplified flasky, no User, no Role, no Migrate, No Manage, just Post.

I thought it would be easy, and everything went well until I added these two lines in views.py: posts = Post.query.order_by(Post.timestamp.desc()).all() return render_template('index.html', current_time = datetime.utcnow(), form = form, posts = posts) I got the following error: sqlalchemy.exc.OperationalError: (OperationalError) no such table

I read issue #18, but still can’t solve my problem(I didn’t use manager to modify the command line). Could you please tell me what’s wrong with it? Thank you !!

Here’s my code:

run.py

# -*- coding:utf-8 -*-
from app import create_app
app = create_app()
if  __name__ == '__main__':
     app.run(debug = True)

init.py

from flask import Flask
from flask_sqlalchemy import SQLAlchemy 
from flask_moment import Moment
from flask_bootstrap import Bootstrap


moment = Moment ()
bootstrap = Bootstrap()
db = SQLAlchemy()

def create_app():
    app = Flask(__name__)
    moment.init_app(app)
    bootstrap.init_app(app)
    app.secret_key = 'SECRET_KEY'
    db.init_app(app)
    with app.app_context():
           db.create_all()

    from .main import main as main_blueprint
    app.register_blueprint(main_blueprint)

    return app

views.py

from flask import render_template, redirect, url_for, session
from datetime import datetime
from . import main
from app.forms import PostForm
from flask_login import current_user
from ..models import Post


@main.route('/', methods = ['GET', 'POST'])
def index():
    form = PostForm()
    if form.validate_on_submit():
        post = Post(body = form.body.data)
        db.session.add(post)
        db.session.commit()
        return redirect(url_for('.index'))
    posts = Post.query.order_by(Post.timestamp.desc()).all()
    return render_template('index.html', current_time = datetime.utcnow(), form = form, posts = posts)

@main.errorhandler(404)
def page_not_found(e):
    return render_template('404.html'), 404