InterSystems IRIS Python 使用 DB-API连接 ，比odbc简单

1、下载安装驱动

同步的gitee下载地址：：于光/iris-driver-distribution - Gitee.com

pip install intersystems_irispython-version-py3-none-any.whl

 

2、python代码测试

 

import iris as dbapi
conn = dbapi.connect(hostname='127.0.0.1', port=1972, namespace='xxx', username='xx', password='xx')

# Define the SQL query
sql = f"select top 10 * from xx.xx"

try:
    # Create a cursor
    cursor = conn.cursor()

    # Set the arraysize for fetching multiple rows at once
    cursor.arraysize = 20

    # Execute the SQL query
    cursor.execute(sql)

    # Fetch all rows
    rows = cursor.fetchall()

    # Print the rows
    for row in rows:
        print(row)

    # Close the cursor
    cursor.close()

except Exception as e:
    print(f"An error occurred: {e}")

finally:
    # Close the connection
    conn.close()