Automated SQL Script Tests with PostgreSQL and Docker

Описание: Run your SQL script code base end to end from scratch to catch any breaking change.

If you found this video helpful, you can buy me a coffee:
☕ https://www.buymeacoffee.com/muratoks...

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