src/TabularPrefetchingHandler.h
author František Kučera <franta-hg@frantovo.cz>
Sun, 01 May 2022 23:21:54 +0200
branchv_0
changeset 36 3b75b9f38abc
parent 31 c22577615ce4
child 37 5dcff3c35462
permissions -rw-r--r--
replacement symbols for more whitespace characters: bell, backspace
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
9
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
     1
/**
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
     2
 * Relational pipes
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
     3
 * Copyright © 2018 František Kučera (Frantovo.cz, GlobalCode.info)
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
     4
 *
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
     5
 * This program is free software: you can redistribute it and/or modify
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
     6
 * it under the terms of the GNU General Public License as published by
24
992dde455b04 fix license version: GNU GPLv3
František Kučera <franta-hg@frantovo.cz>
parents: 20
diff changeset
     7
 * the Free Software Foundation, version 3 of the License.
9
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
     8
 *
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
     9
 * This program is distributed in the hope that it will be useful,
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
    10
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
    11
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
    12
 * GNU General Public License for more details.
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
    13
 *
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
    14
 * You should have received a copy of the GNU General Public License
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
    15
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
86d69cfbacc9 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 8
diff changeset
    16
 */
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    17
#pragma once
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    18
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    19
#include <string>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    20
#include <vector>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    21
#include <iostream>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    22
#include <sstream>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    23
#include <locale>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    24
#include <codecvt>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    25
#include <regex>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    26
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    27
#include <relpipe/reader/typedefs.h>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    28
#include <relpipe/reader/TypeId.h>
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    29
#include <relpipe/reader/handlers/RelationalReaderStringHandler.h>
6
fc1e746e26a5 use AttributeMetadata instead of std::pair for relation header
František Kučera <franta-hg@frantovo.cz>
parents: 5
diff changeset
    30
#include <relpipe/reader/handlers/AttributeMetadata.h>
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    31
30
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
    32
