Home Applications riris

riris

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
3.75
2 reviews
0
Awards
160
Views
0
IPM installs
1
1
Details
Releases
Reviews  (2)
Issues
Remote InterSystems IRIS command execution

What's new in this version

Added the readme file

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

Made with
Version
1.0.128 May, 2023
Category
Frameworks
Works with
InterSystems IRISInterSystems IRIS for HealthHealthShare
First published
25 May, 2023
Last checked by moderator
15 Jan, 2024Works