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 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 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 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 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 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();
}
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));
}
}