/**
* Relational pipes
* Copyright © 2019 František Kučera (Frantovo.cz, GlobalCode.info)
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, version 3.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
#pragma once
#include <relpipe/writer/AttributeMetadata.h>
#include <relpipe/writer/typedefs.h>
namespace relpipe {
namespace tr {
namespace sql {
class Parameter {
public:
relpipe::writer::string_t value;
// TODO: relpipe::writer::TypeId type;
};
class TypeCast {
public:
relpipe::writer::string_t name;
relpipe::writer::string_t type;
};
class Statement {
public:
virtual ~Statement() {
}
/**
* output relation name;
* if empty, the SQL code (DML, DDL) will be executed, but no relational output will be generated
*/
relpipe::writer::string_t relation;
/**
* SQL code, usually some SELECT;
* might be also DML or DDL
*/
relpipe::writer::string_t sql;
/**
* Explicitly defined types of particular attributes.
* SQLite uses dynamic typing, so it is often impossible to obtain the proper types from the result set.
*/
std::vector<TypeCast> typeCasts;
/**
* Query parameters
*/
std::vector<Parameter> parameters;
};
/**
* Allows copying relations from the input stream to the output stream.
* Such relations are specified by a regular expression.
* We can also specify the regex replacement string and rename such relations.
*/
class CopyRelations {
public:
CopyRelations(const relpipe::writer::string_t pattern, const relpipe::writer::string_t replacement, const relpipe::writer::boolean_t replace) : pattern(pattern), replacement(replacement), replace(replace) {
}
virtual ~CopyRelations() {
}
const relpipe::writer::string_t pattern;
const relpipe::writer::string_t replacement;
const relpipe::writer::boolean_t replace;
};
class Configuration {
public:
relpipe::writer::string_t dataSourceName;
relpipe::writer::string_t dataSourceString;
std::vector<Statement> statements;
/**
* SQL script to be executed before the relational input.
*/
std::wistream* sqlBeforeRelational = nullptr;
/**
* SQL script to be executed after the relational input.
*/
std::wistream* sqlAfterRelational = nullptr;
std::vector<CopyRelations> copyRelations;
relpipe::writer::boolean_t listDataSources = false;
virtual ~Configuration() {
}
};
}
}
}