MQL

NAME
SYNOPSIS
DESCRIPTION
OPTIONS
RETURN VALUES
AUTHORS

NAME

mql − A front-end to the Emdros engine using the MQL query language

SYNOPSIS

mql [ options ] filename
mql
[ options ]

DESCRIPTION

mql is a front-end to Emdros using the MQL query language. If a filename is given on the command-line, the contents of that file are piped through the MQL engine. If no filename is given on the command-line, stdin is used to get the MQL input. The output is given on stdout, or on stderr if unsuccessful.

OPTIONS

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

show help

−V , −−version

show version

−−xml 

output-format is XML

−−cxml 

output-format is compact XML

−−console

output-format is console (this is the default)

−−incomplete-output

the caller is prepared to expect incomplete output. The tradeoff is that, with this option, we gain some speed due to flushing the output buffer all the time being unnecessary.

−d , −−dbname dbname

set initial dbname (default is ’emdf’)

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

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

−n , −−nop

do not print results (no output)

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