Re: Autogenerate -> unknown table popping up in sqlalchemy.exc.NoSuchTableError

[Mike Bayer]

On 5/31/15 7:00 PM, Wavemaker wrote:
Well, upon digging further myself, I noticed that was an old foreign 
key in my Pictures table referring to the non-existant auth_user table:
     sql: "last_changed_user_id" integer NOT NULL REFERENCES 
"auth_user" ("id")
This was not referenced anymore in the model. So, I guess that in 
order to use alembic properly I should not have manually deleted that 
table (in fact I did that before starting to use alembic), but to 
remove both the table and the foreign key in the model and then let 
alembic apply both changes to the database in one go. Correct?

that doesn't make too much sense because a relational database can't 
have a FOREIGN KEY to a table that doesn't exist.     *unless* this is 
SQLite, which is just an odd case.   feel free to manually delete 
whatever tables you want, you just need to make sure you keep track of 
what's going on when you point a schema reflection tool at that database 
at some later point.


For reference purposes still find here the complete stack trace 
without having the solution applied yet. Note again that I inserted 
some debug statements here and there in the sqlalchemy/alembic code, 
so line numbers may deviate.

Traceback (most recent call last):
  File "virtualenv\Scripts\alembic-script.py", line 11, in <module>
    load_entry_point('alembic==0.7.6', 'console_scripts', 'alembic')()
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\config.py", line 439, in main
    CommandLine(prog=prog).main(argv=argv)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\config.py", line 433, in main
    self.run_cmd(cfg, options)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\config.py", line 416, in run_cmd
    **dict((k, getattr(options, k)) for k in kwarg)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\command.py", line 113, in revision
    script.run_env()
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\script.py", line 390, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\util.py", line 243, in load_python_file
    module = load_module_py(module_id, path)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\compat.py", line 79, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "alembic\env.py", line 99, in <module>
    run_migrations_online()
  File "alembic\env.py", line 92, in run_migrations_online
    context.run_migrations()
  File "<string>", line 7, in run_migrations
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\environment.py", line 738, in run_migrations
    self.get_context().run_migrations(**kw)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\migration.py", line 300, in run_migrations
    for step in self._migrations_fn(heads, self):
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\command.py", line 95, in retrieve_migrations
    autogen._produce_migration_diffs(context, template_args, imports)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\autogenerate\api.py", line 154, in _produce_migration_diffs
    autogen_context, object_filters, include_schemas)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\autogenerate\api.py", line 256, in _produce_net_changes
    inspector, metadata, diffs, autogen_context)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\alembi
c\autogenerate\compare.py", line 84, in _compare_tables
    inspector.reflecttable(t, None)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\engine\reflection.py", line 590, in reflecttable
    exclude_columns, reflection_options)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\engine\reflection.py", line 720, in _reflect_fk
    **reflection_options
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\sql\schema.py", line 441, in __new__
    metadata._remove_table(name, schema)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\util\langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\sql\schema.py", line 432, in __new__
    table._init(name, metadata, *args, **kw)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\sql\schema.py", line 513, in _init
    self._autoload(metadata, autoload_with, include_columns)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\sql\schema.py", line 528, in _autoload
    self, include_columns, exclude_columns
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\engine\base.py", line 1481, in run_callable
    return callable_(self, *args, **kwargs)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\engine\default.py", line 364, in reflecttable
    return insp.reflecttable(table, include_columns, exclude_columns)
  File "F:\Workspace\MyProject\src\virtualenv\Lib\site-packages\sqlalc
hemy\engine\reflection.py", line 578, in reflecttable
    raise exc.NoSuchTableError(table.name)
sqlalchemy.exc.NoSuchTableError: auth_user
--
You received this message because you are subscribed to the Google 
Groups "sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to sqlalchemy-alembic+unsubscr...@googlegroups.com 
<mailto:sqlalchemy-alembic+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups 
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.