public void BulkBulkEmbeddedQuote() { var sr = new StreamReader(@"CsvReader\Simple.csv"); var fr = new CsvFileReader(sr); var reader = new CsvBulkReader(fr); reader.Read(); reader.Read(); Assert.AreEqual(reader.GetValue(1), "Embedded \" Quote"); reader.Dispose(); }
public void BulkBulkEmbeddedComma() { var sr = new StreamReader(@"CsvReader\Simple.csv"); var fr = new CsvFileReader(sr); var reader = new CsvBulkReader(fr); reader.Read(); reader.Read(); Assert.AreEqual("Q;A", reader.GetValue(2)); reader.Dispose(); }
public void BulkEmptyValuesAsString() { using (var sr = new StreamReader(@"CsvReader\SomeEmptyCells.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr, emptyValue: "")) { reader.Read(); reader.Read(); Assert.AreEqual("Quotes", reader.GetValue(0)); Assert.AreEqual("", reader.GetValue(1)); Assert.AreEqual("Q;A", reader.GetValue(2)); } }
public void BulkLongLines() { using (var sr = new StreamReader(@"CsvReader\LinetooLong.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr)) { reader.Read(); Assert.AreEqual("Row1A", reader.GetValue(0)); Assert.AreEqual("Row1B", reader.GetValue(1)); Assert.AreEqual("Row1C", reader.GetValue(2)); reader.Read(); Assert.AreEqual("Row2A", reader.GetValue(0)); Assert.AreEqual("Row2B", reader.GetValue(1)); Assert.AreEqual("Row2C", reader.GetValue(2)); } }
public void BulkTwoStaticColumns() { using (var sr = new StreamReader(@"CsvReader\Simple.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr)) { reader.AddConstantColumn("Column1", "1234.5"); reader.AddConstantColumn("Column2", "Boohoo"); reader.Read(); Assert.AreEqual("1234.5", reader[3]); Assert.AreEqual("Boohoo", reader[4]); reader.Read(); Assert.AreEqual("1234.5", reader["Column1"]); Assert.AreEqual("Boohoo", reader["Column2"]); } }
public void BulkEmptyFile() { using (var sr = new StreamReader(@"CsvReader\Empty.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr)) { bool result = reader.Read(); Assert.IsFalse(result); } }
public void BulkEmptyValuesAsNull() { using (var sr = new StreamReader(@"CsvReader\SomeEmptyCells.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr)) { bool result1 = reader.Read(); Assert.IsTrue(result1); bool result2 = reader.Read(); Assert.IsTrue(result2); Assert.AreEqual("Quotes", reader.GetValue(0)); Assert.AreEqual(null, reader.GetValue(1)); Assert.AreEqual("Q;A", reader.GetValue(2)); bool result3 = reader.Read(); Assert.IsFalse(result3); } }
public void BulkBulkReadAllRows() { var sr = new StreamReader(@"CsvReader\Simple.csv"); var fr = new CsvFileReader(sr); var reader = new CsvBulkReader(fr); while (reader.Read()) { } reader.Close(); reader.Dispose(); }
public void BulkLinesTooShort() { using (var sr = new StreamReader(@"CsvReader\LinetooShort.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr)) { reader.Read(); Assert.AreEqual("Row1A", reader[0]); Assert.AreEqual("Row1B", reader[1]); Assert.AreEqual("", reader[2]); Assert.Fail("mag hier niet komen"); } }
public void BulkOnlyHeadersParse() { using (var sr = new StreamReader(@"CsvReader\OnlyHeader.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr)) { Assert.AreEqual(0, reader.GetOrdinal("Header1")); Assert.AreEqual(1, reader.GetOrdinal("Header2")); Assert.AreEqual(2, reader.GetOrdinal("Header3")); Assert.IsFalse(reader.Read(), "OnlyHeader.csv bevat alleen een header regel, geen records"); } }
public void BulkLinesTooShortByName() { using (var sr = new StreamReader(@"CsvReader\LinetooShort.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr)) { reader.Read(); Assert.AreEqual("Row1A", reader["Header1"]); Assert.AreEqual("Row1B", reader["Header2"]); // Header3 ontbreekt Assert.AreEqual("", reader["Header3"]); Assert.Fail("mag hier niet komen"); } }
public void BulkBulkCommaSeperated() { var sr = new StreamReader(@"CsvReader\Comma.csv"); var fr = new CsvFileReader(sr, fieldDelimiter: ','); var reader = new CsvBulkReader(fr); reader.Read(); Assert.AreEqual("Row1A", reader.GetValue(0)); Assert.AreEqual("Row1B", reader.GetValue(1)); Assert.AreEqual("Row1A", reader[0]); Assert.AreEqual("Row1B", reader[1]); Assert.AreEqual("Row1A", reader["Header1"]); Assert.AreEqual("Row1B", reader["header2"]); reader.Dispose(); }
public void BulkLinesTooShortWithAddedConstant() { using (var sr = new StreamReader(@"CsvReader\LinetooShort.csv")) using (var fr = new CsvFileReader(sr)) using (var reader = new CsvBulkReader(fr)) { reader.AddConstantColumn("NewColumn", "1000"); reader.Read(); Assert.AreEqual("Row1A", reader["Header1"]); Assert.AreEqual("Row1B", reader["Header2"]); //Header3 ontbreekt !!! Assert.AreEqual("1000", reader["NewColumn"]); Assert.Fail("mag hier niet komen"); } }
public void BulkBulkGetValue() { var sr = new StreamReader(@"CsvReader\Simple.csv"); var fr = new CsvFileReader(sr); var reader = new CsvBulkReader(fr); bool result1 = reader.Read(); Assert.IsTrue(result1); Assert.AreEqual("Row1A", reader.GetValue(0)); Assert.AreEqual("Row1B", reader.GetValue(1)); Assert.AreEqual("Row1A", reader[0]); Assert.AreEqual("Row1B", reader[1]); Assert.AreEqual("Row1A", reader["Header1"]); Assert.AreEqual("Row1B", reader["header2"]); reader.Dispose(); }
public void BulkBulkAddStaticValue() { var sr = new StreamReader(@"CsvReader\Simple.csv"); var fr = new CsvFileReader(sr); var reader = new CsvBulkReader(fr); reader.AddConstantColumn("Column1", "Value"); Assert.AreEqual(3, reader.GetOrdinal("Column1")); while (reader.Read()) { Assert.AreEqual("Value", reader.GetValue(reader.GetOrdinal("Column1"))); } reader.Close(); reader.Dispose(); }