Re: MySQL ForeignKey indexes being removed

2016-12-27 Thread Adam Patt
Doing the ignore in the include_object did the trick. That is exactly what I needed. Thanks! On Friday, December 23, 2016 at 3:36:10 PM UTC-8, mike bayer wrote: > > MyISAM does not actually record foreign key definitions. Autogenerate > is not compatible with foreign keys that are declared

Re: MySQL ForeignKey indexes being removed

2016-12-23 Thread mike bayer
MyISAM does not actually record foreign key definitions. Autogenerate is not compatible with foreign keys that are declared in the model yet are not actually present in the database due to MyISAM. To keep these FK definitions in Python but work around the autogenerate issue, create an

MySQL ForeignKey indexes being removed

2016-12-23 Thread Adam Patt
I'm using mysql 5.1.73 and alembic 0.8.6 and even when the model has not changed. Below I have the schema migration which is getting auto generated as well as the models defs. This is using MyISAM and when I look at the Foreign Keys tab in MySQL Workbench, it says foreign keys can only be used