recfile formatter: write record count (as a comment at the end of the relation)

combatibility with Java 9+, Tested with Java 11; JAXB library

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 (?).

sqldk-relpipe convergence: integer type (relpipe already support signed integers)

fix license version: GNU GPLv3

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

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

getTableName() is needed for the metadata

support custom relation names in the XML formatter (added --relation CLI option)

sqldk-relpipe convergence started

back to the snapshot

Added tag v0.10 for changeset 0503996934e0

release: 0.10

switch to JUnit5

mavenized: sql-dk-parent

mavenized: jdbc-dk-driver

mavenized: sql-dk

mavenized: jdbc-loopback-driver

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!“

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.

TabularFormatter: add support for SQLXML values

XML array hack

c++: recognize batch mode

netbeans

c++ version skeleton

InfoLister/test: show also database server name and version

BarChartFormatter: TODO comments

headerTypes: new option to hide column types in tabular headers

BarChartFormatter: format null as an empty/missing bar + better logging

XmlFormatter: support for printing SQLXML types

BarChartFormatter: first version

LoggerProducer

bash_completion.pl: defaultFormatter

bash-completion: --formatter-property choices: first working version

bash-completion: --formatter-property names

SingleRecordFormatter: escape whitespace characters in the same way as in TabularFormatter (fixed)

SingleRecordFormatter: escape whitespace characters in the same way as in TabularFormatter

--list-formatter-properties: better help/description

--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

--list-formatter-properties: added column declared_in

property annotations: first woking version of --list-formatter-properties

getClassHierarchy function

property annotations: first version (inherited properties are not working yet)

property annotations: dummy InfoLister table

InfoLister: private methods + formatter for formatter properties

property annotations: grounds for --list-formatter-properties

Java 8 for jdbc-dk-driver

property annotations: default values

property annotations (documentation) for particular formatters

property annotations for documentation of formatter properties

Java 8

connection tunnelling: configuration and logging

SingleRecordFormatter: Formatter intended for printing one record (or few records) with many columns.Prints each colum name and its value on separate line.

InfoLister: sort rows in --list-java-properties and --list-environment-variables

InfoLister: new listings: --list-java-properties and --list-environment-variables

sql-dk.sh: support for JAVA_OPTIONS

Schemas and XSL for new 'driver' configuration option

fix typo: databgase → database

parallel connection testing: avoid deadlocks – preload drivers + better exception handling and logging

just JavaDoc

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)

configuration loading: use JAXB index and set classloader (useful while embedding into Netbeans and other applications)

jdbc-dk-driver: first working version

avoid NullPointerException (value = null) while duplicating to java.util.Properties

userName and password are not needed for the loopback driver

separate configuration loading into the Loader class

jdbc-dk-driver: include main project sources

jdbc-dk-driver: netbeans project for the meta driver

hgignore: more regular expressions

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.

fix imports

parallelized DB connection testing

logging: strip line ends from the error message if not printing stacktrace

fix imports

RPM: simple script/spec for building .rpm for Fedora

Basic JMX management/reporting – counters for commands and records

final properties

jdbc-loopback: refuse connection if URL is unsupported

parameter index → parameter number (starts with 1 )

Added tag v0.9 for changeset 3c6d560a1d14

TeXFormatter: first version

netbeans

improved JDBC loopback driver

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

Tabular: replace also Non-breaking space with colored symbol (like newlines and TABs)

Tabular: replace also TABs with colored symbol (like newlines)

fixed unit tests

fix Tabular: table was broken if value ended with \n

SQL from STDIN: --sql-in

XmlFormatter: support (multidimensional) arrays

FakeSqlArray#toString()

XML formatter: fix null column values

InfoLister: preserve order of databases to test and to list driver properties

fix unused imports

InfoLister: option --list-formatters also tests, if formatter class can be instantiated (thus is valid)

InfoLister: list configured and configurable JDBC driver properties – option: --list-jdbc-properties

InfoLister: print list of available JDBC drivers: --list-jdbc-drivers

fix typo in .deb package description

Added tag v0.8 for changeset eb3676c6929b

more JavaDoc

XML: batchResults → batchResult

distributions: src release script

XML formatter: use singleAttribute(qname(""), "")

XML formatter: null values – null attribute instead of „null“ string

wrapper script fix: XSL is in .deb package gzipped

Batch error – proper exit code: EXIT_BATCH_ERROR = 8

just formatting

Improved BatchEncoder: writeNextString()

BatchDecoder: basic decoder

BatchEncoder: fix (encode query with numbered parameters)

Batch: basic encoder and prepare batch

convert named parameters to numbered

Formatters: structural change – new level „statement“ → query and parameters are no more duplicated into each result set or updates result

default config: no standalone

css/padding

fix InfoLister: squared infos

XHTML formatter: simple formatting of (multidimensional) arrays

XHTML formatter: distinguish number and boolean

XML/XHTML formatter – DOCTYPE

XHTML formatter: CSS and other improvements