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