Re: KeyError: 'sqlnotapplicable' when running alembic revision --autogenerate

2020-09-04 Thread Ke Zhu - k...@us.ibm.com
Mike, Thanks for replying! This is the CREATE TABLE statement when running command `alembic upgrade +1 —sql`: CREATE TABLE "GITHUB_ACTIVE_USERS" ( "EMAIL" VARCHAR(255), "GITHUB_LOGIN" VARCHAR(255), "DT" VARCHAR(10), "DT_MONTH" VARCHAR(7) ); I’ve noticed that no constraints are

Re: KeyError: 'sqlnotapplicable' when running alembic revision --autogenerate

2020-09-04 Thread Mike Bayer
this warning is the culprit: SAWarning: index key 'sqlnotapplicable' was not located in columns for table ‘github_active_users' I believe you should report this to the ibm_db_sa folks. https://github.com/ibmdb/python-ibmdbsa/issues you would need to share the "CREATE TABLE" statements whic

KeyError: 'sqlnotapplicable' when running alembic revision --autogenerate

2020-09-03 Thread Ke Zhu - k...@us.ibm.com
I added new model, then run $ pipenv run alembic revision --autogenerate -m "Add new table TRAVIS_ACTIVE_USERS" --depends-on= Then I got this: INFO [alembic.runtime.migration] Context impl Db2Impl. INFO [alembic.runtime.migration] Will assume non-transactional DDL. /root/.local/share/virtuale