src/TabularPrefetchingHandler.h
author František Kučera <franta-hg@frantovo.cz>
Sun, 17 Nov 2019 17:51:13 +0100
branchv_0
changeset 26 32824e833b89
parent 24 992dde455b04
child 27 f03e1f9cfcb6
permissions -rw-r--r--
compute proper width of strings (characters might be wider than 1 column on display) Before: $ echo hello ๐Ÿญ | relpipe-in-csv wide string | relpipe-out-tabular wide: โ•ญโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ•ฎ โ”‚ string (string) โ”‚ โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ค โ”‚ hello ๐Ÿญ โ”‚ โ•ฐโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ•ฏ Record count: 1 After: $ echo hello ๐Ÿญ | relpipe-in-csv wide string | relpipe-out-tabular wide: โ•ญโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ•ฎ โ”‚ string (string) โ”‚ โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ค โ”‚ hello ๐Ÿญ โ”‚ โ•ฐโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ•ฏ Record count: 1
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
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    32
namespace relpipe {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    33
namespace out {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    34
namespace tabular {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    35
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    36
using namespace relpipe::reader;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    37
20
b9625491fbf5 fix typo: Hadler โ†’ Handler
František Kučera <franta-hg@frantovo.cz>
parents: 13
diff changeset
    38
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
    39
private:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    40
	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
    41
	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
    42
	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
    43
	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
    44
	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
    45
	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
    46
	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
    47
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    48
	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
    49
	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
    50
	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
    51
	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
    52
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    53
	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
    54
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    55
	std::ostream &output;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    56
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    57
	std::vector<TypeId> columnTypes;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    58
	std::vector<string_t> columnTypeCodes;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    59
	std::vector<string_t> columnNames;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    60
	std::vector<integer_t> columnWidths;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    61
	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
    62
	integer_t columnCount = 0;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    63
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    64
	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
    65
		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
    66
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    67
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    68
	/**
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    69
	 * 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
    70
	 * 
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    71
	 * 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
    72
	 * 
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    73
	 * @param value original value
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    74
	 * @param color value foreground color
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    75
	 * @return value with replaced whitespaces
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
	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
    78
		std::wstringstream result;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    79
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    80
		result << convertor.from_bytes(color);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    81
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    82
		for (auto & ch : value) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    83
			switch (ch) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    84
				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
    85
					break;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    86
				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
    87
					break;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    88
				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
    89
					break;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    90
				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
    91
					break;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    92
				default: result << ch;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    93
			}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    94
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    95
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    96
		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
    97
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    98
		return result.str();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    99
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   100
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
   101
	/**
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
   102
	 * @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
   103
	 * @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
   104
	 */
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
   105
	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
   106
		integer_t width = 0;
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
   107
		for (wchar_t ch : stringValue) width += std::max(0, wcwidth(ch));
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
   108
		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
   109
	}
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
   110
5
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   111
	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
   112
		const string_t bar = L"โ”€";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   113
		// TODO: support also ASCII nostalgia:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   114
		// border = border.replaceAll("โ”€", "-");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   115
		// border = border.replaceAll("โ”‚", "|");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   116
		// border = border.replaceAll("[โ•ญโ”ฌโ•ฎโ”œโ”ผโ”คโ•ฐโ”ดโ•ฏ]", "+");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   117
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   118
		output << INDENT << ESC_BORDER;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   119
		output << convertor.to_bytes(left);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   120
		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
   121
			integer_t width = columnWidths[c];
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   122
			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
   123
			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
   124
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   125
		output << convertor.to_bytes(right);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   126
		output << ESC_RESET << std::endl;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   127
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   128
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   129
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   130
	void printCachedData() {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   131
		// Compute column widths and paddings:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   132
		vector<integer_t> paddings(columnCount);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   133
		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
   134
			string_t typeCode = columnTypeCodes[i];
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   135
			string_t columnName = columnNames[i];
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   136
			integer_t minWidth = columnName.size() + typeCode.size() + 3; // 3 = " ()" in "columnName (typeCode)"
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   137
			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
   138
			paddings[i] = columnWidths[i] - minWidth;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   139
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   140
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   141
		printHorizontalLine(L"โ•ญ", L"โ”ฌ", L"โ•ฎ");
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
		// Print column headers:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   144
		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
   145
		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
   146
			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
   147
			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
   148
				output << " ";
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(columnTypeCodes[i]) << ")";
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   151
			output << ESC_BORDER << " โ”‚" << ESC_RESET;
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
		output << std::endl;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   154
		printHorizontalLine(L"โ”œ", L"โ”ผ", L"โ”ค");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   155
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   156
		// Print particular rows:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   157
		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
   158
			integer_t columnIndex = i % columnCount;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   159
			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
   160
			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
   161
			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
   162
			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
   163
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   164
			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
   165
			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
   166
			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
   167
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   168
			output << ESC_BORDER << " โ”‚" << ESC_RESET;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   169
			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
   170
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   171
		printHorizontalLine(L"โ•ฐ", L"โ”ด", L"โ•ฏ");
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   172
		integer_t recordCount = values.size() / columnCount;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   173
		output << ESC_YELLOW << "Record count: " << ESC_RESET << recordCount << std::endl;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   174
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   175
		values.clear();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   176
	}
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
public:
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   179
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   180
	TabularPrefetchingHandler(std::ostream& output) : output(output) {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   181
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   182
6
fc1e746e26a5 use AttributeMetadata instead of std::pair for relation header
František Kučera <franta-hg@frantovo.cz>
parents: 5
diff changeset
   183
	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
   184
		if (columnCount) printCachedData();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   185
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   186
		output << ESC_RED << convertor.to_bytes(name) << ":" << ESC_RESET << endl;
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   187
		columnCount = attributes.size();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   188
		columnTypes.resize(columnCount);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   189
		columnTypeCodes.resize(columnCount);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   190
		columnNames.resize(columnCount);
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   191
		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
   192
		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
   193
		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
   194
			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
   195
			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
   196
			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
   197
		}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   198
	}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   199
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   200
	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
   201
		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
   202
		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
   203
		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
   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
	void endOfPipe() {
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   207
		if (columnCount) printCachedData();
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   208
	}
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
};
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   211
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   212
}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   213
}
911ec74cce33 tabular handler, based on the prototype code
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   214
}