BY JAMEL REID
This is the second tutorial in a 3-part series dedicated to demonstrating how to use a tool called Slacker for database testing.
In this video, Jamel goes through the process of getting Ruby installed on Windows 10. This allows installing the Slacker gem to our environment which will then be used to generate a base project for our automation in the upcoming tutorial. We recommend watching Tutorial One to get a full understanding before starting this one.
Go to Tutorial Three: How to Write Tests
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.