id,summary,reporter,owner,description,type,status,priority,milestone,component,resolution,keywords,cc,parents 551,Create test that makes sure all migrations are sane,Christopher Allan Webber,,"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.)",enhancement,accepted,major,,programming,,test,lotusecho,