Check if the result of data migration (ORM) matches? models

Question

I use migrate to create an SQL database schema and populate it with raw data. Later, SQLAlchemy is used to work with this database.

How can I verify that my SQLAlchemy models are relevant / correct for the actual database schema generated by migrate ?

Answer 1

I have not tested it, but in the list of functions this tool seems to want if you want:

http://metacpan.org/pod/SQL::Translator::Manual

* FIND DIFFERENCES BETWEEN TWO SCHEMES As mentioned above, the sqlt-diff schema considers two schemas and creates SQL schema modification instructions that can be used to convert the first schema to the second. The flag syntax is somewhat fancy:

$ sqlt-diff foo-v1.sql = MySQL foo-v2.sql = Oracle> diff.sql *

tool homepage: http://sqlfairy.sourceforge.net/