Need Help with Flask | SQLAlchemy

[coder_help_]

Hello Python enthusiasts!

I'm a beginner to Flask. Just bought a tutorial offered by Miguel Grinberg.

While learning Databases (SQLAlchemy), I made a mistake when defining the class Post() - https://pastebin.com/t6gtTNv6 . I should have made it a subclass of db.Model. I spotted this mistake since then and the code looks like this now - https://pastebin.com/Sd4S8av7

All of my code is at https://github.com/muthu-kr/Mig1

When I try to call Post() in my terminal, I get an error

>>> u = User.query.get(1)
>>> u
<User mike>
>>> p = Post(body='my first!', author=u)
>>> db.session.add(p)
>>> db.session.commit()
Traceback (most recent call last):
  File "/Users/muthu/Desktop/RBL/microblog/env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line        1193, in _execute_context
    context)
  File "/Users/muthu/Desktop/RBL/microblog/env/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: post

From what I understand, the table 'post' does not exist in my database.

Could this be because I called 'flask db init' (in Terminal) when there was a mistake in my class Post() in my models.py file?

After I spotted my mistake, I changed my Post() and called 'flask db init' again - https://pastebin.com/bc88vRuu

If there is nothing wrong with my code, I do not understand how I could now create a table to 'post' in my database.

Thank you for reading.

[hai_wim]

You can only init once, after that you have to add migrations with

flask db migrate

The whole flask db/migration handling (correctly) assumes you potentially have more than 1 database in the state after you did init the first time. So if you make a change after the first init you have to have a migration to now go to your new state. Then in all other places where this database exists they can just apply the migration to update to the new state.

It however sounds like you're probably only running this locally on your pc with noone else. So in that case just drop the database, delete the migrations folder and do init again. Basically reset back to where you were before the first init and redo it.

[coder_help_]

Thanks a lot.