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