python - flask sqlalchemy migrate how to ignore existing tables or fields

Question

As the title states, when I upgrade, I get an error sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'period'") [SQL: u'ALTER TABLE text_template ADD COLUMN period INTEGER']

It seems to mean that the field already exists in this table. How to set it to ignore the existing table or field? Thanks

Answer 1

You can manually modify the migrate file and remove existing fields.