public async Task ReadManifestAsync()
{
var setting = ManifestData.ReadManifestFileSystem(UnitTestInitializeCsv.GetTestPath("training_relation.manifest.json"));
Assert.AreEqual(false, setting.HasFieldHeader);
Assert.AreEqual(19, setting.Columns.Count());
using (var reader = new CsvFileReader(setting.CsvFile(), null))
{
await reader.OpenAsync(UnitTestInitializeCsv.Token);
Assert.AreEqual("object_id", reader.GetColumn(0).Name);
reader.Read();
}
}
public async Task ReadManifestZip()
{
var setting = ManifestData.ReadManifestZip(UnitTestInitializeCsv.GetTestPath("ces_xxx_v879548171_lo_exempt_status_reason_approver_local_full.zip"));
Assert.AreEqual(false, setting.HasFieldHeader);
Assert.AreEqual(3, setting.Columns.Count());
using (var reader = new CsvFileReader(setting.CsvFile(), null))
{
await reader.OpenAsync(UnitTestInitializeCsv.Token);
Assert.AreEqual("lesrlA_reason_id", reader.GetColumn(0).Name);
reader.Read();
Assert.AreEqual("Other", reader.GetValue(1));
}
}
public void CsvDataReaderOpenDetailSkipRows()
{
var setting = new CsvFile
{
FileName = Path.Combine(m_ApplicationDirectory, "BasicCSV.txt"),
HasFieldHeader = false,
SkipRows = 1
};
setting.FileFormat.FieldDelimiter = ",";
using (var test = new CsvFileReader(setting))
{
test.Open(true, CancellationToken.None);
Assert.AreEqual(1, test.GetColumn(0).Size);
Assert.AreEqual(7, test.GetColumn(1).Size, "LangCodeID");
Assert.AreEqual(10, test.GetColumn(2).Size, "ExamDate");
Assert.AreEqual(3, test.GetColumn(3).Size, "Score");
Assert.AreEqual(5, test.GetColumn(4).Size, "Proficiency");
Assert.AreEqual(1, test.GetColumn(5).Size, "IsNativeLang");
}
}