Can flask-peewee do migration?

Question

I want to use flask peewee as ORM for a relational db (MySQL) but my problem is changes in structure of models... like adding new attributes for a model (this means columns in db). I want to know if I can do this automatically without writing SQL manually?

Answer 1

It looks like the Peewee module does support migrations.

http://peewee.readthedocs.org/en/latest/peewee/playhouse.html#schema-migrations

Answer 2

We developed https://github.com/keredson/peewee-db-evolve for our company's use that sounds like it may be helpful for you.

Rather than manually writing migrations, db-evolve calculates the diff between the existing schema and your defined models. It then previews and applies the non-destructive SQL commands to bring your schema into line. We've found it to be a much more robust model for schema management. (For example, switching between arbitrary branches with different schema changes is trivial this way, vs. virtually impossible w/ manually authored migrations.)

Example:

Think of it as a non-destructive version of Peewee's create_tables(). (In fact we use it for exactly that all the time, to build the schema from scratch in tests.)