Added upgrade test infrastructure

microsoft / durabletask-mssql

Microsoft SQL storage provider for Durable Functions and the Durable Task Framework

MIT License

87 stars 32 forks source link

Added upgrade test infrastructure #130

Closed cgillum closed 1 year ago

cgillum commented 1 year ago

Resolves #124 Resolves #191

This PR introduces a tool for generating SQL databases with data from the v1.0.0 release of the SQL provider as well as a new test that restores the generated database and runs tests against it. This is necessary to ensure that databases can be auto-upgraded and that no data loss occurs as part of the upgrade.

keerthikiranvalathoru commented 1 year ago

This is quite simple yet very powerful suite of tests. I was browsing through the code for some other things and and found this gem of a PR that is a template on how to have database compatibility and upgrade tests. Thanks very much !