Jump to content
David Schwartz

Unit testing for server-side assets

Recommended Posts

I can't recall ever seeing any discussions about unit testing of server-side assets, like views, stored procs, and functions.

 

Does anybody do it?

Share this post


Link to post

We do various types of tests (which would categorise I suppose amongst others as smoke tests, integration tests, golden master tests and regression tests) which do verify behaviours by back-end/server side assets like views and stored procedures.  We do also directly exercise some server side assets directly in some of the automated tests for behaviour and outputs, we probably don't do nearly enough of this.  (We do test bootstrap the entire back-end from scratch.)   There are SQL based unit testing frameworks/tools/approaches, we don't yet do this, but we probably should.  (https://tsqlt.org/ for example.)

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×