eqtu − Query arbitrary Emdros databases with a GUI
eqtu
eqtu is a generic query tool for Emdros databases. It shows the results in a way that is more meaningful than the output from mql(1).
See the homepage for more information:
http://emdros.org/qrytool/
eqtu
supports the following command-line switches:
−b , −−backend backend
set database backend to ‘backend’. Valid values are: For PostgreSQL: "p", "pg", "postgres", and "postgresql". For MySQL: "m", "my", and "mysql". For SQLite 2.X.X: "2", "s", "l", "lt", "sqlite", and "sqlite2". For SQLite 3.X.X: "3", "s3", "lt3", and "sqlite3".
−c configfile
set the name of the ocnfiguration file
−d , −−dbname dbname
set database name (overrides what is in the config file)
−h , −−host hostname
set db back-end hostname to connect to (default is ’localhost’) (has no effect on SQLite)
−u , −−user user
set database user to connect as (default is ’emdf’) (has no effect on SQLite)
−p , −−password password
set password to use for the database user. Has no effect on SQLite, unless you have an encryption-enabled SQLite, in which case this gets passed as the key.
−−png |
Generate PNGs only; do not show GUI. |
eqtu asks for a configuration file upon startup. This configuration file tells eqtu the basic parameters which it needs in order to work.
The configuration file has a very standard format: a) Everything from a hash-mark (#) to the end of the line is ignored. b) blank lines are ignored. c) All other lines should be in the form "key = value" where both key and value consist of non-whitespace.
A number of sample configuration files are provided (one is "default.cfg"). They are probably located in /usr/local/share/emdros/qrytool/ (if on Unix/Linux/Mac OS X), while on Windows they are probably in INSTALLPREFIX\tc. The configuration file is explained at the following URL:
http://emdros.org/qrytool/
mql(1), eqtc(1)
Written Ulrik Sandborg-Petersen (ulrikp@emdros.org).