public void DbQueryWaitStepOk()
{
var step = new DbQueryStep();
step.ConnectionString = "Data Source=.\\btsloc;Initial Catalog=BizUnitDb;Integrated Security=True";
step.SQLQuery = new SqlQueryExtended();
step.SQLQuery.RawSqlQuery = "CREATE TABLE dbo.Test ( Value int NOT NULL ); INSERT INTO dbo.Test Values (1);";
step.NumberOfRowsExpected = 0;
step.Execute(new Context());
var target = new DbQueryWaitStep();
target.ConnectionString = "Data Source=.\\btsloc;Initial Catalog=BizUnitDb;Integrated Security=True";
target.DelayBeforeCheck = 1;
target.Timeout = 50000;
target.SQLQuery = new SqlQueryExtended();
target.SQLQuery.RawSqlQuery = "SELECT * FROM dbo.Test WHERE Value = {0}";
target.SQLQuery.QueryParameters = new Collection <object>();
target.SQLQuery.QueryParameters.Add(1);
target.NumberOfRowsExpected = 1;
try
{
target.Execute(new Context());
}
finally
{
step.SQLQuery.RawSqlQuery = "DROP TABLE dbo.Test;";
step.NumberOfRowsExpected = 0;
step.Execute(new Context());
}
}
public void DbQueryWaitStepNok()
{
var step = new DbQueryStep();
step.ConnectionString = "Data Source=.\\btsloc;Initial Catalog=BizUnitDb;Integrated Security=True";
step.SQLQuery = new SqlQueryExtended();
step.SQLQuery.RawSqlQuery = "CREATE TABLE dbo.Test ( Value int NOT NULL ); INSERT INTO dbo.Test Values (1);";
step.NumberOfRowsExpected = 0;
step.Execute(new Context());
var target = new DbQueryWaitStep();
target.ConnectionString = "Data Source=.\\btsloc;Initial Catalog=BizUnitDb;Integrated Security=True";
target.DelayBeforeCheck = 1;
target.Timeout = 5000;
target.SQLQuery = new SqlQueryExtended();
target.SQLQuery.RawSqlQuery = "SELECT * FROM dbo.Test WHERE Value = {0}";
target.SQLQuery.QueryParameters = new Collection <object>();
target.SQLQuery.QueryParameters.Add(1);
target.NumberOfRowsExpected = 2;
try
{
target.Execute(new Context());
throw new AssertFailedException("Wait succeeded");
}
catch (Exception ex)
{
testContextInstance.WriteLine("Found exception: {0}", ex.GetType());
}
finally
{
step.SQLQuery.RawSqlQuery = "DROP TABLE dbo.Test;";
step.NumberOfRowsExpected = 0;
step.Execute(new Context());
}
}