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
73
74
75
76
77
78
79
|
namespace Cepis.Tests;
/// <summary>The CSV reader behind the batch endpoint.</summary>
public sealed class CsvTests
{
[Fact]
public void ReadsTheHeaderAndOneRecord()
{
var rows = Csv.Parse("a,b,c\n1,2,3\n");
var row = Assert.Single(rows);
Assert.Equal("1", row["a"]);
Assert.Equal("2", row["b"]);
Assert.Equal("3", row["c"]);
}
[Fact]
public void AQuotedValueMayContainACommaAndANewline()
{
var rows = Csv.Parse("a,b\n\"Praça da Sé, lado ímpar\",\"two\nlines\"\n");
var row = Assert.Single(rows);
Assert.Equal("Praça da Sé, lado ímpar", row["a"]);
Assert.Equal("two\nlines", row["b"]);
}
[Fact]
public void DoubledQuotesAreOneQuote()
{
var rows = Csv.Parse("a\n\"say \"\"hi\"\"\"\n");
Assert.Equal("say \"hi\"", Assert.Single(rows)["a"]);
}
[Theory]
[InlineData("a,b\n1,2\n")]
[InlineData("a,b\r\n1,2\r\n")]
[InlineData("a,b\r1,2\r")]
[InlineData("a,b\n1,2")]
public void EveryLineEndingWorks(string text)
{
var rows = Csv.Parse(text);
Assert.Equal("1", Assert.Single(rows)["a"]);
}
[Fact]
public void ALeadingByteOrderMarkIsDropped()
{
var rows = Csv.Parse("\uFEFFa,b\n1,2\n");
Assert.Equal("1", Assert.Single(rows)["a"]);
}
[Fact]
public void AnEmptyValueStaysEmpty()
{
var rows = Csv.Parse("a,b,c\n1,,3\n");
Assert.Equal("", Assert.Single(rows)["b"]);
}
[Fact]
public void AShortRecordIsFilledOut()
{
var rows = Csv.Parse("a,b,c\n1\n");
var row = Assert.Single(rows);
Assert.Equal("1", row["a"]);
Assert.Equal("", row["b"]);
Assert.Equal("", row["c"]);
}
[Fact]
public void AHeaderAloneYieldsNoRecords() => Assert.Empty(Csv.Parse("a,b,c\n"));
[Fact]
public void AnEmptyDocumentYieldsNoRecords() => Assert.Empty(Csv.Parse(""));
}
|