diff options
| author | Sergey Skopin <sa.skopin@gmail.com> | 2016-05-31 10:02:08 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-06-08 11:24:57 -0400 |
| commit | 3ebd1b30eb392ff62f08f0755e79a228d61ba7d2 (patch) | |
| tree | 931e6f3aca0c73a3bc0664e69b2446ac110bf045 /lib/sqlalchemy/dialects | |
| parent | a90b0101aaf616cddb8bc675f4a221fe7de6c420 (diff) | |
| download | sqlalchemy-3ebd1b30eb392ff62f08f0755e79a228d61ba7d2.tar.gz | |
Add 'FOR NO KEY UPDATE' / 'FOR KEY SHARE' support for Postgresql
Adds ``key_share=True`` for with_for_update().
Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Change-Id: I74e0c3fcbc023e1dc98a1fa0c7db67b4c3693a31
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/279
Diffstat (limited to 'lib/sqlalchemy/dialects')
| -rw-r--r-- | lib/sqlalchemy/dialects/postgresql/base.py | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 2356458b9..d613aac92 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -1170,7 +1170,12 @@ class PGCompiler(compiler.SQLCompiler): def for_update_clause(self, select, **kw): if select._for_update_arg.read: - tmp = " FOR SHARE" + if select._for_update_arg.key_share: + tmp = " FOR KEY SHARE" + else: + tmp = " FOR SHARE" + elif select._for_update_arg.key_share: + tmp = " FOR NO KEY UPDATE" else: tmp = " FOR UPDATE" |