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