František Kučera <franta-hg@frantovo.cz> [Sun, 04 Feb 2024 16:10:37 +0100] rev 255
tabular formatter: new option 'separateBy' to print horizontal separator on each change of given column
František Kučera <franta-hg@frantovo.cz> [Fri, 23 Sep 2022 18:05:50 +0200] rev 254
recfile formatter: write record count (as a comment at the end of the relation)
František Kučera <franta-hg@frantovo.cz> [Sun, 13 Sep 2020 12:01:35 +0200] rev 253
combatibility with Java 9+, Tested with Java 11; JAXB library
František Kučera <franta-hg@frantovo.cz> [Sat, 25 Jul 2020 17:25:19 +0200] rev 252
improve multiple results support
The specification talks exactly about -1:
> Returns: the current result as an update count;
> -1 if the current result is a ResultSet object or there are no more results
Other negative numbers can theoretically mean something different than „no more results“
e.g. unknown number of updates (?).
František Kučera <franta-hg@frantovo.cz> [Fri, 20 Dec 2019 12:55:01 +0100] rev 251
sqldk-relpipe convergence: integer type (relpipe already support signed integers)
František Kučera <franta-hg@frantovo.cz> [Thu, 24 Oct 2019 21:43:08 +0200] rev 250
fix license version: GNU GPLv3
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Apr 2019 20:04:06 +0200] rev 249
change XMLNS for the configuration
Use The 'tag' URI Scheme <http://www.faqs.org/rfcs/rfc4151.html>
Upgrade local configuration:
sed 's@https://sql-dk.globalcode.info/xmlns/configuration@tag:globalcode.info,2018:sqldk/configuration@g' -i ~/.sql-dk/config.xml
František Kučera <franta-hg@frantovo.cz> [Tue, 30 Apr 2019 19:49:17 +0200] rev 248
transform the record formatter into the recfile formatter
still a human-readable format and very similar
but also machine-readable – can be processed in GNU Recutils and Relational pipes
František Kučera <franta-hg@frantovo.cz> [Mon, 29 Apr 2019 01:27:26 +0200] rev 247
getTableName() is needed for the metadata
František Kučera <franta-hg@frantovo.cz> [Tue, 05 Mar 2019 22:03:02 +0100] rev 246
support custom relation names in the XML formatter (added --relation CLI option)
František Kučera <franta-hg@frantovo.cz> [Tue, 05 Mar 2019 21:22:33 +0100] rev 245
sqldk-relpipe convergence started
František Kučera <franta-hg@frantovo.cz> [Mon, 04 Mar 2019 22:28:29 +0100] rev 244
back to the snapshot
František Kučera <franta-hg@frantovo.cz> [Mon, 04 Mar 2019 22:26:31 +0100] rev 243
Added tag v0.10 for changeset 0503996934e0
František Kučera <franta-hg@frantovo.cz> [Mon, 04 Mar 2019 22:26:24 +0100] rev 242
release: 0.10
František Kučera <franta-hg@frantovo.cz> [Mon, 04 Mar 2019 22:20:36 +0100] rev 241
switch to JUnit5
František Kučera <franta-hg@frantovo.cz> [Mon, 04 Mar 2019 22:11:11 +0100] rev 240
mavenized: sql-dk-parent
František Kučera <franta-hg@frantovo.cz> [Mon, 04 Mar 2019 22:02:52 +0100] rev 239
mavenized: jdbc-dk-driver
František Kučera <franta-hg@frantovo.cz> [Mon, 04 Mar 2019 20:15:24 +0100] rev 238
mavenized: sql-dk
František Kučera <franta-hg@frantovo.cz> [Mon, 04 Mar 2019 17:06:42 +0100] rev 237
mavenized: jdbc-loopback-driver
František Kučera <franta-hg@frantovo.cz> [Tue, 26 Feb 2019 18:19:49 +0100] rev 236
Avoid reusing/rewriting the DB connection properties.
There was weird random errors while testing connection to multiple DB in parallel when one of them was meta connection to same DB connection.
Two kinds of exception: 1) missing password 2) „Passing DB password as CLI parameter is insecure!“
František Kučera <franta-hg@frantovo.cz> [Tue, 26 Feb 2019 17:31:41 +0100] rev 235
JDBC drivers: fix 'Unsupported URL' – drivers might be called witrh wrong URLs and then they should (according to the JavaDoc) return null instead of throwing an exception.
This problem occurred when --test-connection was testing multiple connections in parallel.
František Kučera <franta-hg@frantovo.cz> [Tue, 26 Feb 2019 16:36:45 +0100] rev 234
TabularFormatter: add support for SQLXML values
František Kučera <franta-hg@frantovo.cz> [Tue, 26 Feb 2019 15:57:49 +0100] rev 233
XML array hack
František Kučera <franta-hg@frantovo.cz> [Tue, 26 Feb 2019 15:49:57 +0100] rev 232
c++: recognize batch mode
František Kučera <franta-hg@frantovo.cz> [Tue, 26 Feb 2019 15:47:43 +0100] rev 231
netbeans
František Kučera <franta-hg@frantovo.cz> [Fri, 05 Jan 2018 23:53:23 +0100] rev 230
c++ version skeleton
František Kučera <franta-hg@frantovo.cz> [Wed, 09 Nov 2016 00:18:01 +0100] rev 229
InfoLister/test: show also database server name and version
František Kučera <franta-hg@frantovo.cz> [Sun, 13 Sep 2015 20:10:13 +0200] rev 228
BarChartFormatter: TODO comments
František Kučera <franta-hg@frantovo.cz> [Sun, 13 Sep 2015 19:25:36 +0200] rev 227
headerTypes: new option to hide column types in tabular headers
František Kučera <franta-hg@frantovo.cz> [Sun, 06 Sep 2015 21:48:54 +0200] rev 226
BarChartFormatter: format null as an empty/missing bar + better logging
František Kučera <franta-hg@frantovo.cz> [Sun, 06 Sep 2015 21:46:03 +0200] rev 225
XmlFormatter: support for printing SQLXML types
František Kučera <franta-hg@frantovo.cz> [Sun, 30 Aug 2015 02:28:15 +0200] rev 224
BarChartFormatter: first version
František Kučera <franta-hg@frantovo.cz> [Sun, 30 Aug 2015 02:24:36 +0200] rev 223
LoggerProducer
František Kučera <franta-hg@frantovo.cz> [Tue, 18 Aug 2015 23:37:22 +0200] rev 222
bash_completion.pl: defaultFormatter
František Kučera <franta-hg@frantovo.cz> [Sun, 16 Aug 2015 01:40:44 +0200] rev 221
bash-completion: --formatter-property choices: first working version
František Kučera <franta-hg@frantovo.cz> [Sun, 16 Aug 2015 01:25:01 +0200] rev 220
bash-completion: --formatter-property names
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 16:15:30 +0200] rev 219
SingleRecordFormatter: escape whitespace characters in the same way as in TabularFormatter (fixed)
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 16:12:06 +0200] rev 218
SingleRecordFormatter: escape whitespace characters in the same way as in TabularFormatter
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 14:40:48 +0200] rev 217
--list-formatter-properties: better help/description
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 14:35:27 +0200] rev 216
--list-formatter-properties: optional column declared_in
Usage:
sql-dk --list-formatter-properties tabular --list-formatter-properties xml --list-formatter-properties xhtml --list-formatter-properties tex --formatter xhtml --formatter-property InfoLister:print:declared_in true > formatter-properties.xhtml
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 14:00:47 +0200] rev 215
--list-formatter-properties: added column declared_in
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 13:58:43 +0200] rev 214
property annotations: first woking version of --list-formatter-properties
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 13:21:26 +0200] rev 213
getClassHierarchy function
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 11:52:38 +0200] rev 212
property annotations: first version (inherited properties are not working yet)
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 11:07:50 +0200] rev 211
property annotations: dummy InfoLister table
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 10:53:35 +0200] rev 210
InfoLister: private methods + formatter for formatter properties
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 10:47:56 +0200] rev 209
property annotations: grounds for --list-formatter-properties
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 10:44:36 +0200] rev 208
Java 8 for jdbc-dk-driver
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 10:34:18 +0200] rev 207
property annotations: default values
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 10:20:39 +0200] rev 206
property annotations (documentation) for particular formatters
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 10:04:28 +0200] rev 205
property annotations for documentation of formatter properties
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 09:42:43 +0200] rev 204
Java 8
František Kučera <franta-hg@frantovo.cz> [Sat, 15 Aug 2015 09:40:22 +0200] rev 203
connection tunnelling: configuration and logging
František Kučera <franta-hg@frantovo.cz> [Sun, 21 Jun 2015 16:21:51 +0200] rev 202
SingleRecordFormatter: Formatter intended for printing one record (or few records) with many columns.Prints each colum name and its value on separate line.
František Kučera <franta-hg@frantovo.cz> [Sun, 24 May 2015 19:17:50 +0200] rev 201
InfoLister: sort rows in --list-java-properties and --list-environment-variables
František Kučera <franta-hg@frantovo.cz> [Sun, 24 May 2015 19:10:25 +0200] rev 200
InfoLister: new listings: --list-java-properties and --list-environment-variables
František Kučera <franta-hg@frantovo.cz> [Sun, 24 May 2015 18:45:46 +0200] rev 199
sql-dk.sh: support for JAVA_OPTIONS
František Kučera <franta-hg@frantovo.cz> [Sun, 24 May 2015 17:35:37 +0200] rev 198
Schemas and XSL for new 'driver' configuration option
František Kučera <franta-hg@frantovo.cz> [Mon, 18 May 2015 00:36:23 +0200] rev 197
fix typo: databgase → database
František Kučera <franta-hg@frantovo.cz> [Mon, 18 May 2015 00:33:10 +0200] rev 196
parallel connection testing: avoid deadlocks – preload drivers + better exception handling and logging
František Kučera <franta-hg@frantovo.cz> [Sun, 17 May 2015 15:43:20 +0200] rev 195
just JavaDoc
František Kučera <franta-hg@frantovo.cz> [Sun, 17 May 2015 13:51:40 +0200] rev 194
JDBC driver class can be specified in the database configuration as an optional parameter (useful especially while embedding jdbc-dk-driver into other application that does not support automatic driver discovery)
František Kučera <franta-hg@frantovo.cz> [Sun, 17 May 2015 13:15:21 +0200] rev 193
configuration loading: use JAXB index and set classloader (useful while embedding into Netbeans and other applications)
František Kučera <franta-hg@frantovo.cz> [Sun, 17 May 2015 00:27:56 +0200] rev 192
jdbc-dk-driver: first working version
František Kučera <franta-hg@frantovo.cz> [Sat, 16 May 2015 23:58:06 +0200] rev 191
avoid NullPointerException (value = null) while duplicating to java.util.Properties
František Kučera <franta-hg@frantovo.cz> [Sat, 16 May 2015 23:55:11 +0200] rev 190
userName and password are not needed for the loopback driver
František Kučera <franta-hg@frantovo.cz> [Sat, 16 May 2015 21:42:52 +0200] rev 189
separate configuration loading into the Loader class
František Kučera <franta-hg@frantovo.cz> [Sat, 16 May 2015 20:25:16 +0200] rev 188
jdbc-dk-driver: include main project sources
František Kučera <franta-hg@frantovo.cz> [Sat, 16 May 2015 20:13:43 +0200] rev 187
jdbc-dk-driver: netbeans project for the meta driver
František Kučera <franta-hg@frantovo.cz> [Sat, 16 May 2015 20:12:51 +0200] rev 186
hgignore: more regular expressions
František Kučera <franta-hg@frantovo.cz> [Sun, 01 Feb 2015 00:03:40 +0100] rev 185
Tabular formatter: fix problem with CR (carriage return).
Less command or orher programs shows it as ^M (two characters) and it breaks the table layout – so we need to translate it to a single symbol.
František Kučera <franta-hg@frantovo.cz> [Sat, 31 Jan 2015 23:40:31 +0100] rev 184
fix imports
František Kučera <franta-hg@frantovo.cz> [Sat, 06 Dec 2014 14:38:41 +0100] rev 183
parallelized DB connection testing
František Kučera <franta-hg@frantovo.cz> [Sat, 06 Dec 2014 14:12:59 +0100] rev 182
logging: strip line ends from the error message if not printing stacktrace
František Kučera <franta-hg@frantovo.cz> [Mon, 29 Sep 2014 10:34:54 +0200] rev 181
fix imports
František Kučera <franta-hg@frantovo.cz> [Mon, 29 Sep 2014 00:13:14 +0200] rev 180
RPM: simple script/spec for building .rpm for Fedora
František Kučera <franta-hg@frantovo.cz> [Thu, 25 Sep 2014 17:50:40 +0200] rev 179
Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz> [Wed, 24 Sep 2014 22:53:30 +0200] rev 178
final properties
František Kučera <franta-hg@frantovo.cz> [Fri, 09 May 2014 14:16:45 +0200] rev 177
jdbc-loopback: refuse connection if URL is unsupported
František Kučera <franta-hg@frantovo.cz> [Sat, 12 Apr 2014 20:01:42 +0200] rev 176
parameter index → parameter number (starts with 1
)
František Kučera <franta-hg@frantovo.cz> [Sun, 06 Apr 2014 23:33:09 +0200] rev 175
Added tag v0.9 for changeset 3c6d560a1d14
František Kučera <franta-hg@frantovo.cz> [Sun, 06 Apr 2014 23:32:54 +0200] rev 174
TeXFormatter: first version
František Kučera <franta-hg@frantovo.cz> [Sun, 06 Apr 2014 17:53:36 +0200] rev 173
netbeans
František Kučera <franta-hg@frantovo.cz> [Sun, 06 Apr 2014 17:53:01 +0200] rev 172
improved JDBC loopback driver
František Kučera <franta-hg@frantovo.cz> [Fri, 04 Apr 2014 23:40:28 +0200] rev 171
JDBC loopback driver: first version
experimental JDBC driver which does not need any real SQL database,
just passes values of statement parameters as a result set.
The first parameter is column count, then follows column names and then data.
Example:
2 a b c d e f
will result into table:
a | b
-----
c | d
e | f
František Kučera <franta-hg@frantovo.cz> [Tue, 21 Jan 2014 00:11:04 +0100] rev 170
Tabular: replace also Non-breaking space with colored symbol (like newlines and TABs)
František Kučera <franta-hg@frantovo.cz> [Mon, 20 Jan 2014 23:58:57 +0100] rev 169
Tabular: replace also TABs with colored symbol (like newlines)
František Kučera <franta-hg@frantovo.cz> [Mon, 20 Jan 2014 00:05:23 +0100] rev 168
fixed unit tests
František Kučera <franta-hg@frantovo.cz> [Sun, 19 Jan 2014 18:30:21 +0100] rev 167
fix Tabular: table was broken if value ended with \n
František Kučera <franta-hg@frantovo.cz> [Fri, 17 Jan 2014 23:24:07 +0100] rev 166
SQL from STDIN: --sql-in
František Kučera <franta-hg@frantovo.cz> [Thu, 16 Jan 2014 12:28:08 +0100] rev 165
XmlFormatter: support (multidimensional) arrays
František Kučera <franta-hg@frantovo.cz> [Thu, 16 Jan 2014 12:23:16 +0100] rev 164
FakeSqlArray#toString()
František Kučera <franta-hg@frantovo.cz> [Wed, 15 Jan 2014 22:22:45 +0100] rev 163
XML formatter: fix null column values
František Kučera <franta-hg@frantovo.cz> [Wed, 15 Jan 2014 21:38:02 +0100] rev 162
InfoLister: preserve order of databases to test and to list driver properties
František Kučera <franta-hg@frantovo.cz> [Wed, 15 Jan 2014 21:37:24 +0100] rev 161
fix unused imports
František Kučera <franta-hg@frantovo.cz> [Wed, 15 Jan 2014 21:26:15 +0100] rev 160
InfoLister: option --list-formatters also tests, if formatter class can be instantiated (thus is valid)
František Kučera <franta-hg@frantovo.cz> [Wed, 15 Jan 2014 21:06:12 +0100] rev 159
InfoLister: list configured and configurable JDBC driver properties – option: --list-jdbc-properties
František Kučera <franta-hg@frantovo.cz> [Wed, 15 Jan 2014 18:15:55 +0100] rev 158
InfoLister: print list of available JDBC drivers: --list-jdbc-drivers
František Kučera <franta-hg@frantovo.cz> [Sat, 11 Jan 2014 18:37:57 +0100] rev 157
fix typo in .deb package description
František Kučera <franta-hg@frantovo.cz> [Fri, 10 Jan 2014 23:28:07 +0100] rev 156
Added tag v0.8 for changeset eb3676c6929b
František Kučera <franta-hg@frantovo.cz> [Fri, 10 Jan 2014 23:21:28 +0100] rev 155
more JavaDoc
František Kučera <franta-hg@frantovo.cz> [Fri, 10 Jan 2014 20:13:16 +0100] rev 154
XML: batchResults → batchResult
František Kučera <franta-hg@frantovo.cz> [Fri, 10 Jan 2014 16:46:40 +0100] rev 153
distributions: src release script
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 23:50:22 +0100] rev 152
XML formatter: use singleAttribute(qname(""), "")
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 23:39:47 +0100] rev 151
XML formatter: null values – null attribute instead of „null“ string
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 20:08:53 +0100] rev 150
wrapper script fix: XSL is in .deb package gzipped
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 19:59:19 +0100] rev 149
Batch error – proper exit code: EXIT_BATCH_ERROR = 8
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 19:35:20 +0100] rev 148
just formatting
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 19:24:26 +0100] rev 147
Improved BatchEncoder: writeNextString()
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 19:18:52 +0100] rev 146
BatchDecoder: basic decoder
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 14:50:26 +0100] rev 145
BatchEncoder: fix (encode query with numbered parameters)
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 14:33:51 +0100] rev 144
Batch: basic encoder and prepare batch
František Kučera <franta-hg@frantovo.cz> [Wed, 08 Jan 2014 12:44:18 +0100] rev 143
convert named parameters to numbered
František Kučera <franta-hg@frantovo.cz> [Tue, 07 Jan 2014 21:54:59 +0100] rev 142
Formatters: structural change – new level „statement“ → query and parameters are no more duplicated into each result set or updates result
František Kučera <franta-hg@frantovo.cz> [Tue, 07 Jan 2014 21:53:24 +0100] rev 141
default config: no standalone
František Kučera <franta-hg@frantovo.cz> [Sun, 05 Jan 2014 11:42:41 +0100] rev 140
css/padding
František Kučera <franta-hg@frantovo.cz> [Sun, 05 Jan 2014 00:49:01 +0100] rev 139
fix InfoLister: squared infos
František Kučera <franta-hg@frantovo.cz> [Sun, 05 Jan 2014 00:17:27 +0100] rev 138
XHTML formatter: simple formatting of (multidimensional) arrays
František Kučera <franta-hg@frantovo.cz> [Sat, 04 Jan 2014 23:44:34 +0100] rev 137
XHTML formatter: distinguish number and boolean
František Kučera <franta-hg@frantovo.cz> [Sat, 04 Jan 2014 23:39:38 +0100] rev 136
XML/XHTML formatter – DOCTYPE