Python FIS MTM/PIP SQL/RPC Interface
Project description
Successor to https://github.com/fopina/pygtm
Installation
Simply use pip:
$ pip install pyfispip
Or install latest version from github:
$ pip install git+https://github.com/fopina/pyfispip/
Usage
Use it in your code (check examples folder):
>>> from fispip import PIP
>>> pip = PIP()
>>> pip.connect('localhost',61315,'1','XXX')
>>> pip.executeSQL('SELECT TJD FROM CUVAR')
(['60960'], ['D'])
Or quickly use the CLI:
$ python -m fispip -h
usage: __main__.py [-h] [-u USER] [-p PWD] [-P PORT] [-S TYPE] [-s]
host params [params ...]
Python FIS MTM/PIP SQL/RPC Interface
positional arguments:
host Hostname to connect
params For RPC: MRPC_ID [MRPC_PARAM1 [MRPC_PARAM...]] For
SQL: SQL_STATEMENT
optional arguments:
-h, --help show this help message and exit
-u USER, --user USER PIP Username (default: 1)
-p PWD, --password PWD
PIP Password (default: XXX)
-P PORT, --port PORT MTM port (default: 61315)
-S TYPE, --server TYPE
PIP server type (default: SCA$IBS)
-s, --sql Execute SQL statement (default action is RPC)
$ python -m fispip localhost -s select tjd from cuvar
60960
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
fispip-0.0.3.tar.gz
(9.5 kB
view hashes)