public void Given_Select_1_With_Result_0_Should_Be_Valid_With_AreNotEqual_AssertType() { var test = new Test { Name = "someTest", TestValue = "Select 1", ExpectedResults = new ExpectedResultList { new ExpectedResult(1, 1, 1, 1, "0", 0) { AssertType = new AssertType(2, "AreNotEqual") } }, TestType = new TestType(1, "sqlsnippet", "", true) }; var sqlVal = new SqlScriptValidator(); var valResult = sqlVal.Validate( _connection, test); Assert.IsTrue(valResult.IsValid); Console.WriteLine(valResult.ResultMessage); }
public ValidationResponse Validate() { var scriptVal = new SqlScriptValidator(); Response = scriptVal.Validate(Connection, Test); return(Response); }
private static Collection <ValidationResponse> ExecuteTests(IEnumerable <Test> tests, Connection connection) { var scriptVal = new SqlScriptValidator(); var valResponse = new Collection <ValidationResponse>(); foreach (var test in tests) { var valResult = scriptVal.Validate(connection, test); if (valResult == null) { continue; } valResponse.Add(valResult); } return(valResponse); }
public void Given_Select_1_With_Result_0_Should_Not_Be_Valid() { var test = new Test { Name = "someTest", TestValue = "Select 1", ExpectedResults = new ExpectedResultList { new ExpectedResult(1, 1, 1, 1, "0", 0) {AssertType = new AssertType(1, "AreEqual")} }, TestType = new TestType(1, "sqlsnippet", "", true) }; var sqlVal = new SqlScriptValidator(); var valResult = sqlVal.Validate( _connection, test); Assert.IsFalse(valResult.IsValid); Console.WriteLine(valResult.ResultMessage); }
private void btnRun_Click(object sender, EventArgs e) { var repo = new WebApiRepositoryContext("http://*****:*****@"Data Source=(localdb)\V11.0;Initial Catalog=Chinook;Integrated Security=True;", true, true); if (connection.ConnectionProviderId != null) { connection.ConnectionProvider = repo.ConnectionProviderRepository.GetDataById(connection.ConnectionProviderId).FirstOrDefault(); } var valResult = scriptVal.Validate(connection , _test); repo.RunHistoryRepository.Insert(_test.Id, null, null, connection.ConnectionId, valResult.RunDateTime, valResult.Duration, valResult.IsValid, valResult.RunLog); MessageBox.Show(valResult.IsValid.ToString()); }
public void Given_Invalid_TestValue_With_Result_0_Should_Not_Be_Valid() { var test = new Test { Name = "someTest", TestValue = "Gibberish", ExpectedResults = new ExpectedResultList { new ExpectedResult(1, 1, 1, 1, "0", 0) { AssertType = new AssertType(1, "AreEqual") } }, TestType = new TestType(1, "sqlsnippet", "", true) }; var sqlVal = new SqlScriptValidator(); var valResult = sqlVal.Validate( _connection, test); Assert.IsFalse(valResult.IsValid); Console.WriteLine(valResult.ResultMessage); }