src/relpipe-tr-sql.cpp
author František Kučera <franta-hg@frantovo.cz>
Tue, 22 Oct 2019 16:05:36 +0200
branchv_0
changeset 13 19580b27ade2
parent 10 7da7173d84b0
child 15 0ecde5272f8e
permissions -rw-r--r--
relpipe-in-sql mode: read .sqlite file and generate relational data
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
0
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     1
/**
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     2
 * Relational pipes
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     3
 * Copyright © 2019 František Kučera (Frantovo.cz, GlobalCode.info)
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     4
 *
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     5
 * This program is free software: you can redistribute it and/or modify
c205f5d06418 project skeleton
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
10
7da7173d84b0 fix license version: GNU GPLv3
František Kučera <franta-hg@frantovo.cz>
parents: 0
diff changeset
     7
 * the Free Software Foundation, version 3.
0
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     8
 *
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     9
 * This program is distributed in the hope that it will be useful,
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    10
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    11
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    12
 * GNU General Public License for more details.
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    13
 *
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    14
 * You should have received a copy of the GNU General Public License
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    15
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    16
 */
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    17
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    18
#include <cstdio>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    19
#include <cstdlib>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    20
#include <memory>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    21
#include <functional>
13
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    22
#include <regex>
0
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    23
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    24
#include <relpipe/cli/CLI.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    25
#include <relpipe/cli/RelpipeCLIException.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    26
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    27
#include <relpipe/reader/Factory.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    28
#include <relpipe/reader/RelationalReader.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    29
#include <relpipe/reader/RelpipeReaderException.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    30
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    31
#include <relpipe/writer/RelationalWriter.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    32
#include <relpipe/writer/RelpipeWriterException.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    33
#include <relpipe/writer/Factory.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    34
#include <relpipe/writer/TypeId.h>
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    35
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    36
#include "SqlHandler.h"
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    37
#include "CLIParser.h"
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    38
#include "Configuration.h"
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    39
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    40
using namespace relpipe::cli;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    41
using namespace relpipe::reader;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    42
using namespace relpipe::tr::sql;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    43
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    44
int main(int argc, char**argv) {
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    45
	setlocale(LC_ALL, "");
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    46
	CLI::untieStdIO();
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    47
	CLI cli(argc, argv);
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    48
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    49
	int resultCode = CLI::EXIT_CODE_UNEXPECTED_ERROR;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    50
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    51
	try {
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    52
		CLIParser cliParser;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    53
		Configuration configuration = cliParser.parse(cli.arguments());
13
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    54
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    55
		if (std::regex_match(cli.programName(), std::wregex(L"^(.*/)?relpipe-in-sql$"))) {
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    56
			// relpipe-in-sql:
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    57
			std::shared_ptr<writer::RelationalWriter> writer(writer::Factory::create(std::cout));
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    58
			SqlHandler handler(writer.get(), configuration);
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    59
			handler.endOfPipe();
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    60
		} else {
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    61
			// relpipe-tr-sql:
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    62
			std::shared_ptr<reader::RelationalReader> reader(reader::Factory::create(std::cin));
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    63
			std::shared_ptr<writer::RelationalWriter> writer(writer::Factory::create(std::cout));
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    64
			SqlHandler handler(writer.get(), configuration);
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    65
			reader->addHandler(&handler);
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    66
			reader->process();
19580b27ade2 relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz>
parents: 10
diff changeset
    67
		}
0
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    68
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    69
		resultCode = CLI::EXIT_CODE_SUCCESS;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    70
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    71
	} catch (RelpipeCLIException& e) {
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    72
		fwprintf(stderr, L"Caught CLI exception: %ls\n", e.getMessge().c_str());
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    73
		fwprintf(stderr, L"Debug: Input stream: eof=%ls, lastRead=%d\n", (cin.eof() ? L"true" : L"false"), cin.gcount());
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    74
		resultCode = e.getExitCode();
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    75
	} catch (SqlException& e) {
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    76
		fwprintf(stderr, L"Caught SQL exception: %ls\n", e.getMessge().c_str());
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    77
		fwprintf(stderr, L"Debug: Input stream: eof=%ls, lastRead=%d\n", (cin.eof() ? L"true" : L"false"), cin.gcount());
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    78
		resultCode = CLI::EXIT_CODE_UNEXPECTED_ERROR;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    79
	} catch (RelpipeReaderException& e) {
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    80
		fwprintf(stderr, L"Caught Reader exception: %ls\n", e.getMessge().c_str());
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    81
		fwprintf(stderr, L"Debug: Input stream: eof=%ls, lastRead=%d\n", (cin.eof() ? L"true" : L"false"), cin.gcount());
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    82
		resultCode = CLI::EXIT_CODE_DATA_ERROR;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    83
	}
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    84
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    85
	return resultCode;
c205f5d06418 project skeleton
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    86
}