public void TestSaveMulti()
{
List <TestObject> objs = new List <TestObject>()
{
new TestObject("Hello there", 123, 300.2f, TestObject.Colour.Blue),
new TestObject("This,has,commas", 42, 12.123f, TestObject.Colour.Purple),
new TestObject("Semi;colons", 40001, -75.2f, TestObject.Colour.Green),
};
using (var stream = new MemoryStream(256)) {
using (var w = new StreamWriter(stream)) {
CsvUtil.SaveObjects(objs, w);
w.Flush();
stream.Seek(0, SeekOrigin.Begin);
var r = new StreamReader(stream);
var content = r.ReadToEnd();
var expected = @"StringField,IntField,FloatField,EnumField
Hello there,123,300.2,Blue
""This,has,commas"",42,12.123,Purple
""Semi;colons"",40001,-75.2,Green";
Assert.AreEqual(expected, content);
}
}
}
public void TestLoadPropertiesAndFieldsSameName()
{
// It's ok to have newline with padding at start, should trim field names (not values)
// Include spaces in string field value to prove all content preserved
string csvData = @"StringMember, Hello World ,This is an ignored description,also ignored
EnumMember,Blue,Something Something
IntMember,1234,Comment here
FloatMember,1.5,More commenting" ;
TestPropertiesAndFieldsObject t = new TestPropertiesAndFieldsObject();
using (var ms = new MemoryStream(Encoding.UTF8.GetBytes(csvData))) {
using (var sr = new StreamReader(ms)) {
CsvUtil.LoadObject(sr, ref t);
}
}
Assert.AreEqual(" Hello World ", t.StringMember);
Assert.AreEqual(" Hello World ", t.GetStringField());
Assert.AreEqual(1234, t.IntMember);
Assert.AreEqual(1234, t.GetIntField());
Assert.That(t.FloatMember, Is.InRange(1.4999f, 1.5001f)); // float imprecision
Assert.That(t.GetFloatField(), Is.InRange(1.4999f, 1.5001f)); // float imprecision
Assert.AreEqual(TestPropertiesAndFieldsObject.Colour.Blue, t.EnumMember);
Assert.AreEqual(TestPropertiesAndFieldsObject.Colour.Blue, t.GetEnumField());
}
public void TestLoadStruct()
{
string csvData = @"s, Hello World ,This is an ignored description,also ignored
f,1234.5,Comment here" ;
TestStruct t = new TestStruct();
using (var ms = new MemoryStream(Encoding.UTF8.GetBytes(csvData))) {
using (var sr = new StreamReader(ms)) {
CsvUtil.LoadObject(sr, ref t);
}
}
Assert.AreEqual(" Hello World ", t.s);
Assert.That(t.f, Is.InRange(1234.4999f, 1234.5001f)); // float imprecision
}
public void TestSaveSingleQuoted()
{
var obj = new TestObject("Hello, there", 123, 300.2f, TestObject.Colour.Blue);
using (var stream = new MemoryStream(256)) {
using (var w = new StreamWriter(stream)) {
CsvUtil.SaveObject(obj, w);
w.Flush();
stream.Seek(0, SeekOrigin.Begin);
var r = new StreamReader(stream);
var content = r.ReadToEnd();
var expected = @"StringField,""Hello, there""
IntField,123
FloatField,300.2
EnumField,Blue";
Assert.AreEqual(expected, content);
}
}
}
public void TestLoadSingleWithHeader()
{
// Test that we can include a header line if we want
string csvData = @"#Field,#Value,#Description
StringField, Hello World ,This is an ignored description,also ignored
EnumField,Blue,Something Something
IntField,1234,Comment here
FloatField,1.5,More commenting" ;
TestObject t = new TestObject();
using (var ms = new MemoryStream(Encoding.UTF8.GetBytes(csvData))) {
using (var sr = new StreamReader(ms)) {
CsvUtil.LoadObject(sr, t);
}
}
Assert.AreEqual(" Hello World ", t.StringField);
Assert.AreEqual(1234, t.IntField);
Assert.That(t.FloatField, Is.InRange(1.4999f, 1.5001f)); // float imprecision
Assert.AreEqual(TestObject.Colour.Blue, t.EnumField);
}
public void TestLoadSingleEmbeddedCommas()
{
// It's ok to have newline with padding at start, should trim field names (not values)
// Include spaces in string field value to prove all content preserved
// Also put fields out of order
string csvData = @"StringField,""Commas, commas everywhere,abcd"",Ignored,ignored
EnumField,Purple,Something Something
IntField,-5002,Comment here
FloatField,-3.142,Pi Pi Baby" ;
TestObject t = new TestObject();
using (var ms = new MemoryStream(Encoding.UTF8.GetBytes(csvData))) {
using (var sr = new StreamReader(ms)) {
CsvUtil.LoadObject(sr, t);
}
}
Assert.AreEqual("Commas, commas everywhere,abcd", t.StringField);
Assert.AreEqual(-5002, t.IntField);
Assert.That(t.FloatField, Is.InRange(-3.142001f, -3.141999f)); // float imprecision
Assert.AreEqual(TestObject.Colour.Purple, t.EnumField);
}
public void TestLoadMulti()
{
// Header first, then N values
// #Field headers are ignored
// This time we don't want any prefixing since not trimmed
string csvData = @"StringField,FloatField,#Description,IntField,EnumField
""This,has,commas,in it"",2.34,Something ignored,35,Red
Hello World,256.25,""Notes here"",10003,Purple
Zaphod Beeblebrox,3.1,""Amazingly amazing"",000359,Green";
List <TestObject> objs;
using (var ms = new MemoryStream(Encoding.UTF8.GetBytes(csvData))) {
using (var sr = new StreamReader(ms)) {
objs = CsvUtil.LoadObjects <TestObject>(sr);
}
}
Assert.That(objs, Has.Count.EqualTo(3));
TestObject t = objs[0];
Assert.AreEqual("This,has,commas,in it", t.StringField);
Assert.AreEqual(35, t.IntField);
Assert.That(t.FloatField, Is.InRange(2.33999f, 2.340001f)); // float imprecision
Assert.AreEqual(TestObject.Colour.Red, t.EnumField);
t = objs[1];
Assert.AreEqual("Hello World", t.StringField);
Assert.AreEqual(10003, t.IntField);
Assert.That(t.FloatField, Is.InRange(256.24999f, 256.25001f)); // float imprecision
Assert.AreEqual(TestObject.Colour.Purple, t.EnumField);
t = objs[2];
Assert.AreEqual("Zaphod Beeblebrox", t.StringField);
Assert.AreEqual(359, t.IntField);
Assert.That(t.FloatField, Is.InRange(3.09999f, 3.10001f)); // float imprecision
Assert.AreEqual(TestObject.Colour.Green, t.EnumField);
}