I understand that if the test hits database, then its an integration test. But w... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

fadzlan on April 23, 2018 | parent | context | favorite | on: Software Testing Anti-patterns

I understand that if the test hits database, then its an integration test.

But what if a whole load of the logics are in stored procedure? Surely those needs test too.

Of course, one can make an argument that depending too much on stored procedures is an anti pattern....

atom-morgan on April 23, 2018 [–]

The stored procedure should be tested within the domain of the stored procedure. The consumer of its result just tests its ability to use the result it should be given (fulfilling its end of the contract).

Consider applying for YC's Spring batch! Applications are open till Feb 11.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact