]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Implement autocommit isolation level for cx_oracle
authorGord Thompson <gord@gordthompson.com>
Thu, 12 Mar 2020 18:54:37 +0000 (12:54 -0600)
committerMike Bayer <mike_mp@zzzcomputing.com>
Mon, 23 Mar 2020 15:56:53 +0000 (11:56 -0400)
commit24e87a74ebd428b8b3aafb785fa052c0f5b13616
tree7647127fc312198bd701611d365e99edf60a3ae2
parent84c89f781a8abb608d9e4cb0d9e00e2221fcc093
Implement autocommit isolation level for cx_oracle

As part of this change Oracle also gets the concept of a
default isolation level, however since Oracle does not provide a
fixed method of knowing what the isolation level would be without a
server side transaction actually in progress, for now we hardcode
just to "READ COMMITTED".

Enhanced the test suite for isolation level testing in the dialect
test suite and added features to requirements so that the supported
isolation levels can be reported generically for dialects.

Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Fixes: #5200
Change-Id: I2c4d49da9ff80ccc228c21e196ec9a961de53478
(cherry picked from commit 1afca5823efe22c0f8cbc01455bafc573254ab55)
doc/build/changelog/unreleased_13/5200.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/oracle/base.py
lib/sqlalchemy/dialects/oracle/cx_oracle.py
lib/sqlalchemy/testing/requirements.py
lib/sqlalchemy/testing/suite/test_dialect.py
test/engine/test_transaction.py
test/requirements.py