text: /**
   * \file
   * \brief  Unit tests for the AssertInteger* functions.
   * \author Chris Oldwood
   */
  
  create procedure test._@Test@_AssertIntegerEqualTo_ShouldPass_WhenValuesAreEqual
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerEqualTo 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerEqualTo_ShouldFail_WhenValuesDiffer
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerEqualTo 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerEqualTo_ShouldFail_WhenExpectedValueIsNull
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerEqualTo null, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerEqualTo_ShouldFail_WhenActualValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerEqualTo 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerNotEqualTo_ShouldPass_WhenValuesDiffer
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerNotEqualTo 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerNotEqualTo_ShouldFail_WhenValuesAreEqual
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerNotEqualTo 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerNotEqualTo_ShouldFail_WhenExpectedValueIsNull
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerNotEqualTo null, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerNotEqualTo_ShouldFail_WhenActualValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerNotEqualTo 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerIsNull_ShouldPass_WhenValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerIsNull @actual;
  go
  
  create procedure test._@Test@_AssertIntegerIsNull_ShouldFail_WhenValueIsNotNull
  as
  	declare @actual int;
  	set		@actual = 42;
  
  	exec ssunit.AssertIntegerIsNull @actual;
  go
  
  create procedure test._@Test@_AssertIntegerIsNotNull_ShouldFail_WhenValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerIsNotNull @actual;
  go
  
  create procedure test._@Test@_AssertIntegerIsNotNull_ShouldPass_WhenValueIsNotNull
  as
  	declare @actual int;
  	set		@actual = 42;
  
  	exec ssunit.AssertIntegerIsNotNull @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThan_ShouldPass_WhenValueLessThan
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerLessThan 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThan_ShouldFail_WhenValueNotLessThan
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerLessThan 41, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThan_ShouldFail_WhenValuesAreEqual
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerLessThan 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThan_ShouldFail_WhenExpectedValueIsNull
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerLessThan null, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThan_ShouldFail_WhenActualValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerLessThan 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThan_ShouldPass_WhenValueGreaterThan
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerGreaterThan 41, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThan_ShouldFail_WhenValueNotGreaterThan
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerGreaterThan 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThan_ShouldFail_WhenValuesAreEqual
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerGreaterThan 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThan_ShouldFail_WhenExpectedValueIsNull
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerGreaterThan null, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThan_ShouldFail_WhenActualValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerGreaterThan 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThanOrEqualTo_ShouldPass_WhenValueLessThan
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerLessThanOrEqualTo 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThanOrEqualTo_ShouldPass_WhenValuesAreEqual
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerLessThanOrEqualTo 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThanOrEqualTo_ShouldFail_WhenValueNotLessThan
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerLessThanOrEqualTo 41, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThanOrEqualTo_ShouldFail_WhenExpectedValueIsNull
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerLessThanOrEqualTo null, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerLessThanOrEqualTo_ShouldFail_WhenActualValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerLessThanOrEqualTo 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThanOrEqualTo_ShouldPass_WhenValueGreaterThan
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerGreaterThanOrEqualTo 41, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThanOrEqualTo_ShouldPass_WhenValuesAreEqual
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerGreaterThanOrEqualTo 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThanOrEqualTo_ShouldFail_WhenValueNotGreaterThan
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerGreaterThanOrEqualTo 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThanOrEqualTo_ShouldFail_WhenExpectedValueIsNull
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerGreaterThanOrEqualTo null, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerGreaterThanOrEqualTo_ShouldFail_WhenActualValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerGreaterThanOrEqualTo 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldFail_WhenLowerValueIsNull
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerBetween null, 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldFail_WhenUpperValueIsNull
  as
  	declare @actual int;
  	set		@actual = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerBetween 41, null, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldFail_WhenActualValueIsNull
  as
  	declare @actual int;
  	set		@actual = null;
  
  	exec ssunit.AssertIntegerBetween 41, 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldFail_WhenUpperBoundLessThanLowerBound
  as
  	declare @actual int = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerBetween 43, 41, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldFail_WhenActualValueIsLessThanLowerBound
  as
  	declare @actual int = 40;
  
  	exec ssunit.AssertIntegerBetween 41, 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldFail_WhenActualValueIsGreaterThanUpperBound
  as
  	declare @actual int = 44;
  
  	exec ssunit.AssertIntegerBetween 41, 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldPass_WhenActualValueIsEqualToLowerBound
  as
  	declare @actual int = 41;
  
  	exec ssunit.AssertIntegerBetween 41, 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldPass_WhenActualValueIsEqualToUpperBound
  as
  	declare @actual int = 43;
  
  	exec ssunit.AssertIntegerBetween 41, 43, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldPass_WhenActualValueIsEqualToLowerAndUpperBounds
  as
  	declare @actual int = dbo.GetIntegerValue();
  
  	exec ssunit.AssertIntegerBetween 42, 42, @actual;
  go
  
  create procedure test._@Test@_AssertIntegerBetween_ShouldPass_WhenValueAndRangeIsNegative
  as
  	declare @actual int = -42;
  
  	exec ssunit.AssertIntegerBetween -43, -41, @actual;
  go
  
  exec ssunit.RunTests;
  