Database Testing using Slacker: How to write a test

This is the third tutorial in a 5-part series dedicated to demonstrating how to do Database Testing with Slacker.(Watch tutorial two here)

In this tutorial, we will:

Examine our project structure

Configure our server credentials

Create data for the test in the form of CSV files and

Write and execute our first test in Slacker.

Why use Slacker for Database Testing

Unit tests are used to check if small chunks of code are functioning as they should. It allows developers and stakeholders to verify that the code being implemented meets specification. Databases have not always benefited from unit testing. However, in recent times, multiple tools such as Slacker have emerged that allow us to tackle this problem.

Slacker is a transactional RSpec-based framework for developing automated tests for SQL Server (2005-2017) programmable objects such as stored procedures, scalar/table functions, triggers, etc. The framework has the added benefit of being able to be integrated into the Visual Studio built-in Unit Test Runner. This allows it to add value and advance confidence in the development of your database.

Jamel is QA engineer at QualityWorks who specializes in Automation using Node.js and Unit Testing SQL Server Databases. Outside of the workspace, he's an adventure junkie with a love for nature and basketball.