java/sql-dk/src/info/globalcode/sql/dk/formatting/TabularFormatter.java
author František Kučera <franta-hg@frantovo.cz>
Fri, 03 Jan 2014 21:36:00 +0100
branchv_0
changeset 123 248a98c13ca4
parent 104 245f1b88a3e6
child 124 9277b02a3b02
permissions -rw-r--r--
TabularWrappingFormatter – first version
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     1
/**
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     2
 * SQL-DK
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     3
 * Copyright © 2013 František Kučera (frantovo.cz)
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     4
 *
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     5
 * This program is free software: you can redistribute it and/or modify
5e412dbd9362 TabularFormatter: basics
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
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     7
 * the Free Software Foundation, either version 3 of the License, or
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     8
 * (at your option) any later version.
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     9
 *
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    10
 * This program is distributed in the hope that it will be useful,
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    13
 * GNU General Public License for more details.
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    14
 *
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    15
 * You should have received a copy of the GNU General Public License
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    16
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    17
 */
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    18
package info.globalcode.sql.dk.formatting;
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    19
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    20
import info.globalcode.sql.dk.ColorfulPrintWriter;
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    21
import static info.globalcode.sql.dk.ColorfulPrintWriter.*;
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    22
import static info.globalcode.sql.dk.Functions.lpad;
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    23
import static info.globalcode.sql.dk.Functions.rpad;
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    24
import static info.globalcode.sql.dk.Functions.repeat;
88
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    25
import java.util.List;
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    26
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    27
/**
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    28
 *
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    29
 * @author Ing. František Kučera (frantovo.cz)
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    30
 */
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    31
public class TabularFormatter extends AbstractFormatter {
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    32
79
e19a13ed19a9 more bash completion tags
František Kučera <franta-hg@frantovo.cz>
parents: 76
diff changeset
    33
	public static final String NAME = "tabular"; // bash-completion:formatter
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    34
	private static final String HEADER_TYPE_PREFIX = " (";
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    35
	private static final String HEADER_TYPE_SUFFIX = ")";
104
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 103
diff changeset
    36
	public static final String PROPERTY_ASCII = "ascii";
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 103
diff changeset
    37
	public static final String PROPERTY_COLORFUL = "color";
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 103
diff changeset
    38
	public static final String PROPERTY_TRIM = "trim";
123
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
    39
	protected ColorfulPrintWriter out;
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    40
	private boolean firstResult = true;
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    41
	private int[] columnWidth;
87
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
    42
	/**
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
    43
	 * use ASCII borders instead of unicode ones
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
    44
	 */
104
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 103
diff changeset
    45
	private final boolean asciiNostalgia;
87
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
    46
	/**
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
    47
	 * Trim values if they are longer than cell size
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
    48
	 */
104
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 103
diff changeset
    49
	private final boolean trimValues;
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    50
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    51
	public TabularFormatter(FormatterContext formatterContext) {
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    52
		super(formatterContext);
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    53
		out = new ColorfulPrintWriter(formatterContext.getOutputStream());
104
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 103
diff changeset
    54
		asciiNostalgia = formatterContext.getProperties().getBoolean(PROPERTY_ASCII, false);
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 103
diff changeset
    55
		trimValues = formatterContext.getProperties().getBoolean(PROPERTY_TRIM, false);
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 103
diff changeset
    56
		out.setColorful(formatterContext.getProperties().getBoolean(PROPERTY_COLORFUL, true));
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    57
	}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    58
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    59
	@Override
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    60
	public void writeStartResultSet() {
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    61
		super.writeStartResultSet();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    62
		printResultSeparator();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    63
	}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    64
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    65
	@Override
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    66
	public void writeColumnsHeader(ColumnsHeader header) {
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    67
		super.writeColumnsHeader(header);
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    68
88
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    69
		initColumnWidths(header.getColumnCount());
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    70
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    71
		printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    72
		printTableBorder("╭");
88
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    73
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    74
		List<ColumnDescriptor> columnDescriptors = header.getColumnDescriptors();
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    75
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    76
		for (ColumnDescriptor cd : columnDescriptors) {
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    77
			// padding: make header cell at least same width as data cells in this column
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    78
			int typeWidth = cd.getTypeName().length() + HEADER_TYPE_PREFIX.length() + HEADER_TYPE_SUFFIX.length();
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    79
			cd.setLabel(rpad(cd.getLabel(), getColumnWidth(cd.getColumnNumber()) - typeWidth));
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    80
			updateColumnWidth(cd.getColumnNumber(), cd.getLabel().length() + typeWidth);
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    81
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    82
			if (!cd.isFirstColumn()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    83
				printTableBorder("┬");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    84
			}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    85
			printTableBorder(repeat('─', getColumnWidth(cd.getColumnNumber()) + 2));
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    86
		}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    87
		printTableBorder("╮");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    88
		out.println();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    89
88
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
    90
		for (ColumnDescriptor cd : columnDescriptors) {
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    91
			if (cd.isFirstColumn()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    92
				printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    93
				printTableBorder("│ ");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    94
			} else {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    95
				printTableBorder(" │ ");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    96
			}
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    97
			out.print(TerminalStyle.Bright, cd.getLabel());
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    98
			out.print(HEADER_TYPE_PREFIX);
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
    99
			out.print(cd.getTypeName());
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   100
			out.print(HEADER_TYPE_SUFFIX);
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   101
			if (cd.isLastColumn()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   102
				printTableBorder(" │");
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   103
			}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   104
		}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   105
		out.println();
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   106
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   107
		printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   108
		printTableBorder("├");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   109
		for (int i = 1; i <= header.getColumnCount(); i++) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   110
			if (i > 1) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   111
				printTableBorder("┼");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   112
			}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   113
			printTableBorder(repeat('─', getColumnWidth(i) + 2));
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   114
		}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   115
		printTableBorder("┤");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   116
		out.println();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   117
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   118
		out.flush();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   119
	}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   120
