EQTC

NAME
SYNOPSIS
DESCRIPTION
OPTIONS
CONFIGURATION FILE FORMAT
SEE ALSO
RETURN VALUES
AUTHORS

NAME

eqtc − Query arbitrary Emdros databases

SYNOPSIS

eqtc [ options ]

DESCRIPTION

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

Typical usage would be:

eqtc -c myconfigfile.cfg

If built to use MySQL or PostgreSQL, then you may need additional options such as "-u username", "-p password" and "-h hostname".

OPTIONS

eqtc supports the following command-line switches:
−−help

show help

−V , −−version

show version

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

CONFIGURATION FILE FORMAT

eqtc must be given the name of a configuration file (with the -c option). This configuration file tells eqtc 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/

SEE ALSO

mql(1), eqt(1), eqtu(1)

RETURN VALUES

0 Success
1
Wrong usage
2
Connection to backend server could not be established
3
An exception occurred (the type is printed on stderr)
4
Could not open file
5
Database error
6
Compiler error (error in MQL input)

AUTHORS

Written Ulrik Sandborg-Petersen (ulrikp@emdros.org).