Re:Ask HN: How do you test SQL?
by inetknght on Tuesday January 31, 2023 @05:34PM
(#34603322)
bonus points if you add test data for integration tests with sad paths too
[ Parent
| on HN ]
Absolutely this. I stood up a negative test suite for continuous DB queries late in 2020 and it's caught many potential show stopper integration issues since; about 45% more YoY than pre-suite.
Took about a week of duplicating happy path tests, investigating gaps, and switching inputs/assertion types to get everything passing, but less than a week later we had our first verifiable test failure.