eels_db_query(1Meels)

eels_db_query -- user specified SQL query from database

Synopsis

eels_db_query [-d database] [-f field_separator [-h] [-n] [-p page_length]
[-q SQL_Query] [-t trace_level][-w] [-y] [-z]

eels_db_query [-d database] [-l]

eels_db_query [-d database] [-L]

Description

Use eels_db_query to query an EELS database for log information. Database queries are in the form of a standard SQL query. The output of this command can either be in HTML format, or in a raw format that is better suited for use with scripts.

When eels_db_query returns data in HTML format, it is returned in a tabular format that can be displayed by a web browser. This is convenient when integrating eels_db_query with CGI scripts. The table can be printed with the field names at the top of the table. In addition, the HTML table can be automatically broken into smaller tables of a specified size.

The eels_db_query command can also return data in raw format. With this option, each row of output (terminated by a newline) corresponds to one row in the database. Each field of the record is separated by a vertical bar or by a user specified field separator on the command line. This type of output is well suited for integrating this command with perl scripts, or other shell script languages.

The SQL_Query argument is a string that selects the records to be archived.

Options

-d database: The name of the database to connect to.
-f field_separator: Specify the character that should be used as the field separator (Not applicable when output is in HTML format). Default is ``|''.
-h: Print output in HTML format.
-n: Print field names as first line of output. For HTML output the field names are printed at the top of the table as column headings.
-l: List all the fields of the events table, separating each field name by a newline.
-L: List all the fields of the events table, separating each field name by a space.
-p page_length: When output is in HTML format, specify the maximum number of lines in a table before that table is split into multiple tables.
-q SQL_Query: The SQL query used to query the database for records.
-t trace_level: Print debugging information. Valid debugging levels are ``1'' for minimal logging to ``4'' for full logging.
-w: When output is in HTML format, wrap data in table fields.
-y: If any of the fields that are printed contain data, print them in human readable format instead of milliseconds since the EPOCH.
-z: Do not print HTML page headers when producing HTML output.

Example

eels_db_query -d httpddb -h -n -y -q "select * from events"

The above example selects all records from the ``events'' table of the httpdb database. The output is displayed in HTML format, with column headers and dates in a human readable format.

References

eels_config(4eels)