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 DatabaseFixture()
{
lock (ConnectionString)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = SystemTestsHelpers.GetResource("QueryMultiDb.Tests.System.SqlResources.DatabaseFixture.sql");
command.ExecuteNonQuery();
connection.Close();
}
}
}
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 Test15()
{
var argumentStringBuilder = new QueryMultiDbArgumentStringBuilder();
argumentStringBuilder.Progress = true;
argumentStringBuilder.Overwrite = false;
var query = SystemTestsHelpers.GetResource("QueryMultiDb.Tests.System.SqlResources.Test8.sql");
argumentStringBuilder.Query = query;
argumentStringBuilder.Targets = DatabaseFixture.TwoTargets;
var systemRunOutput = SystemTestsHelpers.RunQueryMultiDbExecution(argumentStringBuilder, true);
_output.WriteLine(systemRunOutput.ToVerboseString());
Assert.NotEqual(0, systemRunOutput.ExitCode);
Assert.Matches("FATAL", systemRunOutput.StandardOutput);
}
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);
}
