Call oracledb Connection.gettype from SQLAlchemy.AssyncSession

Question

Have an async connection pool in FastApi application. Using python-oracledb async connection pool (thin mode).

Trying to call Connection.gettype(name)

(await (await session.connection()).get_raw_connection()).cursor() have no attribute connection

await session.connection() and await (await session.connection()).get_raw_connection() have no attribute gettype

So how can I get user defined DbObjectType

In cx_Oracle connection's cursor I call this

    # cursor: Connection cursor
    # data: list):
    my_type = cursor.get_connection().gettype('MY_SCHEMA.MY_TYPE_ARRAY').newobject()
    my_type.extend(data)

Since you tagged this with python-oracledb, hopefully the reference to the obsolete cx_Oracle driver in the question was a typo. — Christopher Jones, Commented Apr 3 at 21:15
before i used cx_Oracle and in question is example from old code with cx_Oracle. Question is for asynchronous oracledb driver (thin mode connection). — Kamo Petrosyan, Commented Apr 4 at 5:27

Kamo Petrosyan · Accepted Answer · 2025-04-03 13:10:33Z

0

DBAPICursor has (protected) _connection attrubute

cursor = (await (await session.connection()).get_raw_connection()).cursor()
obj_type = (
    await (
        await session.cursor()
    )._connection.gettype("MY_SCHEMA.MY_TYPE_ARRAY")
).newobject()

answered Apr 3 at 13:10

Kamo Petrosyan

2441 silver badge10 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Call oracledb Connection.gettype from SQLAlchemy.AssyncSession

1 Answer 1

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Related