Create test that makes sure all migrations are sane
|Reported by:||Christopher Allan Webber||Owned by:|
We should have a unit test that instantiates the tables at their first, pre-migration state (basically right after the move to SQL, commit ce29c140ed90fe0e19ed1b68ca8f7cf27aa03e8e) and runs all migrations, then creates a new database and instantiates the models at their current state, and sees if they match. If they don't, the test should fail.
Note: we can't test for constraints in sqlalchemy, but we should otherwise be able to test to moderately general migration sanity.
(Bonus points if it adds a user and a couple of media entries with appropriate media files, etc, but not required to close this bug.)