public void SimpleTestTableSelect()
{
var argumentStringBuilder = new QueryMultiDbArgumentStringBuilder();
var systemRunOutput = SystemTestsHelpers.RunQueryMultiDbExecutionFromData(DatabaseFixture.TestTableSelectQuery, DatabaseFixture.OneTarget, argumentStringBuilder);
_output.WriteLine(systemRunOutput.ToVerboseString());
SystemTestsHelpers.AssertStandardSuccessConditions(systemRunOutput);
var sheetCount = SystemTestsHelpers.AssertStandardExcelSuccessConditions(systemRunOutput);
}
public void Test3()
{
var argumentStringBuilder = new QueryMultiDbArgumentStringBuilder();
var query = SystemTestsHelpers.GetResource("QueryMultiDb.Tests.System.SqlResources.Test3.sql");
var systemRunOutput = SystemTestsHelpers.RunQueryMultiDbExecutionFromData(query, DatabaseFixture.OneTarget, argumentStringBuilder);
_output.WriteLine(systemRunOutput.ToVerboseString());
SystemTestsHelpers.AssertStandardSuccessConditions(systemRunOutput);
var sheetCount = SystemTestsHelpers.AssertStandardExcelSuccessConditions(systemRunOutput);
Assert.DoesNotMatch("ERROR", systemRunOutput.StandardOutput);
Assert.Equal(3, sheetCount);
Assert.True(systemRunOutput.OutputFileContent.Length > 5000);
Assert.True(systemRunOutput.OutputFileContent.Length < 10000);
}
public void Test10()
{
var argumentStringBuilder = new QueryMultiDbArgumentStringBuilder();
var query = SystemTestsHelpers.GetResource("QueryMultiDb.Tests.System.SqlResources.Test2.sql");
var targets = SystemTestsHelpers.GetResource("QueryMultiDb.Tests.System.Targets.targets.01.json", true);
var systemRunOutput = SystemTestsHelpers.RunQueryMultiDbExecutionFromData(query, targets, argumentStringBuilder);
_output.WriteLine(systemRunOutput.ToVerboseString());
SystemTestsHelpers.AssertStandardSuccessConditions(systemRunOutput);
var sheetCount = SystemTestsHelpers.AssertStandardExcelSuccessConditions(systemRunOutput);
Assert.Matches("ERROR", systemRunOutput.StandardOutput);
Assert.Equal(5, sheetCount);
Assert.True(systemRunOutput.OutputFileContent.Length > 10000);
Assert.True(systemRunOutput.OutputFileContent.Length < 20000);
}
public void Test14()
{
var argumentStringBuilder = new QueryMultiDbArgumentStringBuilder();
argumentStringBuilder.Progress = true;
argumentStringBuilder.Overwrite = true;
var query = SystemTestsHelpers.GetResource("QueryMultiDb.Tests.System.SqlResources.Test1.sql");
argumentStringBuilder.Query = query;
argumentStringBuilder.Targets = DatabaseFixture.TwoTargets;
var systemRunOutput = SystemTestsHelpers.RunQueryMultiDbExecution(argumentStringBuilder, true);
_output.WriteLine(systemRunOutput.ToVerboseString());
SystemTestsHelpers.AssertStandardSuccessConditions(systemRunOutput);
var sheetCount = SystemTestsHelpers.AssertStandardExcelSuccessConditions(systemRunOutput);
Assert.DoesNotMatch("ERROR", systemRunOutput.StandardOutput);
Assert.Equal(6, sheetCount);
Assert.True(systemRunOutput.OutputFileContent.Length > 10000);
Assert.True(systemRunOutput.OutputFileContent.Length < 20000);
}