CsvEngine.cs :  » Persistence-Frameworks » FileHelpers-Library » FileHelpersTests » CommonTests » C# / CSharp Open Source

using System;
using System.Data;
using System.IO;
using FileHelpers;
using FileHelpers.RunTime;
using NUnit.Framework;

namespace FileHelpersTests.CommonTests{
  [TestFixture]
  public class CsvEngineTests
  {

    [Test]
    public void ReadFileComma()
    {
      string file = Common.TestPath(@"Good\RealCsvComma1.txt");
      string classname = "CustomerComma";
      char delimiter = ',';

      RunTest(file, delimiter, classname);
    }

    [Test]
    public void ReadFileComma2()
    {
      string file = Common.TestPath(@"Good\RealCsvComma2.txt");
      string classname = "CustomerComma";
      char delimiter = ',';
      char delimiterHdr = '|';

      RunTest(file, delimiter, delimiterHdr, classname);
    }

    [Test]
    public void ReadFileVerticalBar()
    {

      string file = Common.TestPath(@"Good\RealCsvVerticalBar1.txt");
      string classname = "CustomerVerticalBar";
      char delimiter = '|';

      RunTest(file, delimiter, classname);
    }

    [Test]
    public void ReadFileVerticalBar2()
    {
      string file = Common.TestPath(@"Good\RealCsvVerticalBar2.txt");
      string classname = "CustomerVerticalBar";
      char delimiter = '|';
      char delimiterHdr = ',';

      RunTest(file, delimiter, delimiterHdr, classname);
    }

    [Test]
    public void DualEngine()
    {
      string file = Common.TestPath(@"Good\RealCsvVerticalBar2.txt");
      string classname = "CustomerVerticalBar";
      char delimiter = '|';

      CsvEngine engine = new CsvEngine(classname, delimiter, file);
      CsvEngine engine2 = new CsvEngine(classname, delimiter, file);

    }

    private void RunTest(string file, char delimiter, string classname)
    {
      RunTest(file, delimiter, delimiter, classname);
    }

    private void RunTest(string file, char delimiter, char delimiterHdr, string classname)
    {
      CsvOptions options = new CsvOptions(classname, delimiter, file);
      options.HeaderDelimiter = delimiterHdr;
      CsvEngine engine = new CsvEngine(options);
  
      Assert.AreEqual(classname, engine.RecordType.Name);
  
      DataTable dt = engine.ReadFileAsDT(file);
  
      Assert.AreEqual(20, dt.Rows.Count);
      Assert.AreEqual(20, engine.TotalRecords);
      Assert.AreEqual(0, engine.ErrorManager.ErrorCount);

      Assert.AreEqual("CustomerID", dt.Columns[0].ColumnName);
    }

    [Test]
    [ExpectedException(typeof(FileHelpersException))]
    public void BadName()
    {
      new CsvEngine("Ops, somerrors", '|', Common.TestPath(@"Good\RealCsvVerticalBar1.txt"));
    }

    [Test]
    public void ReadWithCommon()
    {
      string file = Common.TestPath(@"Good\RealCsvComma1.txt");
      string classname = "CustomerComma";
      char delimiter = ',';

      DataTable dt = CsvEngine.CsvToDataTable(file, classname, delimiter);
      Assert.AreEqual(20, dt.Rows.Count);

      Assert.AreEqual("CustomerID", dt.Columns[0].ColumnName);
    }

  }
}