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 Test16()
{
var argumentStringBuilder = new QueryMultiDbArgumentStringBuilder();
argumentStringBuilder.Exporter = "csv";
argumentStringBuilder.ShowInformationMessages = false;
var query = SystemTestsHelpers.GetResource("QueryMultiDb.Tests.System.SqlResources.Test7.sql");
var systemRunOutput = SystemTestsHelpers.RunQueryMultiDbExecutionFromData(query, DatabaseFixture.TwoTargets, argumentStringBuilder);
_output.WriteLine(systemRunOutput.ToVerboseString());
SystemTestsHelpers.AssertStandardSuccessConditions(systemRunOutput);
var sheetCount = SystemTestsHelpers.AssertStandardCsvSuccessConditions(systemRunOutput);
Assert.DoesNotMatch("ERROR", systemRunOutput.StandardOutput);
Assert.Equal(4, sheetCount);
Assert.True(systemRunOutput.OutputFileContent.Length > 2000);
Assert.True(systemRunOutput.OutputFileContent.Length < 3000);
}