#include "Configuration.h"
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
    33
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    34
namespace relpipe {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    35
namespace out {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    36
namespace tabular {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    37
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    38
using namespace relpipe::reader;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    39
20
b9625491fbf5 fix typo: Hadler → Handler
František Kučera <franta-hg@frantovo.cz>
parents: 13
diff changeset
    40
class TabularPrefetchingHandler : public handlers::RelationalReaderStringHandler {
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    41
private:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    42
	std::wstring_convert<std::codecvt_utf8<wchar_t>> convertor; // TODO: support also other encodings.
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    43
	const char* ESC_BRIGHT = "\u001b[1m";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    44
	const char* ESC_RED = "\u001b[31m";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    45
	const char* ESC_GREEN = "\u001b[32m";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    46
	const char* ESC_YELLOW = "\u001b[33m";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    47
	const char* ESC_CYAN = "\u001b[36m";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    48
	const char* ESC_RESET = "\u001b[0m";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    49
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    50
	const char* ESC_HEADER = ESC_BRIGHT;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    51
	const char* ESC_BORDER = ESC_GREEN;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    52
	const char* ESC_VALUE = ESC_CYAN;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    53
	const char* ESC_REPLACEMENT = ESC_RED;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    54
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    55
	const char* INDENT = " "; // table indent from the left
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    56
30
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
    57
	std::ostream& output;
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
    58
	Configuration& configuration;
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
    59
	RelationConfiguration* currentRelationConfiguration;
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
    60
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
    61
#define getConfiguration(option) (currentRelationConfiguration ? currentRelationConfiguration->option : configuration.option)
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    62
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    63
	std::vector<TypeId> columnTypes;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    64
	std::vector<string_t> columnTypeCodes;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    65
	std::vector<string_t> columnNames;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    66
	std::vector<integer_t> columnWidths;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    67
	std::vector<string_t> values; // all values are saved here and processed at the end of the relation
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    68
	integer_t columnCount = 0;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    69
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    70
	const string_t colorizeReplacement(const string_t &replacement, const char* valueColor) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    71
		return convertor.from_bytes(ESC_RESET) + convertor.from_bytes(ESC_REPLACEMENT) + replacement + convertor.from_bytes(ESC_RESET) + convertor.from_bytes(valueColor);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    72
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    73
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    74
	/**
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    75
	 * Sanitizes whitespace that could broke table layout.
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    76
	 * 
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    77
	 * TODO: sanitize also escape sequences and emoji (resp. properly measure their width)
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    78
	 * 
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    79
	 * @param value original value
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    80
	 * @param color value foreground color
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    81
	 * @return value with replaced whitespaces
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    82
	 */
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    83
	const string_t formatValue(const string_t &value, const char* color) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    84
		std::wstringstream result;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    85
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    86
		result << convertor.from_bytes(color);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    87
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    88
		for (auto & ch : value) {
27
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    89
			// see computeWidth below
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    90
			switch (ch) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    91
				case L'\n': result << colorizeReplacement(L"↲", color);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    92
					break;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    93
				case L'\r': result << colorizeReplacement(L"⏎", color);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    94
					break;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    95
				case L'\t': result << colorizeReplacement(L"↹", color);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    96
					break;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    97
				case L' ': result << colorizeReplacement(L"⎵", color);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    98
					break;
36
3b75b9f38abc replacement symbols for more whitespace characters: bell, backspace
František Kučera <franta-hg@frantovo.cz>
parents: 31
diff changeset
    99
				case L'\a': result << colorizeReplacement(L"*", color); // 🔔 ␇
3b75b9f38abc replacement symbols for more whitespace characters: bell, backspace
František Kučera <franta-hg@frantovo.cz>
parents: 31
diff changeset
   100
					break;
3b75b9f38abc replacement symbols for more whitespace characters: bell, backspace
František Kučera <franta-hg@frantovo.cz>
parents: 31
diff changeset
   101
				case L'\b': result << colorizeReplacement(L"←", color); // ␈
3b75b9f38abc replacement symbols for more whitespace characters: bell, backspace
František Kučera <franta-hg@frantovo.cz>
parents: 31
diff changeset
   102
					break;
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   103
				default: result << ch;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   104
			}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   105
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   106
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   107
		result << convertor.from_bytes(ESC_RESET);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   108
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   109
		return result.str();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   110
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   111
26
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   112
	/**
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   113
	 * @param stringValue
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   114
	 * @return the width that would the string occupy on the display (particular characters might be wider than 1 column)
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   115
	 */
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   116
	integer_t computeWidth(const string_t& stringValue) {
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   117
		integer_t width = 0;
27
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   118
		for (wchar_t ch : stringValue) {
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   119
			// see formatValue() above
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   120
			switch (ch) {
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   121
				case L'\n':
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   122
				case L'\r':
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   123
				case L'\t':
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   124
				case L' ':
36
3b75b9f38abc replacement symbols for more whitespace characters: bell, backspace
František Kučera <franta-hg@frantovo.cz>
parents: 31
diff changeset
   125
				case L'\a':
3b75b9f38abc replacement symbols for more whitespace characters: bell, backspace
František Kučera <franta-hg@frantovo.cz>
parents: 31
diff changeset
   126
				case L'\b':
27
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   127
					width += 1;
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   128
					break;
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   129
				default:
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   130
					width += std::max(0, wcwidth(ch));
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   131
			}
f03e1f9cfcb6 compute correct width for whitespace characters that will be replaced
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
   132
		}
26
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   133
		return width;
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   134
	}
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   135
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   136
	void printHorizontalLine(const string_t &left, const string_t &middle, const string_t &right) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   137
		const string_t bar = L"─";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   138
		// TODO: support also ASCII nostalgia:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   139
		// border = border.replaceAll("─", "-");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   140
		// border = border.replaceAll("│", "|");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   141
		// border = border.replaceAll("[╭┬╮├┼┤╰┴╯]", "+");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   142
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   143
		output << INDENT << ESC_BORDER;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   144
		output << convertor.to_bytes(left);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   145
		for (size_t c = 0; c < columnCount; c++) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   146
			integer_t width = columnWidths[c];
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   147
			for (integer_t w = 0; w < (width + 2); w++) output << convertor.to_bytes(bar); // 2 = left and right padding of the value
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   148
			if (c < (columnCount - 1)) output << convertor.to_bytes(middle);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   149
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   150
		output << convertor.to_bytes(right);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   151
		output << ESC_RESET << std::endl;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   152
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   153
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   154
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   155
	void printCachedData() {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   156
		// Compute column widths and paddings:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   157
		vector<integer_t> paddings(columnCount);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   158
		for (size_t i = 0; i < columnCount; i++) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   159
			string_t typeCode = columnTypeCodes[i];
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   160
			string_t columnName = columnNames[i];
31
c22577615ce4 rename: --print-types, --print-relation-name, --print-record-count to --write-types, --write-relation-name, --write-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
   161
			integer_t minWidth = columnName.size() + (getConfiguration(writeTypes) ? typeCode.size() + 3 : 0); // 3 = " ()" in "columnName (typeCode)"
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   162
			columnWidths[i] = max(columnWidths[i], minWidth);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   163
			paddings[i] = columnWidths[i] - minWidth;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   164
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   165
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   166
		printHorizontalLine(L"╭", L"┬", L"╮");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   167
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   168
		// Print column headers:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   169
		output << INDENT << ESC_BORDER << "│" << ESC_RESET;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   170
		for (size_t i = 0; i < columnCount; i++) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   171
			output << " " << convertor.to_bytes(formatValue(columnNames[i], ESC_HEADER));
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   172
			for (integer_t p = 0; p < paddings[i]; p++) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   173
				output << " ";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   174
			}
31
c22577615ce4 rename: --print-types, --print-relation-name, --print-record-count to --write-types, --write-relation-name, --write-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
   175
			if (getConfiguration(writeTypes)) output << " (" << convertor.to_bytes(columnTypeCodes[i]) << ")";
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   176
			output << ESC_BORDER << " │" << ESC_RESET;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   177
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   178
		output << std::endl;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   179
		printHorizontalLine(L"├", L"┼", L"┤");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   180
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   181
		// Print particular rows:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   182
		for (size_t i = 0; i < values.size(); i++) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   183
			integer_t columnIndex = i % columnCount;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   184
			if (columnIndex == 0) output << INDENT << ESC_BORDER << "│" << ESC_RESET;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   185
			string_t stringValue = values[i];
26
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   186
			integer_t padding = columnWidths[columnIndex] - computeWidth(stringValue);
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   187
			boolean_t alignRight = columnTypes[columnIndex] == TypeId::BOOLEAN || columnTypes[columnIndex] == TypeId::INTEGER;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   188
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   189
			if (alignRight) for (integer_t p = 0; p < padding; p++) output << " ";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   190
			output << " " << convertor.to_bytes(formatValue(stringValue, ESC_VALUE));
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   191
			if (!alignRight) for (integer_t p = 0; p < padding; p++) output << " ";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   192
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   193
			output << ESC_BORDER << " │" << ESC_RESET;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   194
			if (columnIndex == (columnCount - 1)) output << std::endl;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   195
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   196
		printHorizontalLine(L"╰", L"┴", L"╯");
30
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   197
31
c22577615ce4 rename: --print-types, --print-relation-name, --print-record-count to --write-types, --write-relation-name, --write-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
   198
		if (getConfiguration(writeRecordCount)) {
30
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   199
			integer_t recordCount = values.size() / columnCount;
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   200
			output << ESC_YELLOW << "Record count: " << ESC_RESET << recordCount << std::endl;
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   201
		}
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   202
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   203
		values.clear();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   204
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   205
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   206
public:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   207
30
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   208
	TabularPrefetchingHandler(std::ostream& output, Configuration& configuration) : output(output), configuration(configuration) {
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   209
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   210
6
fc1e746e26a5 use AttributeMetadata instead of std::pair for relation header
František Kučera <franta-hg@frantovo.cz>
parents: 5
diff changeset
   211
	void startRelation(string_t name, std::vector<handlers::AttributeMetadata> attributes) override {
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   212
		if (columnCount) printCachedData();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   213
30
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   214
		currentRelationConfiguration = nullptr;
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   215
		for (int i = 0; i < configuration.relationConfigurations.size(); i++) {
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   216
			if (std::regex_match(name, std::wregex(configuration.relationConfigurations[i].relation))) {
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   217
				currentRelationConfiguration = &configuration.relationConfigurations[i];
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   218
				break; // it there are multiple matches, only the first configuration is used
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   219
			}
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   220
		}
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   221
31
c22577615ce4 rename: --print-types, --print-relation-name, --print-record-count to --write-types, --write-relation-name, --write-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
   222
		if (getConfiguration(writeRelationName)) output << ESC_RED << convertor.to_bytes(name) << ":" << ESC_RESET << endl;
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   223
		columnCount = attributes.size();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   224
		columnTypes.resize(columnCount);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   225
		columnTypeCodes.resize(columnCount);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   226
		columnNames.resize(columnCount);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   227
		columnWidths.resize(columnCount, 0);
13
3435efcaa8ca fix table width: reset widths to 0
František Kučera <franta-hg@frantovo.cz>
parents: 9
diff changeset
   228
		fill(columnWidths.begin(), columnWidths.end(), 0);
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   229
		for (int i = 0; i < attributes.size(); i++) {
7
2057919937fa AttributeMetadata: pImpl / d-pointer version but with memory-leak and unwanted empty constructor
František Kučera <franta-hg@frantovo.cz>
parents: 6
diff changeset
   230
			columnNames[i] = attributes[i].getAttributeName();
2057919937fa AttributeMetadata: pImpl / d-pointer version but with memory-leak and unwanted empty constructor
František Kučera <franta-hg@frantovo.cz>
parents: 6
diff changeset
   231
			columnTypes[i] = attributes[i].getTypeId();
2057919937fa AttributeMetadata: pImpl / d-pointer version but with memory-leak and unwanted empty constructor
František Kučera <franta-hg@frantovo.cz>
parents: 6
diff changeset
   232
			columnTypeCodes[i] = attributes[i].getTypeName();
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   233
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   234
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   235
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   236
	void attribute(const string_t& value) override {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   237
		integer_t i = values.size() % columnCount;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   238
		values.push_back(value);
26
32824e833b89 compute proper width of strings (characters might be wider than 1 column on display)
František Kučera <franta-hg@frantovo.cz>
parents: 24
diff changeset
   239
		columnWidths[i] = max(columnWidths[i], computeWidth(value));
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   240
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   241
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   242
	void endOfPipe() {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   243
		if (columnCount) printCachedData();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   244
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   245
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   246
};
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   247
30
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   248
#undef getConfiguration
3c6374467a82 change CLI interface: options: --relation --print-types --print-relation-name --print-record-count
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
   249
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   250
}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   251
}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   252
}