Debian Codegraph @

sejda-sambox/src/test/java/org/sejda/impl/sambox/component/excel/DataTableTest.java

raw
1 /*
2 * Copyright 2018 by Eduard Weissmann ([email protected]).
3 *
4 * This file is part of the Sejda source code
5 *
6 * This program is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU Affero General Public License as
8 * published by the Free Software Foundation, either version 3 of the
9 * License, or (at your option) any later version.
10 *
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU Affero General Public License for more details.
15 *
16 * You should have received a copy of the GNU Affero General Public License
17 * along with this program. If not, see <http://www.gnu.org/licenses/>.
18 */
19 package org.sejda.impl.sambox.component.excel;
20
21 import static org.hamcrest.CoreMatchers.is;
22 import static org.hamcrest.MatcherAssert.assertThat;
23
24 import java.util.Arrays;
25 import java.util.TreeSet;
26
27 import org.junit.Test;
28
29 public class DataTableTest {
30
31 private static final DataTable dt = new DataTable(1);
32 static {
33 dt.addRow("Vehicle type", "", "Brand");
34 dt.addRow("Car", "Audi", "");
35 dt.addRow("Car", "Mercedes", "");
36 dt.addRow("Truck", "Volvo", "");
37 dt.addRow("Truck", "DAF", "");
38 }
39
40 @Test
41 public void getColumnCount() {
42 assertThat(dt.getColumnsCount(), is(3));
43 }
44
45 @Test
46 public void getColumn() {
47 assertThat(dt.getColumn(1), is(Arrays.asList("", "Audi", "Mercedes", "Volvo", "DAF")));
48 }
49
50 @Test
51 public void getRowsCount() {
52 assertThat(dt.getRowsCount(), is(5));
53 }
54
55 @Test
56 public void testToString() {
57 DataTable data = new DataTable(1);
58 data.addRow("Name", "Surname", "Age", "Sex");
59 data.addRow("John", "Doe", "14", "M");
60 data.addRow("Alexander", "Appleseed", "99", "M");
61 data.addRow("Alex", "Jones", "", "F");
62 data.addRow("Felix", "Fog");
63
64 String expected = "\n" +
65 "+---------------------------+\n" +
66 "|Name |Surname |Age|Sex|\n" +
67 "+---------------------------+\n" +
68 "|John |Doe |14 |M |\n" +
69 "+---------------------------+\n" +
70 "|Alexander|Appleseed|99 |M |\n" +
71 "+---------------------------+\n" +
72 "|Alex |Jones | |F |\n" +
73 "+---------------------------+\n" +
74 "|Felix |Fog | | |\n" +
75 "+---------------------------+\n";
76
77 assertThat(data.toString(), is(expected));
78 }
79
80 @Test
81 public void testToStringWithArabic() {
82 DataTable data = new DataTable(1);
83 data.addRow("Word one longer header", "Word two");
84 data.addRow("Hello", "Goodbye", "1");
85 data.addRow("مرحبا", "مرحبًا ABC 123", "وداعا");
86 data.addRow("مرحبا", "مرحبًا", "وداعا");
87 data.addRow("مرحبا", "", "وداعا");
88
89 // System.out.println(data.toString());
90
91 String expected =
92 "+-------------------------------------------+\n" +
93 "|Word one longer header|Word two | |\n" +
94 "+-------------------------------------------+\n" +
95 "|Hello |Goodbye |1 |\n" +
96 "+-------------------------------------------+\n" +
97 "|\u2068مرحبا \u2069|\u2068مرحبًا ABC 123\u2069|\u2068وداعا\u2069|\n" +
98 "+-------------------------------------------+\n" +
99 "|\u2068مرحبا \u2069|\u2068مرحبًا \u2069|\u2068وداعا\u2069|\n" +
100 "+-------------------------------------------+\n" +
101 "|\u2068مرحبا \u2069| |\u2068وداعا\u2069|\n" +
102 "+-------------------------------------------+";
103
104 assertThat(data.toString().trim(), is(expected.trim()));
105 }
106
107 @Test
108 public void mergeColumns() {
109 DataTable merged = dt.mergeColumns(1, 2);
110 assertThat(merged.getRowsCount(), is(5));
111 assertThat(merged.getColumnsCount(), is(2));
112 assertThat(merged.getColumn(0), is(Arrays.asList("Vehicle type", "Car", "Car", "Truck", "Truck")));
113 assertThat(merged.getColumn(1), is(Arrays.asList("Brand", "Audi", "Mercedes", "Volvo", "DAF")));
114 }
115
116 @Test
117 public void getColumnWhenUnevenRowLength() {
118 DataTable dt = new DataTable(1);
119 dt.addRow("HeadA", "HeadB", "HeadC");
120 dt.addRow("A1", "B1", "C1");
121 dt.addRow("A2", "B2");
122 dt.addRow("A3");
123 dt.addRow("A4", "B4", "C4");
124 assertThat(dt.getColumn(1), is(Arrays.asList("HeadB", "B1", "B2", "", "B4")));
125 assertThat(dt.getColumn(2), is(Arrays.asList("HeadC", "C1", "", "", "C4")));
126 }
127
128 @Test
129 public void mergeColumnsWhenUnevenRowLength() {
130 DataTable dt = new DataTable(1);
131 dt.addRow("HeadA", "HeadB", "HeadC");
132 dt.addRow("A1", "B1", "C1");
133 dt.addRow("A2", "B2");
134 dt.addRow("A3");
135 dt.addRow("A4", "B4", "C4");
136
137 DataTable merged = dt.mergeColumns(1, 2);
138 assertThat(merged.getColumn(1), is(Arrays.asList("HeadB HeadC", "B1 C1", "B2", "", "B4 C4")));
139 }
140
141 @Test
142 public void addBlankColumn() {
143 DataTable dt = new DataTable(1);
144 dt.addRow("H1", "H2", "H3");
145 dt.addRow("A1", "A2", "A3");
146
147 dt.addBlankColumn(1);
148
149 assertThat(dt.getRow(0), is(Arrays.asList("H1", "", "H2", "H3")));
150 assertThat(dt.getRow(1), is(Arrays.asList("A1", "", "A2", "A3")));
151 }
152
153 @Test
154 public void testPagesAsString() {
155 assertThat(new DataTable(1).getPagesAsString(), is("Page 1"));
156 assertThat(new DataTable(new TreeSet<>(Arrays.asList(2, 3))).getPagesAsString(), is("Pages 2, 3"));
157 assertThat(new DataTable(new TreeSet<>(Arrays.asList(1, 3, 5))).getPagesAsString(), is("Pages 1, 3, 5"));
158 assertThat(new DataTable(new TreeSet<>(Arrays.asList(2, 3, 4, 5))).getPagesAsString(), is("Pages 2-5"));
159 }
160 }