riris

Remote InterSystems IRIS command execution
This is a simple py script (meant to be run from CLI) that uses the “irisnative” module and allow you to execute a variety of things on a remote iris instance.
We are all good to execute things on the instance that is installed on the local machine, but what do you need to do to get something done on a remote server?
With RIRIS you can do this in an easy way. You can script it with bash or other, or you can import the module

installation

You need to have python 3 installed and also the irisnative module
After that there’s no need of installing the application, it’s just a single py file

Help

usage: riris [-H] [-h host] [-s port] [-n namespace] [-u user] [-p password] [-v]
             {cls,rtn,set,get,kil,cod,sql} ...
common options:
-H, --help                           Print this help
-h host, --host host                 Destination host
-s port, --port port                 Destination port
-n namespace, --namespace namespace  Namespace
-u user, --user user                 IRIS username
-p password, --password password     IRIS password, if omitted it will be requested
-v, --verbose                        Verbosity
specific options:
cls
Run a class method
usage: riris cls [-H] [cname] [method] [arguments ...]
arguments:
cname       Class to be called
method      Method to be called
arguments   Method parameters
examples:
./riris -h iris-server -p SYS cls %Library.Utility Date 5
rtn
Run a routine
usage: riris rtn [-H] [fname] [rname] [arguments ...]
arguments:
fname       Funciton to be called
rname       Routine to be called
arguments   Routine parameters
examples:
./riris -h iris-server -p SYS -n user rtn ^zcustomtst
set
Set a global
usage: riris set [-H] [value] [gname] [subscripts ...]
arguments:
value       Value
gname       Global name
subscripts  Global subscripts
examples:
./riris -h iris-server -p SYS set 1 ^pTest
./riris -h iris-server -p SYS set 1 ^pTest ciao
get
Get a global
usage: riris get [-H] [-r | -j] [gname] [subscripts ...]
arguments:
gname             Global name
subscripts        Global subscripts
examples:
./riris -h iris-server -p SYS get ^pTest
./riris -h iris-server -p SYS get -r ^pTest
./riris -h iris-server -p SYS get -j ^pTest
./riris -h iris-server -p SYS get ^pTest("1")
kil
Kill a global
usage: riris kil [-H] [gname] [subscripts ...]
arguments:
gname       Global name
subscripts  Global subscripts
examples:
./riris -h iris-server -p SYS kil ^pTest ciao
./riris -h iris-server -p SYS kil ^pTest
cod
Run code in a textfile
usage: riris cod [-H] -U [OS_USERNAME] -P [OS_PASSWORD] [-L] [file]
arguments:
-H, --help                                     Print this help
-U [OS_USERNAME], --os-username [OS_USERNAME]  Remote OS username
-P [OS_PASSWORD], --os-password [OS_PASSWORD]  Remote OS password
-L, --log                                      Log to file
file                                           File with code to be executed
examples:
./riris -h iris-server -p SYS cod -U root -P trakcare -L ./test_code
where test_code contains:
k ^zdbg
s ^zdbg="done with riris code!!!"
w ^zdbg
sql
Run sql code (without jdbc)
usage: riris sql [-H] -U [OS_USERNAME] -P [OS_PASSWORD] [sql ...]
arguments:
-H, --help                                     Print this help
-U [OS_USERNAME], --os-username [OS_USERNAME]  Remote OS username
-P [OS_PASSWORD], --os-password [OS_PASSWORD]  Remote OS password
sql                                            SQL query to be executed
examples:
./riris -h iris-server -p SYS sql -U root -P trakcare ./test_sql
./riris -h iris-server -p SYS sql -U root -P trakcare select * from Config.confg
where test_sql contains:
select * from Config.confg