FYI in python :

import iris

iris.system.Process.SetNamespace("%SYS")

db_ref_list = iris.ref(None)
iris.cls("Config.Databases").DatabasesByServer("", db_ref_list)
db_list = db_ref_list.value

db_names = db_list.split(",")
for db_name in db_names:
    print(db_name)

import iris

GLOBAL_QUEUE = iris.gref("Ens.Queue")

def get_list_host_queue() -> dict:
    dict_queue = {}
    for composed_key, v in GLOBAL_QUEUE.query():
        host = composed_key[0]
        if host not in dict_queue:
            try:
                dict_queue[host] = v if composed_key[2] == 'count' else None
            except IndexError:
                dict_queue[host] = None
    return dict_queue

if __name__ == "__main__":
    print(get_list_host_queue())
    
# {'Ens.Actor': 0, 'Ens.Alarm': 0, 'Ens.ScheduleHandler': 0, 'EnsLib.Testing.Process': 0, 'Python.MyAsyncNGBO': 10, 'Python.MyAsyncNGBP': 0, 'SystemSignal:29404': 0, '_SyncCall:29420': 0}

Try some thing like that

>>> import iris
>>> mirror=iris.cls('SYS.Mirror')
>>> pri_ref = iris.ref(None)
>>> alt_ref = iris.ref(None)
>>> sc=mirror.GetFailoverMemberStatus(pri_ref,alt_ref)
>>> pri_ref.value
>>> alt_ref.value

Something like this should work

Does the 52222 is the superserver port or the webgateway one ?

With native api sdk you must use the superserver port.

Maybe also consider using the community driver for better support of SQL and DB-API spec :

https://github.com/intersystems-community/intersystems-irispython

Your version of numpy is not compatible with python3.9.

Try to reinstall it with irispython :

irispython -m pip install --target C:\InterSystems\IRIS\mgr\python numpy

Hi,

If i remember correctly, the default behavior of the to_sql method is to use a transaction to insert the data.

What i do is using with statement to ensure that the transaction is commited and closed after the insert:

with engine.connect() as conn:
    train_df.to_sql(name='table1', con=conn, if_exists='replace', index=False)

Otherwise, you can commit the transaction manually:

conn = engine.connect()
train_df.to_sql(name='table1', con=conn, if_exists='replace', index=False)
conn.commit()
conn.close()

That's what i do, hope it helps.

Hi @ala zaalouni,

When you encounter this error :

The error appears: "An error has occurred: iris.cls: error finding class"

This usually mean that the Iop framework is not loaded into iris.

pip install iris-pex-embedded-python

you must init it to iris (install the associated classes to iris), for that you must do :

iop --init

or

from iop import Utils
Utils.setup()

please refer to the documentation :

https://github.com/grongierisc/interoperability-embedded-python?tab=readme-ov-file#32-with-pypi

For the more, make sure you are on the right namespace by specifying the var env : $IRISNAMESPACE

I would try something like this :

ClassMethod "test_dict"()
{
    set pythonObj = ##class(%SYS.Python).Bytes("toto")

    set dict = ##class(%SYS.Python).Builtins().dict()
    do dict."__setitem__"("my_bytes", pythonObj)

    w !, dict."__getitem__"("my_bytes")
}

For this given python function :

file name demo.py

def return_tuple():
    return 1, 2, 3

To retrieve the values in ObjectScript, you can use the following code, basically use dunder methods to access the values.

set return = ##class(%SYS.Python).Import("demo")."return_tuple"()
write return."__len__"() // 3
write return."__getitem__"(0) // 1
write return."__getitem__"(1) // 2
write return."__getitem__"(2) // 3