The problem is more complicated, that we expected
We do support SQLite migrations. that why we do have this function to support 'alter' in sqlite:
https://github.com/openstack/murano/blob/master/murano/db/migration/alembic_migrations/versions/004_change_package_desc_type.py#L39
After switching to pymysql, force ignoring of foreign keys in Mysql is not working, so it's not possible to drop the table in transform_table functions.
We can drop sqlite support and use alter in this migration.
The problem is more complicated, that we expected
We do support SQLite migrations. that why we do have this function to support 'alter' in sqlite:
https:/ /github. com/openstack/ murano/ blob/master/ murano/ db/migration/ alembic_ migrations/ versions/ 004_change_ package_ desc_type. py#L39
After switching to pymysql, force ignoring of foreign keys in Mysql is not working, so it's not possible to drop the table in transform_table functions.
We can drop sqlite support and use alter in this migration.