public async Task TestSetTypedValues() { var csvData = "A;22" + Environment.NewLine + "B;Text" + Environment.NewLine + "C;true" + Environment.NewLine + "D;01.01.2010"; var sb = new StringBuilder(); using var csvWriter = new CsvWriter(sb); var csvDictionary = new CsvDictionary(); csvDictionary.SetFormats<DateTime>("dd.MM.yyyy"); csvDictionary.SetTrueFalseString<bool>("true", "false"); csvDictionary.SetValue("A", 22); csvDictionary.SetValue("B", "Text"); csvDictionary.SetValue("C", true); csvDictionary.SetValue("D", new DateTime(2010, 1, 1)); await csvDictionary.StoreAsync(csvWriter); Assert.Equal(csvData, sb.ToString()); }
public async Task TestEntity() { var csvData = "A;22" + Environment.NewLine + "B;Text" + Environment.NewLine + "C;true" + Environment.NewLine + "D;01.01.2010" + Environment.NewLine + "e;" + Environment.NewLine + "G;A"; var sb = new StringBuilder(); using var csvWriter = new CsvWriter(sb); var csvDictionary = new CsvDictionary(); csvDictionary.SetFormats<DateTime>("dd.MM.yyyy"); csvDictionary.SetTrueFalseString<bool>("true", "false"); csvDictionary["A"] = null; csvDictionary["B"] = null; csvDictionary["C"] = null; csvDictionary["D"] = null; csvDictionary["e"] = null; csvDictionary["G"] = null; await csvDictionary.StoreAsync(csvWriter, new SampleObject() { A = 22, B = "Text", C = true, D = new DateTime(2010, 1, 1) }); Assert.Equal(csvData, sb.ToString()); using var csvReader = new CsvReader(csvData); Assert.NotNull(csvDictionary); await csvDictionary.LoadAsync(csvReader); Assert.Equal(new SampleObject() { A = 22, B = "Text", C = true, D = new DateTime(2010, 1, 1), E = "", G = SampleEnum.A }, csvDictionary.CreateAndGetValues<SampleObject>()); }
public async Task TestGetTypedValues() { var csvData = "A;22" + Environment.NewLine + "B;Text" + Environment.NewLine + "C;true" + Environment.NewLine + "D;01.01.2010" + Environment.NewLine + "E;A"; using var csvReader = new CsvReader(csvData); var csvDictionary = new CsvDictionary(); Assert.NotNull(csvDictionary); csvDictionary.SetFormats<DateTime>("dd.MM.yyyy"); await csvDictionary.LoadAsync(csvReader); Assert.Equal(22, csvDictionary.GetValue<int>("A")); Assert.Equal("Text", csvDictionary.GetValue<string>("B")); Assert.True(csvDictionary.GetValue<bool>("C")); Assert.Equal(new DateTime(2010, 1, 1), csvDictionary.GetValue<DateTime>("D")); Assert.Equal(SampleEnum.A, csvDictionary.GetValue<SampleEnum>("E")); }