public void WriteRowWithSpecialTypesSuccess()
{
// Setup:
// ... Create a request params that has three different types of value
// ... Create a set of data to write
// ... Create storage for the output
SaveResultsAsJsonRequestParams saveParams = new SaveResultsAsJsonRequestParams();
List <DbCellValue> data = new List <DbCellValue>
{
new DbCellValue {
DisplayValue = "1", RawObject = 1
},
new DbCellValue {
DisplayValue = "1.234", RawObject = 1.234
},
new DbCellValue {
DisplayValue = "2017-07-08T00:00:00", RawObject = new DateTime(2017, 07, 08)
},
};
List <DbColumnWrapper> columns = new List <DbColumnWrapper>
{
new DbColumnWrapper(new TestDbColumn("numberCol", typeof(int))),
new DbColumnWrapper(new TestDbColumn("decimalCol", typeof(decimal))),
new DbColumnWrapper(new TestDbColumn("datetimeCol", typeof(DateTime)))
};
byte[] output = new byte[8192];
// If:
// ... I write two rows
var jsonWriter = new SaveAsJsonFileStreamWriter(new MemoryStream(output), saveParams);
using (jsonWriter)
{
jsonWriter.WriteRow(data, columns);
jsonWriter.WriteRow(data, columns);
}
// Then:
// ... Upon deserialization to an array of dictionaries
string outputString = Encoding.UTF8.GetString(output).TrimEnd('\0');
Dictionary <string, string>[] outputObject =
JsonConvert.DeserializeObject <Dictionary <string, string>[]>(outputString);
// ... There should be 2 items in the array,
// ... The item should have three fields, and three values, assigned appropriately
// ... The deserialized values should match the display value
Assert.Equal(2, outputObject.Length);
foreach (var item in outputObject)
{
Assert.Equal(3, item.Count);
for (int i = 0; i < columns.Count; i++)
{
Assert.True(item.ContainsKey(columns[i].ColumnName));
Assert.Equal(data[i].RawObject == null ? null : data[i].DisplayValue, item[columns[i].ColumnName]);
}
}
}
public void WriteRowWithoutColumnSelection()
{
// Setup:
// ... Create a request params that has no selection made
// ... Create a set of data to write
// ... Create storage for the output
SaveResultsAsJsonRequestParams saveParams = new SaveResultsAsJsonRequestParams();
List <DbCellValue> data = new List <DbCellValue>
{
new DbCellValue {
DisplayValue = "item1", RawObject = "item1"
},
new DbCellValue {
DisplayValue = "null", RawObject = null
}
};
List <DbColumnWrapper> columns = new List <DbColumnWrapper>
{
new DbColumnWrapper(new TestDbColumn("column1")),
new DbColumnWrapper(new TestDbColumn("column2"))
};
byte[] output = new byte[8192];
// If:
// ... I write two rows
var jsonWriter = new SaveAsJsonFileStreamWriter(new MemoryStream(output), saveParams);
using (jsonWriter)
{
jsonWriter.WriteRow(data, columns);
jsonWriter.WriteRow(data, columns);
}
// Then:
// ... Upon deserialization to an array of dictionaries
string outputString = Encoding.UTF8.GetString(output).TrimEnd('\0');
Dictionary <string, string>[] outputObject =
JsonConvert.DeserializeObject <Dictionary <string, string>[]>(outputString);
// ... There should be 2 items in the array,
// ... The item should have two fields, and two values, assigned appropriately
Assert.Equal(2, outputObject.Length);
foreach (var item in outputObject)
{
Assert.Equal(2, item.Count);
for (int i = 0; i < columns.Count; i++)
{
Assert.True(item.ContainsKey(columns[i].ColumnName));
Assert.Equal(data[i].RawObject == null ? null : data[i].DisplayValue, item[columns[i].ColumnName]);
}
}
}
public void ArrayWrapperTest()
{
// Setup:
// ... Create storage for the output
byte[] output = new byte[8192];
SaveResultsAsJsonRequestParams saveParams = new SaveResultsAsJsonRequestParams();
// If:
// ... I create and then destruct a json writer
var jsonWriter = new SaveAsJsonFileStreamWriter(new MemoryStream(output), saveParams);
jsonWriter.Dispose();
// Then:
// ... The output should be an empty array
string outputString = Encoding.UTF8.GetString(output).TrimEnd('\0');
object[] outputArray = JsonConvert.DeserializeObject <object[]>(outputString);
Assert.Equal(0, outputArray.Length);
}
public void WriteRowWithColumnSelection()
{
// Setup:
// ... Create a request params that selects n-1 columns from the front and back
// ... Create a set of data to write
// ... Create a memory location to store the data
var saveParams = new SaveResultsAsJsonRequestParams
{
ColumnStartIndex = 1,
ColumnEndIndex = 2,
RowStartIndex = 0, // Including b/c it is required to be a "save selection"
RowEndIndex = 10
};
List <DbCellValue> data = new List <DbCellValue>
{
new DbCellValue {
DisplayValue = "item1", RawObject = "item1"
},
new DbCellValue {
DisplayValue = "item2", RawObject = "item2"
},
new DbCellValue {
DisplayValue = "null", RawObject = null
},
new DbCellValue {
DisplayValue = "null", RawObject = null
}
};
List <DbColumnWrapper> columns = new List <DbColumnWrapper>
{
new DbColumnWrapper(new TestDbColumn("column1")),
new DbColumnWrapper(new TestDbColumn("column2")),
new DbColumnWrapper(new TestDbColumn("column3")),
new DbColumnWrapper(new TestDbColumn("column4"))
};
byte[] output = new byte[8192];
// If: I write two rows
var jsonWriter = new SaveAsJsonFileStreamWriter(new MemoryStream(output), saveParams);
using (jsonWriter)
{
jsonWriter.WriteRow(data, columns);
jsonWriter.WriteRow(data, columns);
}
// Then:
// ... Upon deserialization to an array of dictionaries
string outputString = Encoding.UTF8.GetString(output).Trim('\0');
Dictionary <string, string>[] outputObject =
JsonConvert.DeserializeObject <Dictionary <string, string>[]>(outputString);
// ... There should be 2 items in the array
// ... The items should have 2 fields and values
Assert.Equal(2, outputObject.Length);
foreach (var item in outputObject)
{
Assert.Equal(2, item.Count);
for (int i = 1; i <= 2; i++)
{
Assert.True(item.ContainsKey(columns[i].ColumnName));
Assert.Equal(data[i].RawObject == null ? null : data[i].DisplayValue, item[columns[i].ColumnName]);
}
}
}
