public void Merge_Files_2_Part_Primary_Key()
{
// Arrange
TestHelper testHelper = new TestHelper();
DataItemDefinition definition = testHelper.TestDefinition(TestHelper.TestFile_PKMergeFrom); // Get the test definition of what to merge from (but also to)
DataConnection connection = testHelper.TestConnection(); // Get a test connection
DataTable baseData = testHelper.PopulateDataTable(TestHelper.TestFile_PKMergeTo); // Get the data
DataTable mergeData = testHelper.PopulateDataTable(TestHelper.TestFile_PKMergeFrom); // Get the data
Stream testStream = new MemoryStream(); // A blank stream to write data to
IDataProvider provider = new DelimitedFileProvider(); // A flat file provider to use to write the data
// Act
provider.Connect(definition, connection, testStream); // Connect to the blank stream
provider.Write(baseData, ""); // Write the data to the empty stream
provider.Write(mergeData, ""); // Write some more records with some updates and some adds
DataTable mergedData = provider.Read(""); // Get the new data set back
// Assert
Assert.True(mergedData.Rows.Count == 6); // Expect of the total of 8 rows, 2 should merge
}
public void Write_DataTypes()
{
// Arrange
TestHelper testHelper = new TestHelper();
DataConnection connection = testHelper.TestConnection(); // Get a test connection
DataItemDefinition definition = testHelper.TestDefinition(TestHelper.TestFile_WriteTests); // Get the test definition of what to write
DataTable dataToWrite = testHelper.PopulateDataTable(TestHelper.TestFile_WriteTests); // Get the data
DataTable dataToRead = null; // Table to read the data back in to (to verify it was created)
Stream testStream = new MemoryStream(); // A blank stream to write data to
IDataProvider provider = new DelimitedFileProvider(); // A flat file provider to use to write the data
// Act
provider.Connect(definition, connection, testStream); // Connect to the blank stream
provider.Write(dataToWrite, ""); // Write the data to the empty stream
dataToRead = provider.Read(""); // Get the data back
// Assert
Assert.True(dataToRead.Rows.Count != 0);
}
public void Filter_Records_With_Command()
{
// Arrange
TestHelper testHelper = new TestHelper();
DataItemDefinition definition = testHelper.TestDefinition(TestHelper.TestFile_Headers); // Get the test definition of what to data to filter
DataConnection connection = testHelper.TestConnection(); // Get a test connection
DataTable unfilteredData = testHelper.PopulateDataTable(TestHelper.TestFile_Headers); // Get the data
Stream testStream = new MemoryStream(); // A blank stream to write data to
IDataProvider provider = new DelimitedFileProvider(); // A flat file provider to use to write the data
String command = "Title = 'Title 1'"; // The command to do the filter
// Act
provider.Connect(definition, connection, testStream); // Connect to the blank stream
provider.Write(unfilteredData, ""); // Write the unfiltered data to the empty stream
DataTable filteredData = provider.Read(command); // Get the new data set back that has been filtered
// Assert
Assert.True(filteredData.Rows.Count == 1); // Expect 1 row in the filtered set
}