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