/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
SqlDatabaseTestAction Database_RetrieveRandomCountryTest_TestAction;
var resources = new ComponentResourceManager(typeof(Countries));
RowCountCondition rowCountCondition1;
Database_RetrieveRandomCountryTestData = new SqlDatabaseTestActions();
Database_RetrieveRandomCountryTest_TestAction = new SqlDatabaseTestAction();
rowCountCondition1 = new RowCountCondition();
//
// Database_RetrieveRandomCountryTest_TestAction
//
Database_RetrieveRandomCountryTest_TestAction.Conditions.Add(rowCountCondition1);
resources.ApplyResources(Database_RetrieveRandomCountryTest_TestAction,
"Database_RetrieveRandomCountryTest_TestAction");
//
// rowCountCondition1
//
rowCountCondition1.Enabled = true;
rowCountCondition1.Name = "rowCountCondition1";
rowCountCondition1.ResultSet = 1;
rowCountCondition1.RowCount = 1;
//
// Database_RetrieveRandomCountryTestData
//
Database_RetrieveRandomCountryTestData.PosttestAction = null;
Database_RetrieveRandomCountryTestData.PretestAction = null;
Database_RetrieveRandomCountryTestData.TestAction = Database_RetrieveRandomCountryTest_TestAction;
}
private static SqlDatabaseTestAction ResultsetShouldBe(this SqlDatabaseTestAction action,
int resultSet,
string[,] expectedStrings,
bool allowStringNulls)
{
return(action.AddConditions(ConditionsForTable(resultSet, expectedStrings, allowStringNulls).ToArray()));
}
private static void AddConditions(this SqlDatabaseTestAction action,
params TestCondition[] conditions)
{
foreach (var testCondition in conditions)
{
action.Conditions.Add(testCondition);
}
}
public void ExecuteWithSortings(
ConnectionContext scriptExecutionContext,
ConnectionContext privilegedExecutionContext,
SqlDatabaseTestAction action,
ResultsetSorting[] sortings,
params DbParameter[] sqlParameters)
{
if (action == null)
{
return;
}
if (scriptExecutionContext == null)
{
throw new AssertFailedException("Script execution context cannot be null");
}
if (privilegedExecutionContext == null)
{
throw new AssertFailedException("Privileged execution context cannot be null");
}
string sqlScript = action.SqlScript;
if (string.IsNullOrEmpty(sqlScript?.Trim()) && !action.Conditions.Any())
{
Trace.WriteLine("Skipping execution...");
return;
}
SqlExecutionResult[] results = ExecutionEngine2.ExecuteTest(scriptExecutionContext, action.SqlScript, sqlParameters);
var tables = results[0].DataSet.Tables.Cast <DataTable>().ToArray();
results[0].DataSet.Tables.Clear();
int i = 1;
foreach (var table in tables)
{
var sorting = sortings.FirstOrDefault(x => x.ResultsetNumber == i);
if (sorting == null)
{
results[0].DataSet.Tables.Add(table);
}
else
{
table.DefaultView.Sort = sorting.ResultsetSortExpression;
results[0].DataSet.Tables.Add(table.DefaultView.ToTable());
}
i += 1;
}
ExecutionEngine2.EvaluateConditions(privilegedExecutionContext.Connection, results, action.Conditions);
}
protected override void OnBeforeInitializeTest()
{
if (TestInitializeAction == null)
{
TestInitializeAction = new SqlDatabaseTestAction();
}
TestInitializeAction.SqlScript =
$"BEGIN TRAN\nSAVE TRAN TestRun\n{TestInitializeAction.SqlScript}";
if (TestCleanupAction == null)
{
TestCleanupAction = new SqlDatabaseTestAction();
}
TestCleanupAction.SqlScript =
$"{TestCleanupAction.SqlScript}\nROLLBACK TRAN TestRun";
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
SqlDatabaseTestAction Database_PersistTeachersTest_TestAction;
var resources = new ComponentResourceManager(typeof(Teachers));
Database_PersistTeachersTestData = new SqlDatabaseTestActions();
Database_PersistTeachersTest_TestAction = new SqlDatabaseTestAction();
//
// Database_PersistTeachersTest_TestAction
//
resources.ApplyResources(Database_PersistTeachersTest_TestAction, "Database_PersistTeachersTest_TestAction");
//
// Database_PersistTeachersTestData
//
Database_PersistTeachersTestData.PosttestAction = null;
Database_PersistTeachersTestData.PretestAction = null;
Database_PersistTeachersTestData.TestAction = Database_PersistTeachersTest_TestAction;
}
private static void ResultsetShouldBe(this SqlDatabaseTestAction action,
int resultSet,
string[,] expectedStrings)
{
action.AddConditions(ConditionsForTable(resultSet, expectedStrings).ToArray());
}
