Testing INSERT ... RETURNING with executemany() in cx_Oracle

test_cx_ora_ret.py

#!/usr/bin/env python3

import cx_Oracle

def main():

    db = cx_Oracle.connect(dsn="gen3_cred_salnikov")
    cur = db.cursor()

    data = [dict(val1=1, val2=10),
            dict(val1=2, val2=20),
            dict(val1=3, val2=30)]

    IdArr = cur.var(int, arraysize=len(data))
    print(f"IdArr = {IdArr} @{id(IdArr)}")
    cur.setinputsizes(ret_0=IdArr)
    print("pre-execute cursor.bindvars = ", cur.bindvars)
    cur.executemany("insert into test_table_ret (id, val1, val2) "
                    "values (test_table_ret_id_seq.nextval, :val1, :val2) "
                    "returning id into :ret_0", data)

    bindvars = cur.bindvars
    print("post-execute cursor.bindvars = ", bindvars)
    print(f"ret_0 = {bindvars['ret_0']} @{id(bindvars['ret_0'])}")

    for ix, datum in enumerate(data):
        print("Data: " , datum, "ID: ", IdArr.getvalue(ix))

if __name__ == "__main__":
    main()