EQTC
Section: User Commands (1)
Updated: September 23, 2006
Index
Return to Main Contents
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: "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
Copyright
2005-2006 by Ulrik Petersen (ulrikp@users.sourceforge.net). Note that
this software is distributed under the GNU GPL. It comes with
ABSOLUTELY NO WARRANTY!. See the sources for details.
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- OPTIONS
-
- CONFIGURATION FILE FORMAT
-
- SEE ALSO
-
- RETURN VALUES
-
- AUTHORS
-
This document was created by
man2html,
using the manual pages.
Time: 22:29:32 GMT, December 01, 2006