EQTC

Section: User Commands (1)
Updated: January 20, 2007
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: "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

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: 12:15:51 GMT, August 15, 2009