java/sql-dk/src/info/globalcode/sql/dk/formatting/TabularFormatter.java
author František Kučera <franta-hg@frantovo.cz>
Mon, 23 Dec 2013 16:14:03 +0100
branchv_0
changeset 40 a9db7fb3ce65
parent 39 be8db46a38c3
child 43 2813d3409afd
permissions -rw-r--r--
TabularFormatter: print colorful tables\!
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;
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    25
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    26
/**
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
 * @author Ing. František Kučera (frantovo.cz)
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    29
 */
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    30
public class TabularFormatter extends AbstractFormatter {
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    31
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    32
	public static final String NAME = "tabular";
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    33
	private static final String HEADER_TYPE_PREFIX = " (";
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    34
	private static final String HEADER_TYPE_SUFFIX = ")";
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    35
	private 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
    36
	private boolean firstResult = true;
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    37
	private int[] columnWidth;
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    38
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    39
	public TabularFormatter(FormatterContext formatterContext) {
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    40
		super(formatterContext);
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    41
		out = new ColorfulPrintWriter(formatterContext.getOutputStream());
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    42
	}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    43
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
    44
	@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
    45
	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
    46
		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
    47
		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
    48
	}
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
    49
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
    50
	@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
    51
	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
    52
		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
    53
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    54
		columnWidth = new int[header.getColumnCount()];
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    55
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    56
		printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    57
		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
    58
		for (ColumnDescriptor cd : header.getColumnDescriptors()) {
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    59
			setColumnWidth(cd.getColumnNumber(), cd.getLabel().length() + cd.getTypeName().length() + HEADER_TYPE_PREFIX.length() + HEADER_TYPE_SUFFIX.length());
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    60
			if (!cd.isFirstColumn()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    61
				printTableBorder("┬");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    62
			}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    63
			printTableBorder(repeat('─', getColumnWidth(cd.getColumnNumber()) + 2));
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    64
		}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    65
		printTableBorder("╮");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    66
		out.println();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    67
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    68
		for (ColumnDescriptor cd : header.getColumnDescriptors()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    69
			if (cd.isFirstColumn()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    70
				printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    71
				printTableBorder("│ ");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    72
			} else {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    73
				printTableBorder(" │ ");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    74
			}
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
    75
			out.print(TerminalStyle.Bright, cd.getLabel());
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    76
			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
    77
			out.print(cd.getTypeName());
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    78
			out.print(HEADER_TYPE_SUFFIX);
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    79
			if (cd.isLastColumn()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    80
				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
    81
			}
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    82
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    83
			setColumnWidth(cd.getColumnNumber(), cd.getLabel().length() + cd.getTypeName().length() + HEADER_TYPE_PREFIX.length() + HEADER_TYPE_SUFFIX.length());
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
    84
		}
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
    85
		out.println();
40
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
		printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    88
		printTableBorder("├");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    89
		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
    90
			if (i > 1) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    91
				printTableBorder("┼");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    92
			}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    93
			printTableBorder(repeat('─', getColumnWidth(i) + 2));
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    94
		}
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
		out.println();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
    97
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
    98
		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
    99
	}
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
   100
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
   101
	@Override
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   102
	public void writeColumnValue(Object value) {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   103
		super.writeColumnValue(value);
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   104
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   105
		if (isCurrentColumnFirst()) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   106
			printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   107
			printTableBorder("│ ");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   108
		} else {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   109
			printTableBorder(" │ ");
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   110
		}
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
   111
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   112
		out.print(TerminalColor.Cyan, toString(value));
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   113
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   114
		if (isCurrentColumnLast()) {
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
		}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   117
39
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   118
	}
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   119
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   120
	private int getColumnWidth(int columnNumber) {
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   121
		return columnWidth[columnNumber - 1];
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   122
	}
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   123
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   124
	private void setColumnWidth(int columnNumber, int width) {
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   125
		columnWidth[columnNumber - 1] = width;
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   126
	}
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   127
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   128
	private void updateColumnWidth(int columnNumber, int width) {
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   129
		int oldWidth = getColumnWidth(columnNumber);
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   130
		setColumnWidth(columnNumber, Math.max(width, oldWidth));
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   131
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   132
	}
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   133
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   134
	@Override
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   135
	protected String toString(Object value) {
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   136
		final int width = getColumnWidth(getCurrentColumnsCount());
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   137
		if (value instanceof Number) {
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   138
			return lpad(super.toString(value), width);
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   139
		} else {
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   140
			return rpad(super.toString(value), width);
be8db46a38c3 TabularFormatter: basic column padding
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
   141
		}
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   142
		// ?	value = (boolean) value ? "✔" : "✗";
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   143
	}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   144
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   145
	@Override
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   146
	public void writeEndRow() {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   147
		super.writeEndRow();
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   148
		out.println();
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 32
diff changeset
   149
		out.flush();
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   150
	}
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
   151
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
   152
	@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
   153
	public void writeEndResultSet() {
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   154
		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
   155
		super.writeEndResultSet();
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
		printTableIndent();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   158
		printTableBorder("╰");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   159
		for (int i = 1; i <= columnCount; i++) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   160
			if (i > 1) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   161
				printTableBorder("┴");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   162
			}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   163
			printTableBorder(repeat('─', getColumnWidth(i) + 2));
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   164
		}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   165
		printTableBorder("╯");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   166
		out.println();
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   167
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   168
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
   169
		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
   170
		out.println(getCurrentRowCount());
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   171
		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
   172
		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
   173
	}
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
   174
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
   175
	@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
   176
	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
   177
		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
   178
		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
   179
	}
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
   180
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
   181
	@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
   182
	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
   183
		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
   184
		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
   185
		out.println(updatedRowsCount);
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   186
		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
   187
		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
   188
	}
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
   189
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
   190
	@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
   191
	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
   192
		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
   193
		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
   194
	}
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
   195
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
   196
	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
   197
		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
   198
			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
   199
		} 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
   200
			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
   201
		}
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
   202
	}
40
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   203
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   204
	private void printTableBorder(String border) {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   205
		out.print(TerminalColor.Green, border);
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   206
	}
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   207
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   208
	private void printTableIndent() {
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   209
		out.print(" ");
a9db7fb3ce65 TabularFormatter: print colorful tables\!
František Kučera <franta-hg@frantovo.cz>
parents: 39
diff changeset
   210
	}
32
5e412dbd9362 TabularFormatter: basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   211
}