man query.py (Commandes) - execute a query
NAME
query.py - execute a query
SYNOPSIS
query host port socket user passwd query
DESCRIPTION
The query.py command executes the query specified in the query parameter and returns the result set as a quote/comma/return seperated value list to standard output.
OPTIONS
- host
- hostname of the machine running the listener daemon
- port
- port number the listener daemon is listening on, for local or remote connections
- socket
- socket the listener daemon is listening on, for local connections
- user
- SQL Relay user name (as per config file)
- passwd
- SQL Relay password (as per config file)
- query
- query to be executed
This command is a python implementation of the query (1) command.
EXAMPLES
- query.py "" "" /tmp/examplesocket fred secret "select * from tbl"
- Connect to the SQL Relay listener daemon running on the local machine, with socket /tmp/examplesocket, as user fred, with password secret, and run a query.
SEE ALSO
fields(1), query(1), sqlr-config-gtk(1), sqlrsh(1), sqlr-cachemanager(8), sqlr-connection(8), sqlr-listener(8), sqlr-scaler(8), sqlr-start(8), sqlr-stop(8), and the documentation in /usr/share/doc/sqlrelay.
AUTHORS
This manual page was written by Andreas Tille <tille@debian.org> and Florian M. Weps <fweps@greenmail.ch>, for the Debian GNU/Linux system (but may be used by others).