Skip to content

Home

Jump to bottom Edit New page
Vassil Kovatchev edited this page Dec 10, 2018 · 61 revisions

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
Add a custom footer
Clone this wiki locally