]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Create connection characteristics API; implement postgresql flags
authorMike Bayer <mike_mp@zzzcomputing.com>
Mon, 7 Sep 2020 20:24:47 +0000 (16:24 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Tue, 8 Sep 2020 15:16:53 +0000 (11:16 -0400)
commite3716012c535c0aeac2a8cc5a32609ed2d4197c1
treefb78685f17fd16260487b9036a8c250f7719f667
parent71fa1db1384b437e9d39817f5612f5dca6a28b87
Create connection characteristics API; implement postgresql flags

Added support for PostgreSQL "readonly" and "deferrable" flags for all of
psycopg2, asyncpg and pg8000 dialects.   This takes advantage of a newly
generalized version of the "isolation level" API to support other kinds of
session attributes set via execution options that are reliably reset
when connections are returned to the connection pool.

Fixes: #5549
Change-Id: I0ad6d7a095e49d331618274c40ce75c76afdc7dd
doc/build/changelog/unreleased_14/5549.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/postgresql/asyncpg.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/postgresql/pg8000.py
lib/sqlalchemy/dialects/postgresql/psycopg2.py
lib/sqlalchemy/engine/characteristics.py [new file with mode: 0644]
lib/sqlalchemy/engine/default.py
lib/sqlalchemy/util/__init__.py
lib/sqlalchemy/util/compat.py
test/dialect/postgresql/test_dialect.py
test/engine/test_transaction.py