public void BulkBulkSimpleOpen()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
var reader = new CsvBulkReader(fr);
reader.Dispose();
}
public void BulkBulkFieldCount()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
var reader = new CsvBulkReader(fr);
Assert.AreEqual(3, reader.FieldCount);
reader.Dispose();
}
public void BulkBulkGetOrdinalFailure()
{
using (var sr = new StreamReader(@"CsvReader\Simple.csv"))
using (var fr = new CsvFileReader(sr))
using (var reader = new CsvBulkReader(fr))
{
int i = reader.GetOrdinal("ZZZZ");
}
}
public void BulkBulkGetOrdinal()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
var reader = new CsvBulkReader(fr);
Assert.AreEqual(0, reader.GetOrdinal("Header1"));
reader.Dispose();
}
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 BulkBulkOpenAndClose()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
var reader = new CsvBulkReader(fr);
Assert.AreEqual(reader.IsClosed, false);
reader.Close();
Assert.AreEqual(reader.IsClosed, true);
reader.Dispose();
}
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 BulkBulkCaseInsensitiveColumnNames()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
var reader = new CsvBulkReader(fr);
Assert.AreEqual(0, reader.GetOrdinal("header1"));
Assert.AreEqual(1, reader.GetOrdinal("HEADER2"));
Assert.AreEqual(2, reader.GetOrdinal("HeaDER3"));
reader.Close();
reader.Dispose();
}
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 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 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 BulkMoveFileUsing()
{
using (var sr = new StreamReader(@"CsvReader\Move.csv"))
using (var fr = new CsvFileReader(sr))
using (var reader = new CsvBulkReader(fr))
{
Assert.AreEqual(reader.IsClosed, false);
reader.Close();
Assert.AreEqual(reader.IsClosed, true);
}
File.Move(@"CsvReader\Move.csv", @"CsvReader\MoveTemp.csv");
File.Move(@"CsvReader\MoveTemp.csv", @"CsvReader\Move.csv");
}
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();
}
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 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 static BasicSymbolStorage ReadCsv(Stream stream)
{
var reader = new CsvBulkReader(stream);
return(BulkImporter.Import(reader));
}
