Рет қаралды 39
Run your SQL script code base end to end from scratch to catch any breaking change.
WHY?
You have a living SQL script codebase
New scripts are added/removed/changed everyday
You want to protect stability
Catch any regression
You need automated SQL script tests that will run all of your scripts from scratch!
HOW?
Prepare a PostgreSQL docker image that will run all SQL scripts
If any of the script fails, container will close with a proper message
Order of the scripts important, i.e. tables should be created before views
Kill the container whatever the result is, success or failure