František Kučera <franta-hg@frantovo.cz> [Sun, 28 Aug 2022 18:03:13 +0200] rev 59
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)
František Kučera <franta-hg@frantovo.cz> [Sat, 23 Apr 2022 18:49:25 +0200] rev 58
remove superfluous c_str()
František Kučera <franta-hg@frantovo.cz> [Sat, 04 Dec 2021 21:14:54 +0100] rev 57
Added tag v0.18 for changeset 72305cea3b71
František Kučera <franta-hg@frantovo.cz> [Sat, 27 Nov 2021 23:15:18 +0100] rev 56
exception: fix typo: getMessge() → getMessage()
František Kučera <franta-hg@frantovo.cz> [Sat, 21 Aug 2021 23:13:08 +0200] rev 55
add boolean parameter to --list-data-sources + allow listing and SELECTing at the same time: bash-completion.sh
František Kučera <franta-hg@frantovo.cz> [Sun, 09 May 2021 18:19:09 +0200] rev 54
add boolean parameter to --list-data-sources + allow listing and SELECTing at the same time
František Kučera <franta-hg@frantovo.cz> [Mon, 26 Oct 2020 00:00:35 +0100] rev 53
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
František Kučera <franta-hg@frantovo.cz> [Sat, 24 Oct 2020 00:08:19 +0200] rev 52
Added tag v0.17.1 for changeset 0b9b356fb2cf
František Kučera <franta-hg@frantovo.cz> [Tue, 20 Oct 2020 23:48:53 +0200] rev 51
Added tag v0.17 for changeset bb3268f87e25
František Kučera <franta-hg@frantovo.cz> [Sat, 06 Jun 2020 01:50:45 +0200] rev 50
Added tag v0.16 for changeset 1d17192565bf
František Kučera <franta-hg@frantovo.cz> [Fri, 05 Jun 2020 18:26:27 +0200] rev 49
add implicit --copy '.*' only if no CLI arguments were specified (original behavior)
František Kučera <franta-hg@frantovo.cz> [Thu, 04 Jun 2020 13:24:17 +0200] rev 48
support also boolean and integer data types, do not treat everything as mere strings
František Kučera <franta-hg@frantovo.cz> [Thu, 04 Jun 2020 00:46:00 +0200] rev 47
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.
František Kučera <franta-hg@frantovo.cz> [Thu, 04 Jun 2020 00:03:37 +0200] rev 46
transaction control: disable auto-commit, run all statements in a single transaction, do rollback on exception
František Kučera <franta-hg@frantovo.cz> [Wed, 03 Jun 2020 17:22:22 +0200] rev 45
faulty SQLGetDiagRec() call, unicode error, temporary workaround II
František Kučera <franta-hg@frantovo.cz> [Tue, 02 Jun 2020 23:31:55 +0200] rev 44
faulty SQLGetDiagRec() call, unicode error, temporary workaround
František Kučera <franta-hg@frantovo.cz> [Tue, 02 Jun 2020 20:57:12 +0200] rev 43
getTablePrivileges() finds columns by names instead of numbers
František Kučera <franta-hg@frantovo.cz> [Tue, 02 Jun 2020 18:40:20 +0200] rev 42
getDataSources() can be called multiple-times, use SQL_FETCH_FIRST and SQL_FETCH_NEXT
František Kučera <franta-hg@frantovo.cz> [Mon, 01 Jun 2020 17:23:27 +0200] rev 41
improved exception handling: diagnostics of URL connection error
František Kučera <franta-hg@frantovo.cz> [Mon, 01 Jun 2020 17:22:13 +0200] rev 40
improved exception handling: diagnostics of DSN connection error
František Kučera <franta-hg@frantovo.cz> [Mon, 01 Jun 2020 17:14:22 +0200] rev 39
improved exception handling: diagnostics of prepare statement error
František Kučera <franta-hg@frantovo.cz> [Mon, 01 Jun 2020 00:14:40 +0200] rev 38
improved exception handling
František Kučera <franta-hg@frantovo.cz> [Sun, 31 May 2020 21:20:24 +0200] rev 37
add options --data-source-name and --data-source-url for custom datasource; drop options --file and --file-keep
František Kučera <franta-hg@frantovo.cz> [Sun, 31 May 2020 16:56:07 +0200] rev 36
use ODBC, avoid direct dependency on SQLite
František Kučera <franta-hg@frantovo.cz> [Mon, 25 May 2020 21:11:17 +0200] rev 35
SqlException: ODBC diagnostics
František Kučera <franta-hg@frantovo.cz> [Mon, 25 May 2020 19:36:06 +0200] rev 34
add ODBC library and --list-data-sources mode (DSN)
František Kučera <franta-hg@frantovo.cz> [Sat, 23 May 2020 23:58:50 +0200] rev 33
SqlInputScanner for parsing SQL script and separating particular statements; does not depend on sqlite3_complete()
František Kučera <franta-hg@frantovo.cz> [Fri, 08 May 2020 12:51:01 +0200] rev 32
allow extension (module) loading
SELECT load_extension('./libXXX.so');
František Kučera <franta-hg@frantovo.cz> [Fri, 31 Jan 2020 23:34:53 +0100] rev 31
Added tag v0.15 for changeset 629565ff82d3
František Kučera <franta-hg@frantovo.cz> [Fri, 31 Jan 2020 23:22:56 +0100] rev 30
keep sqlite3.h dependency in Connection.cpp and PreparedStatement.cpp only II