public void BulkDisposeReader()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
var reader = new CsvBulkReader(fr);
Assert.AreEqual(reader.IsClosed, false);
reader.Close();
reader.Dispose();
reader.Dispose();
}
public void BulkBulkSimpleOpen()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
var reader = new CsvBulkReader(fr);
reader.Dispose();
}
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 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 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 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 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 BulkMoveFile()
{
var sr = new StreamReader(@"CsvReader\Move.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();
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 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();
}