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
František Kučera <franta-hg@frantovo.cz> [Wed, 25 Dec 2019 01:37:05 +0100] rev 29
keep sqlite3.h dependency in Connection.cpp and PreparedStatement.cpp only
František Kučera <franta-hg@frantovo.cz> [Wed, 25 Dec 2019 01:26:02 +0100] rev 28
remove unused includes
František Kučera <franta-hg@frantovo.cz> [Wed, 25 Dec 2019 01:07:41 +0100] rev 27
move Connection class to separate .h and .cpp files
František Kučera <franta-hg@frantovo.cz> [Wed, 25 Dec 2019 00:57:26 +0100] rev 26
move PreparedStatement class to separate .h and .cpp files
František Kučera <franta-hg@frantovo.cz> [Tue, 24 Dec 2019 17:36:57 +0100] rev 25
rename DB methods to match standard API
František Kučera <franta-hg@frantovo.cz> [Sat, 14 Dec 2019 14:00:36 +0100] rev 24
add --type-cast to allow explicit specification of type for given output attributes
František Kučera <franta-hg@frantovo.cz> [Fri, 13 Dec 2019 22:19:41 +0100] rev 23
support signed integers, negative numbers; binary format change: encode numbers as SLEB128
František Kučera <franta-hg@frantovo.cz> [Wed, 30 Oct 2019 17:56:45 +0100] rev 22
Added tag v0.14 for changeset 0cfba89d5691
František Kučera <franta-hg@frantovo.cz> [Wed, 30 Oct 2019 16:46:13 +0100] rev 21
cmake: create relpipe-in-sql symlink
František Kučera <franta-hg@frantovo.cz> [Tue, 29 Oct 2019 19:46:08 +0100] rev 20
run whole transformation in a single transaction
František Kučera <franta-hg@frantovo.cz> [Tue, 29 Oct 2019 00:23:56 +0100] rev 19
implicit pass-through of all relations in the relpipe-in-sql mode (if called with no arguments)
František Kučera <franta-hg@frantovo.cz> [Sat, 26 Oct 2019 22:32:36 +0200] rev 18
bash-completion script
František Kučera <franta-hg@frantovo.cz> [Sat, 26 Oct 2019 20:55:10 +0200] rev 17
rename --keep-file to --file-keep
František Kučera <franta-hg@frantovo.cz> [Sat, 26 Oct 2019 19:28:39 +0200] rev 16
rename --dump to --copy + add option --copy-renamed + allow multiple copy/copy-renamed commands
František Kučera <franta-hg@frantovo.cz> [Sat, 26 Oct 2019 17:45:37 +0200] rev 15
process SQL input in the relpipe-in-sql mode
František Kučera <franta-hg@frantovo.cz> [Fri, 25 Oct 2019 12:33:00 +0200] rev 14
add --dump option: allow pass through of relation specified by a regular expression
František Kučera <franta-hg@frantovo.cz> [Tue, 22 Oct 2019 16:05:36 +0200] rev 13
relpipe-in-sql mode: read .sqlite file and generate relational data
František Kučera <franta-hg@frantovo.cz> [Tue, 22 Oct 2019 16:04:56 +0200] rev 12
improve --keep-file option: default is auto = file will be kept, if it was present before the transformation
František Kučera <franta-hg@frantovo.cz> [Tue, 22 Oct 2019 16:04:23 +0200] rev 11
finish writeIdentifier() method
František Kučera <franta-hg@frantovo.cz> [Tue, 22 Oct 2019 16:02:57 +0200] rev 10
fix license version: GNU GPLv3
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Jul 2019 23:56:32 +0200] rev 9
Added tag v0.13 for changeset 3e076cc76c89
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Jul 2019 23:52:20 +0200] rev 8
data types
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Jul 2019 23:04:33 +0200] rev 7
insert records
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Jul 2019 18:40:35 +0200] rev 6
create table for each relation
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Jul 2019 17:06:41 +0200] rev 5
add option to create DB in a file and to keep that file
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Jul 2019 15:51:35 +0200] rev 4
generate relational outputs
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Jul 2019 14:01:21 +0200] rev 3
sqlite wrapper objects + execute query
František Kučera <franta-hg@frantovo.cz> [Mon, 29 Jul 2019 19:49:12 +0200] rev 2
configuration and CLI parser
František Kučera <franta-hg@frantovo.cz> [Sat, 27 Jul 2019 23:51:14 +0200] rev 1
link to the sqlite3 library
František Kučera <franta-hg@frantovo.cz> [Sat, 27 Jul 2019 18:41:13 +0200] rev 0
project skeleton