88
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   121
	/**
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   122
	 * Must be called before
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   123
	 * {@linkplain #updateColumnWidth(int, int)}
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   124
	 * and {@linkplain #getColumnWidth(int)}
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   125
	 * for each result set.
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   126
	 *
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   127
	 * @param columnCount number of columns in current result set
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   128
	 */
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   129
	protected void initColumnWidths(int columnCount) {
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   130
		if (columnWidth == null) {
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   131
			columnWidth = new int[columnCount];
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   132
		}
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   133
	}
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   134
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   135
	protected void cleanColumnWidths() {
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   136
		columnWidth = null;
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   137
	}
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   138
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   139
	@Override
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   140
	public void writeColumnValue(Object value) {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   141
		super.writeColumnValue(value);
123
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   142
		writeColumnValueInternal(value);
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   143
	}
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   144
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   145
	protected void writeColumnValueInternal(Object value) {
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   146
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   147
		if (isCurrentColumnFirst()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   148
			printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   149
			printTableBorder("│ ");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   150
		} else {
90
ce2b7576ab67 TabularFormatter: no nonbreakable spaces in table cell padding
František Kučera <franta-hg@frantovo.cz>
parents: 89
diff changeset
   151
			printTableBorder(" │ ");
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   152
		}
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   153
123
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   154
		String valueString = toString(value);
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   155
		printValueWithNewLinesReplaced(valueString);
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   156
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   157
		if (isCurrentColumnLast()) {
90
ce2b7576ab67 TabularFormatter: no nonbreakable spaces in table cell padding
František Kučera <franta-hg@frantovo.cz>
parents: 89
diff changeset
   158
			printTableBorder(" │");
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   159
		}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   160
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   161
	}
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   162
123
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   163
	protected int getColumnWidth(int columnNumber) {
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   164
		return columnWidth[columnNumber - 1];
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   165
	}
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   166
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   167
	private void setColumnWidth(int columnNumber, int width) {
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   168
		columnWidth[columnNumber - 1] = width;
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   169
	}
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   170
88
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   171
	protected void updateColumnWidth(int columnNumber, int width) {
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   172
		int oldWidth = getColumnWidth(columnNumber);
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   173
		setColumnWidth(columnNumber, Math.max(width, oldWidth));
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   174
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   175
	}
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   176
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   177
	protected String toString(Object value) {
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   178
		final int width = getColumnWidth(getCurrentColumnsCount());
87
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
   179
		String result;
43
2813d3409afd TabularFormatter: also booleans will be aligned to the right
František Kučera <franta-hg@frantovo.cz>
parents: 40
diff changeset
   180
		if (value instanceof Number || value instanceof Boolean) {
98
4d420f8b3320 Value formatting: Object → String conversion is job for particular formatter
František Kučera <franta-hg@frantovo.cz>
parents: 90
diff changeset
   181
			result = lpad(String.valueOf(value), width);
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   182
		} else {
98
4d420f8b3320 Value formatting: Object → String conversion is job for particular formatter
František Kučera <franta-hg@frantovo.cz>
parents: 90
diff changeset
   183
			result = rpad(String.valueOf(value), width);
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   184
		}
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   185
		// ?	value = (boolean) value ? "✔" : "✗";
87
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
   186
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
   187
		if (trimValues && result.length() > width) {
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
   188
			result = result.substring(0, width - 1) + "…";
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
   189
		}
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
   190
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
   191
		return result;
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   192
	}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   193
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   194
	@Override
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   195
	public void writeEndRow() {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   196
		super.writeEndRow();
123
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   197
		writeEndRowInternal();
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   198
	}
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   199
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   200
	public void writeEndRowInternal() {
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   201
		out.println();
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   202
		out.flush();
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   203
	}
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   204
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   205
	@Override
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   206
	public void writeEndResultSet() {
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   207
		int columnCount = getCurrentColumnsHeader().getColumnCount();
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   208
		super.writeEndResultSet();
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   209
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   210
		printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   211
		printTableBorder("╰");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   212
		for (int i = 1; i <= columnCount; i++) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   213
			if (i > 1) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   214
				printTableBorder("┴");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   215
			}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   216
			printTableBorder(repeat('─', getColumnWidth(i) + 2));
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   217
		}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   218
		printTableBorder("╯");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   219
		out.println();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   220
