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()