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

DatabaseConnection: connect JDBC

DatabaseConnection: just change package

configuration basics

formatter: currentRowCount

formatter: FormatterContext

formatter: ColumnDescriptor

formatter: interface and abstract class

CLI: --help is default option

refactor, configuration

help option: --help – basics

version info: option --version

license option: --license

license: GNU GPLv3+

show info basics: list databases + test connection

show info basics

fix: try/catch

unit-test: names, types, prefix

just indent

unit-test: types

better exceptions

more exceptions

more unit-tests

first unit-test

more OOP

data/types CLI options parsing

name prefix

more code

WOW some classes LOL; TODO: refactor

empty netbeans project