Debian Codegraph @

sejda-sambox/src/test/java/org/sejda/impl/sambox/component/excel/DataTableUtilsTest.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.List;
26
27 import org.junit.Test;
28
29 public class DataTableUtilsTest {
30
31 @Test
32 public void mergeComplementaryColumns() {
33 DataTable dt = new DataTable(1);
34 dt.addRow("Vehicle type", "", "Brand");
35 dt.addRow("Car", "Audi", "");
36 dt.addRow("Car", "Mercedes", "");
37 dt.addRow("Truck", "Volvo", "");
38 dt.addRow("Truck", "DAF", "");
39
40 DataTable merged = DataTableUtils.mergeComplementaryColumns(dt);
41 assertThat(merged.getColumnsCount(), is(2));
42 assertThat(merged.getRowsCount(), is(5));
43 assertThat(merged.getColumn(0), is(Arrays.asList("Vehicle type", "Car", "Car", "Truck", "Truck")));
44 assertThat(merged.getColumn(1), is(Arrays.asList("Brand", "Audi", "Mercedes", "Volvo", "DAF")));
45
46 assertThat(dt.getColumnsCount(), is(3));
47 }
48
49 @Test
50 public void areComplementary() {
51 assertThat(DataTableUtils.areComplementary(
52 Arrays.asList("Header", "", " "),
53 Arrays.asList("", "Value1", "Value2")
54 ), is(true));
55
56 assertThat(DataTableUtils.areComplementary(
57 Arrays.asList("Header1", "ValueA", ""),
58 Arrays.asList("Header2", "", "Value2")
59 ), is(false));
60 }
61
62 @Test
63 public void mergeComplementaryColumnsThatNeedsMultiplePasses() {
64 DataTable dt = new DataTable(1);
65 dt.addRow("H1", " ", "H2", " ", "H4");
66 dt.addRow("A1", "B1", " ", "D1", " ");
67 dt.addRow("A2", "B2", " ", " ", "E2");
68 dt.addRow("A3");
69
70 DataTable merged = DataTableUtils.mergeComplementaryColumns(dt);
71 assertThat(merged.getColumnsCount(), is(3));
72 assertThat(merged.getColumn(0), is(Arrays.asList("H1", "A1", "A2", "A3")));
73 assertThat(merged.getColumn(1), is(Arrays.asList("H2", "B1", "B2", "")));
74 assertThat(merged.getColumn(2), is(Arrays.asList("H4", "D1", "E2", "")));
75
76 }
77
78 @Test
79 public void mergeWithAccountingBlankHeaders_scenario1() {
80 DataTable dt = new DataTable(1)
81 .addRow("H1", "H2", "H3")
82 .addRow("A1", "A2", "A3");
83
84 DataTable dt2 = new DataTable(3)
85 .addRow("H1", " ", "", "H2", "H3")
86 .addRow("C1", "CX", "CY", "C2", "C3");
87
88 List<DataTable> mergedList = DataTableUtils.mergeTablesSpanningMultiplePages(Arrays.asList(dt, dt2));
89 assertThat(mergedList.size(), is(1));
90 DataTable merged = mergedList.get(0);
91
92 assertThat(merged.toString(), is("\n" +
93 "+--------------+\n" +
94 "|H1| | |H2|H3|\n" +
95 "+--------------+\n" +
96 "|A1| | |A2|A3|\n" +
97 "+--------------+\n" +
98 "|C1|CX|CY|C2|C3|\n" +
99 "+--------------+\n"));
100
101 }
102
103 @Test
104 public void mergeWithAccountingBlankHeaders_scenario2() {
105 DataTable dt = new DataTable(1)
106 .addRow("H1", "", "H2", "H3")
107 .addRow("A1", "AX", "A2", "A3");
108
109 DataTable dt2 = new DataTable(3)
110 .addRow("H1", "H2", "", "H3")
111 .addRow("C1", "C2", "CX", "C3");
112
113 List<DataTable> mergedList = DataTableUtils.mergeTablesSpanningMultiplePages(Arrays.asList(dt, dt2));
114 assertThat(mergedList.size(), is(1));
115 DataTable merged = mergedList.get(0);
116
117 assertThat(merged.toString(), is("\n" +
118 "+--------------+\n" +
119 "|H1| |H2| |H3|\n" +
120 "+--------------+\n" +
121 "|A1|AX|A2| |A3|\n" +
122 "+--------------+\n" +
123 "|C1| |C2|CX|C3|\n" +
124 "+--------------+\n"));
125 }
126 }