java/sql-dk/src/main/java/info/globalcode/sql/dk/formatting/TabularWrappingFormatter.java
author František Kučera <franta-hg@frantovo.cz>
Mon, 04 Mar 2019 20:15:24 +0100
branchv_0
changeset 238 4a1864c3e867
parent 219 java/sql-dk/src/info/globalcode/sql/dk/formatting/TabularWrappingFormatter.java@3b1733fb3793
child 250 aae5009bd0af
permissions -rw-r--r--
mavenized: sql-dk
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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
eb3676c6929b more JavaDoc
František Kučera <franta-hg@frantovo.cz>
parents: 142
diff changeset
    28
 * Longer values are line-wrapped – the cell then contains multiple lines. Marks are added to
eb3676c6929b more JavaDoc
František Kučera <franta-hg@frantovo.cz>
parents: 142
diff changeset
    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) {
169
4e131a0b521a Tabular: replace also TABs with colored symbol (like newlines)
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    74
					printValueWithWhitespaceReplaced(columnArray[wrappedLine]);
123
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
	}
219
3b1733fb3793 SingleRecordFormatter: escape whitespace characters in the same way as in TabularFormatter (fixed)
František Kučera <franta-hg@frantovo.cz>
parents: 169
diff changeset
   116
}