schema check on startup

[ericbuckley]

Summary

On application startup, verify that database tables match the ORM.

Acceptance Criteria

• A new function that verifies the tables called from the create_sessionmaker function
• Tests to show that it works (may need to programmatically alter the tables in the test cases to show this)

Details / Tasks

On application startup, the database tables are optionally created. That is, they are only created if they don't exist. It's possible thought that the columns don't align to the ORM state. Enhance the startup procedure to verify that the database columns, name and type, match those specified of the ORM, if there is a mismatch raise a SQLAlchemyError with mismatch details.

Background / Context

Take a look at sqlalchemy.inspect for getting table information.