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

Basic XHTML formatter

Properties: setLastDefaults()

XML formatter fix: line breaks at the end of the text will be eaten – if you need them, use indentText = false

XML formatter: optional label attribute in column elements

XML formatter: option for preserve whitespace or indent text with line breaks

XML formatter: rows, columns, updates results

XML formatter: abstract + part of basic XML formatter

new function: foHex()

Colors can be definitively turned off in constructor

better notNull() function

tabular – todo

TabularWrappingFormatter – first version

customizable classpath

package and copy XSLT

XML schemas licenses

XSLT for viewing config files in a web browser (Firefox, rekonq etc.)

example-config.xml moved to xml dir: symlink

example-config.xml moved to xml dir

Pack XSD and RNC into .deb

basic XSD

Starter script: create symlinks for XSD and Relax NG XML schemas

Relax NG schema for XML configuration

Debian package: interim build script for .deb packages

Starter script: systemwide JAR location (user can override it in environment.sh by JAR variable)

Bash completion: no 'have sql-dk' test

version info: copyright and contact

DB credentials can be CLI options + log warning: insecure

database/formatter properties also as CLI options

use database properties

cloneable property and properties

formatter/database properties

TabularFormatter: values with line ends will not break our tables

Load ~/.sql-dk/environment.sh if exists

Formatter is now AutoCloseable – so have chance to do some clean up and close the stream, if some error occurs (e.g. lost connection during result set reading)

typo in help generator

Data types help: not all available types are currently supported (will be later by type converters)

Value formatting: Object → String conversion is job for particular formatter

SQL warnings are already printed to the log

basic generated help

more precise exit/error codes

basic help

Type names in --types option are case insensitive

support all types from java.sql.Types.Types

Formatter: one more level: writeStartBatch() + writeEndBatch() which allows multiple databases on output

TabularFormatter: no nonbreakable spaces in table cell padding

InfoLister (configuration listings) will use TabularPrefetchingFormatter as default

TabularPrefetchingFormatter: prefetch whole result set to avoid value overflow the cell

TabularFormatter: support for value trim (if longer than cell size)

log SQLWarnings

sql-dk startup shell script

bash completion: DB name for --test-connection

bash completion: license

bash completion: use dynamic completion derived from configuration if available

bash completion: perl + bash + ant for generating completion script

bash completion: generate helper files with databases and formatters from configuration

more bash completion tags

Possibly missing parameter: ignore empty „parameter names“ (caused e.g. by „::text“ typecasts)

tags for BASH completion

support for ACSII-nostalgia tables

throw ConfigurationException instead of returning null, if database or formatter of given name is not configured

allow multiple databases connection test in --test-connection

formatted output for: --test-connection

formatted output for: --list-formatters --list-databases

allow custom formatters also for JUST_SHOW_INFO commands

use formatter also for printing info! --list-types

InfoLister, InfoType: switch → enum

SQLType enum wrapper for java.sql.Types

option --list-formatters – list configured and built-in formatters

option --list-databases list configured databases

option --test-connection – tests connection to given database

use System.out if mode is JUST_SHOW_INFO (thus user can easily read license or help using … | less)

validation: test if prefix/suffix are valid regular expressions

types update

expect invalid regexp in prefix/suffix and throw wrapped exception → better exit code

SingleValueFormatter

logging: print stacktraces if level is less than INFO

logging: configurable level

Log level: FINE → INFO

exit codes: 0 = success; 4 = SQL error; 3 = other expected error; 1 = unexpected error (implicit 1)

colorful logging

named parameters: prefix/suffix are now regular expressions

more functions unit tests

new option --data-named (then follows name/value pairs without prefix/suffix)

log warning: Possibly missing parameters

named parameters: better exceptions

support named parameters

print CLI options problems if any

fix default suffix

function escapeRegEx()

fix test

named parameters: suffix (default is empty)

TabularFormatter: also booleans will be aligned to the right

DatabaseConnection implements AutoCloseable

No special formatting for generated keys. Use 'INSERT … RETURNING id' or 'INSERT … RETURNING *' to get generated keys.

TabularFormatter: print colorful tables\!

TabularFormatter: basic column padding

String padding functions: lpad(), rpad()

support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)

fix error message

accept SQL commands returning more ResultSets

first working version

configuration loading from XML

TabularFormatter: basics

ColorfulPrintWriter: colorz, wow

class for xmlns constants

more configuration, more JAXB, more formatters