/// <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()); }