public void TestDictionaryRemoveEntries() { using (var reader = new CsvDictionaryStreamReader("test.csv", new CsvStreamOptions() { RemoveEmptyEntries = true })) { var entries = reader.AsEnumerable().ToList(); Assert.AreEqual(entries.Count(), 20); } }
public void TestRowSeperator() { var options = new CsvStreamOptions() { HeaderRowDelimiter = "\r\n", RowDelimiter = "\r\n" }; using (var reader = new CsvDictionaryStreamReader("./test2.csv", options)) { var result = reader.AsEnumerable().ToList(); Assert.AreEqual(result.Count, 39); } }
public void TestDictionaryStringParser() { using (var reader = new CsvDictionaryStreamReader(StreamHelper.GenerateStream("name,type,cost,id,date\r\nClaws,Attachment,10,\"34.5\",03/27/1987"))) { var result = reader.AsEnumerable().FirstOrDefault(); Assert.AreEqual(result["name"], "Claws"); Assert.AreEqual(result["type"], "Attachment"); Assert.AreEqual(result["cost"], "10"); Assert.AreEqual(result["id"], "34.5"); Assert.AreEqual(result["date"], "03/27/1987"); } }
public void TestFileDictionaryNoHeaders() { using (var reader = new CsvDictionaryStreamReader("./large-csv.csv", new CsvStreamOptions() { ParseHeaders = false, DataRow = 0 })) { var result = reader.AsEnumerable(x => $"v{x}").FirstOrDefault(); for (var i = 0; i < result.Count; ++i) { Assert.AreEqual(result[$"v{i}"], $"Column {i}"); } } }
public void TestDictionaryNoHeaders() { using (var reader = new CsvDictionaryStreamReader(StreamHelper.GenerateStream("Claws,Effect,10,60.05,9-5-1029"), new CsvStreamOptions() { ParseHeaders = false, DataRow = 0 })) { var result = reader.AsEnumerable(x => $"v{x}").FirstOrDefault(); Assert.AreEqual(result["v0"], "Claws"); Assert.AreEqual(result["v1"], "Effect"); Assert.AreEqual(result["v2"], "10"); Assert.AreEqual(result["v3"], "60.05"); Assert.AreEqual(result["v4"], "9-5-1029"); } }