author | František Kučera <franta-hg@frantovo.cz> |
Fri, 10 Jan 2014 23:21:28 +0100 | |
branch | v_0 |
changeset 155 | eb3676c6929b |
parent 142 | da1e38386d84 |
child 169 | 4e131a0b521a |
permissions | -rw-r--r-- |
123
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
1 |
/** |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
2 |
* SQL-DK |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
3 |
* Copyright © 2014 František Kučera (frantovo.cz) |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
4 |
* |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
5 |
* This program is free software: you can redistribute it and/or modify |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
6 |
* it under the terms of the GNU General Public License as published by |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
7 |
* the Free Software Foundation, either version 3 of the License, or |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
8 |
* (at your option) any later version. |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
9 |
* |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
10 |
* This program is distributed in the hope that it will be useful, |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
11 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
12 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
13 |
* GNU General Public License for more details. |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
14 |
* |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
15 |
* You should have received a copy of the GNU General Public License |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
16 |
* along with this program. If not, see <http://www.gnu.org/licenses/>. |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
17 |
*/ |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
18 |
package info.globalcode.sql.dk.formatting; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
19 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
20 |
import info.globalcode.sql.dk.ColorfulPrintWriter.TerminalColor; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
21 |
import java.util.ArrayList; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
22 |
import java.util.List; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
23 |
import static info.globalcode.sql.dk.Functions.lpad; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
24 |
import static info.globalcode.sql.dk.Functions.rpad; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
25 |
import static info.globalcode.sql.dk.Functions.repeat; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
26 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
27 |
/** |
155 | 28 |
* Longer values are line-wrapped – the cell then contains multiple lines. Marks are added to |
29 |
* signalize forced line ends (not present in original data). |
|
123
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
30 |
* |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
31 |
* @author Ing. František Kučera (frantovo.cz) |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
32 |
*/ |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
33 |
public class TabularWrappingFormatter extends TabularFormatter { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
34 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
35 |
public static final String NAME = "tabular-wrapping"; // bash-completion:formatter |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
36 |
private List<String[]> currentRow; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
37 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
38 |
public TabularWrappingFormatter(FormatterContext formatterContext) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
39 |
super(formatterContext); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
40 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
41 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
42 |
@Override |
142
da1e38386d84
Formatters: structural change – new level „statement“ → query and parameters are no more duplicated into each result set or updates result
František Kučera <franta-hg@frantovo.cz>
parents:
123
diff
changeset
|
43 |
public void writeStartResultSet(ColumnsHeader header) { |
da1e38386d84
Formatters: structural change – new level „statement“ → query and parameters are no more duplicated into each result set or updates result
František Kučera <franta-hg@frantovo.cz>
parents:
123
diff
changeset
|
44 |
super.writeStartResultSet(header); |
123
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
45 |
currentRow = new ArrayList<>(header.getColumnCount()); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
46 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
47 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
48 |
@Override |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
49 |
protected void writeColumnValueInternal(Object value) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
50 |
boolean rightAlign = value instanceof Number || value instanceof Boolean; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
51 |
String valueString = String.valueOf(value); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
52 |
int columnWidth = getColumnWidth(getCurrentColumnsCount()) - 1; // -1 = space for new line symbol |
142
da1e38386d84
Formatters: structural change – new level „statement“ → query and parameters are no more duplicated into each result set or updates result
František Kučera <franta-hg@frantovo.cz>
parents:
123
diff
changeset
|
53 |
currentRow.add(wrapLines(valueString, columnWidth, rightAlign)); |
123
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
54 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
55 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
56 |
@Override |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
57 |
public void writeEndRow() { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
58 |
super.writeEndRow(); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
59 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
60 |
int wrappedLine = 0; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
61 |
boolean hasMoreWrappedLines; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
62 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
63 |
do { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
64 |
hasMoreWrappedLines = false; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
65 |
for (int i = 0; i < currentRow.size(); i++) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
66 |
if (i == 0) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
67 |
printTableIndent(); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
68 |
printTableBorder("│ "); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
69 |
} else { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
70 |
printTableBorder(" │ "); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
71 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
72 |
String[] columnArray = currentRow.get(i); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
73 |
if (wrappedLine < columnArray.length) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
74 |
printValueWithNewLinesReplaced(columnArray[wrappedLine]); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
75 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
76 |
if (wrappedLine < columnArray.length - 1) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
77 |
out.print(TerminalColor.Red, "↩"); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
78 |
hasMoreWrappedLines = true; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
79 |
} else { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
80 |
out.print(" "); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
81 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
82 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
83 |
} else { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
84 |
out.print(repeat(' ', getColumnWidth(i + 1))); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
85 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
86 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
87 |
if (i == (currentRow.size() - 1)) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
88 |
printTableBorder(" │"); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
89 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
90 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
91 |
out.println(); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
92 |
out.flush(); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
93 |
wrappedLine++; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
94 |
} while (hasMoreWrappedLines); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
95 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
96 |
currentRow.clear(); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
97 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
98 |
|
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
99 |
@Override |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
100 |
public void writeEndRowInternal() { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
101 |
// already done – wrapped row ends |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
102 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
103 |
|
142
da1e38386d84
Formatters: structural change – new level „statement“ → query and parameters are no more duplicated into each result set or updates result
František Kučera <franta-hg@frantovo.cz>
parents:
123
diff
changeset
|
104 |
private static String[] wrapLines(String s, int width, boolean rightAlign) { |
123
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
105 |
String[] array = new String[(s.length() - 1) / width + 1]; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
106 |
for (int i = 0; i < array.length; i++) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
107 |
if (i == array.length - 1) { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
108 |
String part = s.substring(i * width, s.length()); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
109 |
array[i] = rightAlign ? lpad(part, width) : rpad(part, width); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
110 |
} else { |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
111 |
array[i] = s.substring(i * width, (i + 1) * width); |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
112 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
113 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
114 |
return array; |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
115 |
} |
248a98c13ca4
TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
116 |
} |