autogenerate for first revision of existing database

Issue #37 on hold
Anonymous created an issue

I tried create simple test project, create user and database, create table via

{{{ User.table.create(bind=db.engine) }}}

and run autogenerate, alembic (or sqlalchemy?) don't recognize TYPE fields.

{{{

alembic revision --autogenerate -m "test autogenerate"

INFO [alembic.migration] Context impl PostgresqlImpl. INFO [alembic.migration] Will assume transactional DDL. /Volumes/storage/code/venv/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py:47: SAWarning: Did not recognize type '"TYPE_SEX"' of column 'sex' ret = fn(self, con, args, *kw) INFO [alembic.autogenerate] Couldn't determine database type for column 'user.sex' Generating /Volumes/storage/code/alemb/alembproject/versions/eca99148094_test_au togenerate.py...done }}}

Attached project code.

Thanks.

Comments (7)

  1. Log in to comment