/// <summary>
/// Update test results specific to SQL Server alone
/// </summary>
/// <param name="test"></param>
/// <param name="tableName"></param>
/// <param name="count"></param>
internal void UpdateSqlServerTestResults(BaseDataSet test, string tableName, int count)
{
test.SetElapsedTime(MSSQLTimer.Elapsed);
test.SqlObtainedResult1 = test.SqlObtainedResult1.TrimNullValue();
test.ExpectedResult1 = test.ExpectedResult1.TrimNullValue();
test.Result = test.SqlObtainedResult1.Compare(test.ExpectedResult1).GetResult();
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.SqlObtainedResult1), test.SqlObtainedResult1));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.Result), test.Result));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.SqlElapsedTime), test.SqlElapsedTime));
if (!string.IsNullOrWhiteSpace(test.SqlError))
{
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.SqlError), test.SqlError));
}
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.ExecutionTime), test.ExecutionTime));
if (test.Result.Equals("Passed", StringComparison.CurrentCulture))
{
PassCount++;
}
else
{
FailCount++;
}
if (count == 1)
{
_dataManipulator.ExecuteQuery(test.InsertOverallStatusQuery(tableName));
}
_dataManipulator.ExecuteQuery(test.UpdateOverallStatusCountQuery(tableName, count, PassCount, FailCount));
}
/// <summary>
/// Update Test Results.
/// </summary>
/// <param name="test">Test Obj.</param>
/// <param name="tableName">Table name.</param>
/// <param name="count"></param>
/// <param name="isMultiResult">Is result singular</param>
internal void UpdateTestResults(BaseDataSet test, string tableName, int count, bool isMultiResult = false)
{
test.SetElapsedTime(MSSQLTimer.Elapsed);
test.SetOracleElapsedTime(OracleTimer.Elapsed);
test.SqlObtainedResult1 = test.SqlObtainedResult1?.TrimNullValue();
test.ExpectedResult1 = test.ExpectedResult1?.TrimNullValue();
test.OracleResult1 = test.OracleResult1?.TrimDecimalPoints()?.TrimNullValue();
test.OutputComparison1 = test.SqlObtainedResult1.Compare(test.OracleResult1);
test.Result = test.SqlObtainedResult1.Compare(test.ExpectedResult1).GetResult();
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.SqlObtainedResult1), test.SqlObtainedResult1));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.ExpectedResult1), test.ExpectedResult1));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.OracleResult1), test.OracleResult1));
if (isMultiResult)
{
test.SqlObtainedResult2 = test.SqlObtainedResult2?.TrimNullValue();
test.ExpectedResult2 = test.ExpectedResult2?.TrimNullValue();
test.OracleResult2 = test.OracleResult2?.TrimDecimalPoints()?.TrimNullValue();
test.OutputComparison2 = test.SqlObtainedResult2.Compare(test.OracleResult2);
test.Result = (test.Result.Equals("Passed", StringComparison.CurrentCulture) && test.SqlObtainedResult2.Compare(test.ExpectedResult2)).GetResult();
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.SqlObtainedResult2), test.SqlObtainedResult2));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.ExpectedResult2), test.ExpectedResult2));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.OracleResult2), test.OracleResult2));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.OutputComparison2), test.OutputComparison2));
}
// comparison of result with expected against obtained results from MSSQL OSS extension functions
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.Result), test.Result));
// comparison of obtained results from MSSQL OSS extension functions against results from competitive Oracle functions.
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.OutputComparison1), test.OutputComparison1));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.SqlElapsedTime), test.SqlElapsedTime));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.OracleElapsedTime), test.OracleElapsedTime));
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.OracleQuery), test.OracleQuery.EscapeQueryString()));
if (!string.IsNullOrWhiteSpace(test.SqlError))
{
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.SqlError), test.SqlError));
}
if (!string.IsNullOrWhiteSpace(test.OracleError))
{
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.OracleError), test.OracleError));
}
_dataManipulator.ExecuteQuery(test.GetTargetUpdateQuery(tableName, nameof(test.ExecutionTime), test.ExecutionTime));
//update test results
if (isMultiResult)
{
if (test.OutputComparison1 && test.OutputComparison2)
{
PassCount++;
}
else
{
FailCount++;
}
}
else
{
if (test.OutputComparison1)
{
PassCount++;
}
else
{
FailCount++;
}
}
if (count == 1)
{
_dataManipulator.ExecuteQuery(test.InsertOverallStatusQuery(tableName));
}
_dataManipulator.ExecuteQuery(test.UpdateOverallStatusCountQuery(tableName, count, PassCount, FailCount));
}