88
102ba0fcb07f TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell
František Kučera <franta-hg@frantovo.cz>
parents: 87
diff changeset
   221
		cleanColumnWidths();
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   222
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   223
		out.print(TerminalColor.Yellow, "Record count: ");
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   224
		out.println(getCurrentRowCount());
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   225
		out.bell();
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   226
		out.flush();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   227
	}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   228
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   229
	@Override
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   230
	public void writeStartUpdatesResult() {
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   231
		super.writeStartUpdatesResult();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   232
		printResultSeparator();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   233
	}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   234
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   235
	@Override
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   236
	public void writeUpdatedRowsCount(int updatedRowsCount) {
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   237
		super.writeUpdatedRowsCount(updatedRowsCount);
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   238
		out.print(TerminalColor.Red, "Updated records: ");
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   239
		out.println(updatedRowsCount);
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   240
		out.bell();
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   241
		out.flush();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   242
	}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   243
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   244
	@Override
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   245
	public void writeEndDatabase() {
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   246
		super.writeEndDatabase();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   247
		out.flush();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   248
	}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   249
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   250
	private void printResultSeparator() {
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   251
		if (firstResult) {
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   252
			firstResult = false;
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   253
		} else {
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   254
			out.println();
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   255
		}
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 34
diff changeset
   256
	}
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   257
123
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   258
	protected void printTableBorder(String border) {
76
fe23cea7542f support for ACSII-nostalgia tables
František Kučera <franta-hg@frantovo.cz>
parents: 43
diff changeset
   259
		if (asciiNostalgia) {
fe23cea7542f support for ACSII-nostalgia tables
František Kučera <franta-hg@frantovo.cz>
parents: 43
diff changeset
   260
			border = border.replaceAll("─", "-");
fe23cea7542f support for ACSII-nostalgia tables
František Kučera <franta-hg@frantovo.cz>
parents: 43
diff changeset
   261
			border = border.replaceAll("│", "|");
fe23cea7542f support for ACSII-nostalgia tables
František Kučera <franta-hg@frantovo.cz>
parents: 43
diff changeset
   262
			border = border.replaceAll("[╭┬╮├┼┤╰┴╯]", "+");
fe23cea7542f support for ACSII-nostalgia tables
František Kučera <franta-hg@frantovo.cz>
parents: 43
diff changeset
   263
		}
87
03bf24449c7a TabularFormatter: support for value trim (if longer than cell size)
František Kučera <franta-hg@frantovo.cz>
parents: 79
diff changeset
   264
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   265
		out.print(TerminalColor.Green, border);
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   266
	}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   267
123
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   268
	protected void printTableIndent() {
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   269
		out.print(" ");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   270
	}
123
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   271
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   272
	protected void printValueWithNewLinesReplaced(String valueString) {
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   273
		String[] valueParts = valueString.split("\n");
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   274
		for (int i = 0; i < valueParts.length; i++) {
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   275
			String valuePart = valueParts[i];
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   276
			out.print(TerminalColor.Cyan, valuePart);
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   277
			if (i < valueParts.length - 1) {
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   278
				out.print(TerminalColor.Red, "↲");
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   279
			}
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   280
		}
248a98c13ca4 TabularWrappingFormatter – first version
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   281
	}
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   282
}