lundi 1 février 2016

Do sqllite tables exist after migration

enter image description here

I've come across a cookiecutter flask app which has a lot of potential as a base flask app -- http://ift.tt/1FCBkFS. This thing has Bootstrap 3, asset bundling+minification, starter templates, and registration/authentication systems and other good things (Thank you Will). I'm starting to play with it but have been unable to get the local dev db working, although I have run a migration to create the tables:

$ python manage.py db migrate
INFO  [alembic.migration] Context impl SQLiteImpl.
INFO  [alembic.migration] Will assume non-transactional DDL.
INFO  [alembic.autogenerate.compare] Detected added table 'tags'
INFO  [alembic.autogenerate.compare] Detected added table 'users'
INFO  [alembic.autogenerate.compare] Detected added table 'posts'
INFO  [alembic.autogenerate.compare] Detected added table 'tags_posts'
Generating C:\envs\r2\myflaskapp\migrations\versions\....

Unfortunately although according to my pycharm db window I'm connected,

enter image description here

I cannot see the schema. Also when I try to create a user account I get:

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

Does the table exist, if so how can I see it?

Aucun commentaire:

Enregistrer un commentaire