Comment 1 for bug 1464271

Revision history for this message
Ekaterina Chernova (efedorova) wrote :

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.