diff options
| author | Federico Caselli <cfederico87@gmail.com> | 2021-08-31 23:03:18 +0200 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2021-09-17 18:08:42 -0400 |
| commit | 26140c08111da9833dd2eff0b5091494f253db46 (patch) | |
| tree | 61a64b7361ab0890521771a5d185db787482eaaf /test/dialect/postgresql | |
| parent | 204fe7ea206a1b0ab4ae248006f99afd15fa7f72 (diff) | |
| download | sqlalchemy-26140c08111da9833dd2eff0b5091494f253db46.tar.gz | |
Surface driver connection object when using a proxied dialect
Improve the interface used by adapted drivers, like the asyncio ones,
to access the actual connection object returned by the driver.
The :class:`_engine._ConnectionRecord` and
:class:`_engine._ConnectionFairy` now have two new attributes:
* ``dbapi_connection`` always represents a DBAPI compatible
object. For pep-249 drivers, this is the DBAPI connection as it always
has been, previously accessed under the ``.connection`` attribute.
For asyncio drivers that SQLAlchemy adapts into a pep-249 interface,
the returned object will normally be a SQLAlchemy adaption object
called :class:`_engine.AdaptedConnection`.
* ``driver_connection`` always represents the actual connection object
maintained by the third party pep-249 DBAPI or async driver in use.
For standard pep-249 DBAPIs, this will always be the same object
as that of the ``dbapi_connection``. For an asyncio driver, it will be
the underlying asyncio-only connection object.
The ``.connection`` attribute remains available and is now a legacy alias
of ``.dbapi_connection``.
Fixes: #6832
Change-Id: Ib72f97deefca96dce4e61e7c38ba430068d6a82e
Diffstat (limited to 'test/dialect/postgresql')
| -rw-r--r-- | test/dialect/postgresql/test_dialect.py | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/test/dialect/postgresql/test_dialect.py b/test/dialect/postgresql/test_dialect.py index a86da8ce7..155019aae 100644 --- a/test/dialect/postgresql/test_dialect.py +++ b/test/dialect/postgresql/test_dialect.py @@ -906,7 +906,7 @@ class MiscBackendTest( with testing.db.connect().execution_options( isolation_level="SERIALIZABLE" ) as conn: - dbapi_conn = conn.connection.connection + dbapi_conn = conn.connection.dbapi_connection is_false(dbapi_conn.autocommit) @@ -959,7 +959,7 @@ class MiscBackendTest( conn.execute(text("select 1")).scalar() - dbapi_conn = conn.connection.connection + dbapi_conn = conn.connection.dbapi_connection cursor = dbapi_conn.cursor() cursor.execute("show transaction_read_only") @@ -994,7 +994,7 @@ class MiscBackendTest( conn.execute(text("Select 1")).scalar() - dbapi_conn = conn.connection.connection + dbapi_conn = conn.connection.dbapi_connection cursor = dbapi_conn.cursor() cursor.execute("show transaction_deferrable") @@ -1026,7 +1026,7 @@ class MiscBackendTest( with engine.connect() as conn: conn.execute(text("select 1")).scalar() - dbapi_conn = conn.connection.connection + dbapi_conn = conn.connection.dbapi_connection cursor = dbapi_conn.cursor() cursor.execute("show transaction_read_only") @@ -1056,7 +1056,7 @@ class MiscBackendTest( with engine.connect() as conn: # asyncpg but not for deferrable? which the PG docs actually # state. weird - dbapi_conn = conn.connection.connection + dbapi_conn = conn.connection.dbapi_connection cursor = dbapi_conn.cursor() cursor.execute("show transaction_deferrable") |