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)

remove superfluous c_str()

Added tag v0.18 for changeset 72305cea3b71

exception: fix typo: getMessge() → getMessage()

add boolean parameter to --list-data-sources + allow listing and SELECTing at the same time: bash-completion.sh

add boolean parameter to --list-data-sources + allow listing and SELECTing at the same time

fix: support bigger numbers, SQL_BIGINT there was an overflow and some values resulted into negative ones. TODO: there is still a problem with big negative numbers – this needs to be addressed in relpipe-lib-writer/relpipe-lib-reader

Added tag v0.17.1 for changeset 0b9b356fb2cf

Added tag v0.17 for changeset bb3268f87e25

Added tag v0.16 for changeset 1d17192565bf

add implicit --copy '.*' only if no CLI arguments were specified (original behavior)

support also boolean and integer data types, do not treat everything as mere strings

rename option --data-source-url to --data-source-string In some implementations like JDBC, the connection string is URL, but in ODBC the string is not formally URL, so it is better to use more general term „data source string“ instead of URL. - data source name (DSN) = name of a pre-configured database connection that should be looked-up in configuration and used - data source string (connection string) = arbitrary string containing (in certain encoding which might and might not be URL) all needed parameters (e.g. server name + port + user name + password) Name and string might sometimes be also combined: in ODBC we can e.g. connect to a string: DSN=relpipe;someParameter=foo;someOther=bar which will lookup configuration for the „relpipe“ data source and will combine it with given parameters.

transaction control: disable auto-commit, run all statements in a single transaction, do rollback on exception

faulty SQLGetDiagRec() call, unicode error, temporary workaround II

faulty SQLGetDiagRec() call, unicode error, temporary workaround

getTablePrivileges() finds columns by names instead of numbers

getDataSources() can be called multiple-times, use SQL_FETCH_FIRST and SQL_FETCH_NEXT

improved exception handling: diagnostics of URL connection error

improved exception handling: diagnostics of DSN connection error

improved exception handling: diagnostics of prepare statement error

improved exception handling

add options --data-source-name and --data-source-url for custom datasource; drop options --file and --file-keep

use ODBC, avoid direct dependency on SQLite

SqlException: ODBC diagnostics

add ODBC library and --list-data-sources mode (DSN)

SqlInputScanner for parsing SQL script and separating particular statements; does not depend on sqlite3_complete()

allow extension (module) loading SELECT load_extension('./libXXX.so');

Added tag v0.15 for changeset 629565ff82d3

keep sqlite3.h dependency in Connection.cpp and PreparedStatement.cpp only II

keep sqlite3.h dependency in Connection.cpp and PreparedStatement.cpp only

remove unused includes

move Connection class to separate .h and .cpp files

move PreparedStatement class to separate .h and .cpp files

rename DB methods to match standard API

add --type-cast to allow explicit specification of type for given output attributes

support signed integers, negative numbers; binary format change: encode numbers as SLEB128

Added tag v0.14 for changeset 0cfba89d5691

cmake: create relpipe-in-sql symlink

run whole transformation in a single transaction

implicit pass-through of all relations in the relpipe-in-sql mode (if called with no arguments)

bash-completion script

rename --keep-file to --file-keep

rename --dump to --copy + add option --copy-renamed + allow multiple copy/copy-renamed commands

process SQL input in the relpipe-in-sql mode

add --dump option: allow pass through of relation specified by a regular expression

relpipe-in-sql mode: read .sqlite file and generate relational data

improve --keep-file option: default is auto = file will be kept, if it was present before the transformation

finish writeIdentifier() method

fix license version: GNU GPLv3

Added tag v0.13 for changeset 3e076cc76c89

data types

insert records

create table for each relation

add option to create DB in a file and to keep that file

generate relational outputs

sqlite wrapper objects + execute query

configuration and CLI parser

link to the sqlite3 library

project skeleton