Hacker News new | ask | show | jobs
by erichocean 332 days ago
There's a version of this for testing SQL database:

You have a .sql file that contains the query and then the response is next AS SQL COMMENTS. The test runner runs the query and verifies that it matches the (comment-delimiter stripped) comment immediately following the query.

Your .sql can contain database creation, inserts, you name it.

Then you run them as part of your CI infrastructure.