Скачать или смотреть 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