public static void CheckSampleData1(CsvRecordReader csv)
{
Assert.AreEqual(CsvReaderSampleData.SampleData1FieldCount, csv.FieldCount);
if (csv.HasHeaders)
{
var headers = csv.GetFieldHeaders();
Assert.AreEqual(0, headers.GetFieldIndex(SampleData1Header0));
Assert.AreEqual(1, headers.GetFieldIndex(SampleData1Header1));
Assert.AreEqual(2, headers.GetFieldIndex(SampleData1Header2));
Assert.AreEqual(3, headers.GetFieldIndex(SampleData1Header3));
Assert.AreEqual(4, headers.GetFieldIndex(SampleData1Header4));
Assert.AreEqual(5, headers.GetFieldIndex(SampleData1Header5));
}
Assert.AreEqual(-1, csv.CurrentRecordIndex);
int recordCount = 0;
foreach (CsvRecord record in csv)
{
CheckSampleData1(csv.HasHeaders, csv.CurrentRecordIndex, record.ToArray());
recordCount++;
}
if (csv.HasHeaders)
Assert.AreEqual(CsvReaderSampleData.SampleData1RecordCount, recordCount);
else
Assert.AreEqual(CsvReaderSampleData.SampleData1RecordCount + 1, recordCount);
}
public static void CheckSampleData1(CsvRecordReader csv)
{
Assert.AreEqual(CsvReaderSampleData.SampleData1FieldCount, csv.FieldCount);
if (csv.HasHeaders)
{
var headers = csv.GetFieldHeaders();
Assert.AreEqual(0, headers.GetFieldIndex(SampleData1Header0));
Assert.AreEqual(1, headers.GetFieldIndex(SampleData1Header1));
Assert.AreEqual(2, headers.GetFieldIndex(SampleData1Header2));
Assert.AreEqual(3, headers.GetFieldIndex(SampleData1Header3));
Assert.AreEqual(4, headers.GetFieldIndex(SampleData1Header4));
Assert.AreEqual(5, headers.GetFieldIndex(SampleData1Header5));
}
Assert.AreEqual(-1, csv.CurrentRecordIndex);
int recordCount = 0;
foreach (CsvRecord record in csv)
{
CheckSampleData1(csv.HasHeaders, csv.CurrentRecordIndex, record.ToArray());
recordCount++;
}
if (csv.HasHeaders)
{
Assert.AreEqual(CsvReaderSampleData.SampleData1RecordCount, recordCount);
}
else
{
Assert.AreEqual(CsvReaderSampleData.SampleData1RecordCount + 1, recordCount);
}
}
public void GetFieldHeadersTest_EmptyCsv()
{
using (CsvRecordReader csv = new CsvRecordReader(new StringReader("#asdf\n\n#asdf,asdf"), true))
{
var headers = csv.GetFieldHeaders();
Assert.IsNotNull(headers);
Assert.AreEqual(0, headers.Length);
}
}
public void GetFieldHeadersTest1()
{
using (CsvRecordReader csv = new CsvRecordReader(new StringReader(CsvReaderSampleData.SampleData1), false))
{
var headers = csv.GetFieldHeaders();
Assert.IsNull(headers);
Assert.IsFalse(csv.HasHeaders);
}
}
public void GetFieldHeaders_WithEmptyHeaderNames(string defaultHeaderName)
{
if (defaultHeaderName == null)
{
defaultHeaderName = "Column";
}
using (var csv = new CsvRecordReader(new StringReader(", ,,aaa,\" \",,,"), true))
{
csv.DefaultHeaderName = defaultHeaderName;
Assert.IsNull(csv.Read());
Assert.AreEqual(8, csv.FieldCount);
var headers = csv.GetFieldHeaders();
Assert.AreEqual(csv.FieldCount, headers.Length);
Assert.AreEqual("aaa", headers[3]);
foreach (var index in new int[] { 0, 1, 2, 4, 5, 6, 7 })
{
Assert.AreEqual(defaultHeaderName + index.ToString(), headers[index]);
}
}
}
public void GetFieldHeadersTest2()
{
using (CsvRecordReader csv = new CsvRecordReader(new StringReader(CsvReaderSampleData.SampleData1), true))
{
var headers = csv.GetFieldHeaders();
Assert.IsNotNull(headers);
Assert.AreEqual(CsvReaderSampleData.SampleData1RecordCount, headers.Length);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header0, headers[0]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header1, headers[1]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header2, headers[2]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header3, headers[3]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header4, headers[4]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header5, headers[5]);
Assert.AreEqual(0, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header0));
Assert.AreEqual(1, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header1));
Assert.AreEqual(2, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header2));
Assert.AreEqual(3, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header3));
Assert.AreEqual(4, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header4));
Assert.AreEqual(5, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header5));
}
}
public void GetFieldHeaders_WithEmptyHeaderNames(string defaultHeaderName)
{
if (defaultHeaderName == null)
defaultHeaderName = "Column";
using (var csv = new CsvRecordReader(new StringReader(", ,,aaa,\" \",,,"), true))
{
csv.DefaultHeaderName = defaultHeaderName;
Assert.IsNull(csv.Read());
Assert.AreEqual(8, csv.FieldCount);
var headers = csv.GetFieldHeaders();
Assert.AreEqual(csv.FieldCount, headers.Length);
Assert.AreEqual("aaa", headers[3]);
foreach (var index in new int[] { 0, 1, 2, 4, 5, 6, 7 })
Assert.AreEqual(defaultHeaderName + index.ToString(), headers[index]);
}
}
public void GetFieldHeadersTest_EmptyCsv()
{
using (CsvRecordReader csv = new CsvRecordReader(new StringReader("#asdf\n\n#asdf,asdf"), true))
{
var headers = csv.GetFieldHeaders();
Assert.IsNotNull(headers);
Assert.AreEqual(0, headers.Length);
}
}
public void GetFieldHeadersTest2()
{
using (CsvRecordReader csv = new CsvRecordReader(new StringReader(CsvReaderSampleData.SampleData1), true))
{
var headers = csv.GetFieldHeaders();
Assert.IsNotNull(headers);
Assert.AreEqual(CsvReaderSampleData.SampleData1RecordCount, headers.Length);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header0, headers[0]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header1, headers[1]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header2, headers[2]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header3, headers[3]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header4, headers[4]);
Assert.AreEqual(CsvReaderSampleData.SampleData1Header5, headers[5]);
Assert.AreEqual(0, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header0));
Assert.AreEqual(1, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header1));
Assert.AreEqual(2, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header2));
Assert.AreEqual(3, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header3));
Assert.AreEqual(4, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header4));
Assert.AreEqual(5, headers.GetFieldIndex(CsvReaderSampleData.SampleData1Header5));
}
}
public void GetFieldHeadersTest1()
{
using (CsvRecordReader csv = new CsvRecordReader(new StringReader(CsvReaderSampleData.SampleData1), false))
{
var headers = csv.GetFieldHeaders();
Assert.IsNull(headers);
Assert.IsFalse(csv.HasHeaders);
}
}