1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
// Copyright 2009-2022 Josh Close
// This file is a part of CsvHelper and is dual licensed under MS-PL and Apache 2.0.
// See LICENSE.txt for details or visit http://www.opensource.org/licenses/ms-pl.html for MS-PL and http://opensource.org/licenses/Apache-2.0 for Apache 2.0.
// https://github.com/JoshClose/CsvHelper
using System;
using System.Collections.Generic;
using System.Globalization;
using System.IO;
using System.Linq;
using Xunit;
namespace CsvHelper.Tests
{
public class LocalCultureTests
{
// In 'uk-UA' decimal separator is the ','
// For 'Invariant' and many other cultures decimal separator is '.'
[Fact]
public void ReadRecordsTest()
{
const string source = "DateTimeColumn;DecimalColumn\r\n" +
"11.11.2010;12,0\r\n";
var configuration = new CsvHelper.Configuration.CsvConfiguration(new CultureInfo("uk-UA"))
{
Delimiter = ";",
};
var reader = new CsvReader(new CsvParser(new StringReader(source), configuration));
var records = reader.GetRecords<TestRecordWithDecimal>().ToList();
Assert.Single(records);
var record = records.First();
Assert.Equal(12.0m, record.DecimalColumn);
Assert.Equal(new DateTime(2010, 11, 11), record.DateTimeColumn);
}
[Fact]
public void WriteRecordsTest()
{
var records = new List<TestRecordWithDecimal>
{
new TestRecordWithDecimal
{
DecimalColumn = 12.0m,
DateTimeColumn = new DateTime( 2003, 1, 4, 15, 9, 26 )
}
};
var writer = new StringWriter();
var culture = new CultureInfo("uk-UA");
var csv = new CsvWriter(writer, new CsvHelper.Configuration.CsvConfiguration(culture) { Delimiter = ";" });
csv.WriteRecords(records);
var csvFile = writer.ToString();
const string expected = "DecimalColumn;DateTimeColumn\r\n" +
"12,0;04.01.2003 15:09:26\r\n";
Assert.Equal(expected, csvFile);
}
private class TestRecordWithDecimal
{
public decimal DecimalColumn { get; set; }
public DateTime DateTimeColumn { get; set; }
}
}
}
|
