query.py1
Execute a query
Usage
query host
port
socket
user
passwd
query
Overview
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 userfred, with passwordsecret, and run a query.
Releases
Unchanged in 3 releases since Debian 3.1 (Sarge).