relpipe/relpipe-out-sql.cpp: src/CLIParser.h@202ce847990c (annotated)

0 7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	1	/**
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	2	* Relational pipes
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	3	* Copyright © 2022 František Kučera (Frantovo.cz, GlobalCode.info)
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	4	*
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	5	* This program is free software: you can redistribute it and/or modify
7727b4d5560d new module: relpipe-out-sql 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
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	7	* the Free Software Foundation, version 3 of the License.
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	8	*
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	9	* This program is distributed in the hope that it will be useful,
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	10	* but WITHOUT ANY WARRANTY; without even the implied warranty of
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	11	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	12	* GNU General Public License for more details.
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	13	*
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	14	* You should have received a copy of the GNU General Public License
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	15	* along with this program. If not, see <http://www.gnu.org/licenses/>.
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	16	*/
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	17	#pragma once
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	18
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	19	#include <vector>
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	20	#include <iostream>
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	21
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	22	#include <relpipe/reader/typedefs.h>
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	23	#include <relpipe/cli/CLI.h>
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	24	#include <relpipe/cli/RelpipeCLIException.h>
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	25
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	26	#include "Configuration.h"
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	27
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	28	namespace relpipe {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	29	namespace out {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	30	namespace sql {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	31
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	32	class CLIParser {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	33	private:
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	34
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	35	relpipe::reader::string_t readNext(const std::vector<relpipe::reader::string_t>& arguments, int& i) {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	36	if (i < arguments.size()) return arguments[i++];
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	37	else throw relpipe::cli::RelpipeCLIException(L"Missing CLI argument" + (i > 0 ? (L" after " + arguments[i - 1]) : L""), relpipe::cli::CLI::EXIT_CODE_BAD_CLI_ARGUMENTS);
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	38	}
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	39
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	40	/**
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	41	* TODO: use a common method
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	42	*/
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	43	bool parseBoolean(const relpipe::reader::string_t& value) {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	44	if (value == L"true") return true;
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	45	else if (value == L"false") return false;
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	46	else throw relpipe::cli::RelpipeCLIException(L"Unable to parse boolean value: " + value + L" (expecting true or false)", relpipe::cli::CLI::EXIT_CODE_BAD_CLI_ARGUMENTS);
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	47	}
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	48
3 202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	49	Configuration::InsertMode parseInsertMode(const relpipe::reader::string_t& value) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	50	if (value == L"single") return Configuration::InsertMode::SINGLE;
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	51	else if (value == L"multi") return Configuration::InsertMode::MULTI;
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	52	else throw relpipe::cli::RelpipeCLIException(L"Unable to parse InsertMode value: " + value + L" (expecting single or multi)", relpipe::cli::CLI::EXIT_CODE_BAD_CLI_ARGUMENTS);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	53	}
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	54
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	55	void updateRelationName(Configuration::RelationConfiguration& currentRelation) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	56	if (currentRelation.relation.size() == 0) currentRelation.relation = L".*";
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	57	}
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	58
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	59	void addRelation(Configuration& c, Configuration::RelationConfiguration& currentRelation) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	60	if (currentRelation.relation.size()) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	61	currentRelation.relationPattern = std::wregex(currentRelation.relation);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	62	c.relationConfigurations.push_back(currentRelation);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	63	currentRelation = Configuration::RelationConfiguration();
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	64	}
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	65	}
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	66
0 7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	67	public:
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	68
3 202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	69	static const relpipe::reader::string_t OPTION_RELATION;
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	70	static const relpipe::reader::string_t OPTION_WRITE_DDL;
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	71	static const relpipe::reader::string_t OPTION_WRITE_DML;
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	72	static const relpipe::reader::string_t OPTION_WRITE_COLUMN_NAMES;
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	73	static const relpipe::reader::string_t OPTION_INSERT_MODE;
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	74	static const relpipe::reader::string_t OPTION_TYPE_CAST;
0 7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	75
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	76	Configuration parse(const std::vector<relpipe::reader::string_t>& arguments) {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	77	Configuration c;
3 202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	78	Configuration::RelationConfiguration currentRelation;
0 7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	79
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	80	for (int i = 0; i < arguments.size();) {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	81	relpipe::reader::string_t option = readNext(arguments, i);
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	82
3 202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	83	if (option == OPTION_RELATION) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	84	addRelation(c, currentRelation); // previous relation
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	85	currentRelation.relation = readNext(arguments, i);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	86	} else if (option == OPTION_WRITE_DDL) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	87	updateRelationName(currentRelation);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	88	currentRelation.writeDDL = parseBoolean(readNext(arguments, i));
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	89	} else if (option == OPTION_WRITE_DML) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	90	updateRelationName(currentRelation);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	91	currentRelation.writeDML = parseBoolean(readNext(arguments, i));
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	92	} else if (option == OPTION_WRITE_COLUMN_NAMES) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	93	updateRelationName(currentRelation);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	94	currentRelation.writeColumnNames = parseBoolean(readNext(arguments, i));
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	95	} else if (option == OPTION_INSERT_MODE) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	96	updateRelationName(currentRelation);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	97	currentRelation.insertMode = parseInsertMode(readNext(arguments, i));
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	98	} else if (option == OPTION_TYPE_CAST) {
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	99	updateRelationName(currentRelation);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	100	Configuration::TypeCastRule tcr;
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	101	tcr.attribute = std::wregex(readNext(arguments, i));
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	102	tcr.type = std::wregex(readNext(arguments, i));
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	103	tcr.sqlType = readNext(arguments, i);
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	104	currentRelation.typeCastRules.push_back(tcr);
0 7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	105	} else throw relpipe::cli::RelpipeCLIException(L"Unsupported CLI option: " + option, relpipe::cli::CLI::EXIT_CODE_BAD_CLI_ARGUMENTS);
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	106	}
3 202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	107	addRelation(c, currentRelation); // last relation
0 7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	108
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	109	return c;
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	110	}
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	111
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	112	virtual ~CLIParser() {
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	113	}
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	114	};
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	115
3 202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	116	const relpipe::common::type::StringX CLIParser::OPTION_RELATION = L"--relation";
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	117	const relpipe::common::type::StringX CLIParser::OPTION_WRITE_DDL = L"--write-ddl";
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	118	const relpipe::common::type::StringX CLIParser::OPTION_WRITE_DML = L"--write-dml";
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	119	const relpipe::common::type::StringX CLIParser::OPTION_WRITE_COLUMN_NAMES = L"--write-column-names";
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	120	const relpipe::common::type::StringX CLIParser::OPTION_INSERT_MODE = L"--insert-mode";
202ce847990c configuration: --write-ddl, --write-dml, --write-column-names, --insert-mode, --type-cast František Kučera <franta-hg@frantovo.cz> parents: 0 diff changeset	121	const relpipe::common::type::StringX CLIParser::OPTION_TYPE_CAST = L"--type-cast";
0 7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	122
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	123	}
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	124	}
7727b4d5560d new module: relpipe-out-sql František Kučera <franta-hg@frantovo.cz> parents: diff changeset	125	}

author	František Kučera <franta-hg@frantovo.cz>
	Tue, 13 Dec 2022 02:07:00 +0100
branch	v_0
changeset 3	202ce847990c
parent 0	7727b4d5560d
permissions	-rw-r--r--