optional UNION ALL: CLI option '--on-duplicate-relation' with values 'fail' and 'insert' (later more modes)
examples, shortcuts:
relpipe-tr-unionall() { relpipe-tr-sql --copy '.+' --on-duplicate-relation insert; } # does UNION ALL for all tables with same name (including already existing ones – when non-empty database is used)
relpipe-tr-unionall() { relpipe-tr-serialize | relpipe-tr-deserialize; } # does UNION ALL only for tables with same name immediately following each other (interleaved duplicates will stay unaffected)
/**
* 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 <string>
#include <vector>
namespace relpipe {
namespace tr {
namespace sql {
class SqlException {
public:
class SqlDiagnosticsRecord {
public:
std::wstring sqlState;
int sqlCode;
std::wstring message;
};
private:
std::wstring message;
std::vector<SqlDiagnosticsRecord> diagnostics;
signed short int resultCode = 0;
public:
SqlException(std::wstring message);
SqlException(std::wstring message, signed short int resultCode, signed short int handleType, void* handle, bool freeHandle = false);
std::wstring getMessage() const;
signed short int getResultCode() const;
std::vector<SqlDiagnosticsRecord> getDiagnostics() const;
};
}
}
}