Home

Slacker

Slacker is a transactional RSpec-based framework for developing automated tests for SQL Server 2005-2017 and Azure SQL programmable objects such as stored procedures, scalar/table functions, triggers, etc.

describe 'Get_Top_Customers' do

  it 'ranks customers using the "Avg Weighted Days to Pay" ranking method' do

    # Load test data into table dbo.Customer.
    load_csv('customer_seed_data.csv', 'dbo.Customer')

    # Run stored procedure Get_Top_Customers and match resultset against expected results.
    expect(sproc('dbo.Get_Top_Customers', :limit => 5)).to match('expected_results.csv')

  end

end

• Installation
• Quick Start
• Slacker Project
• Running Slacker
• Slacker Tests
• Helper Modules
• SQL Trace Scripts
• Variable Interpolation