Add SKIP LOCKED support for Postgresql, Oracle

This adds `SELECT ... FOR UPDATE SKIP LOCKED`/
`SELECT ... FOR SHARE SKIP LOCKED` rendering.

Change-Id: Id1dc4f1cafc1de23f397a6f73d54ab2c58d5910d
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/86

1 files changed, 18 insertions, 0 deletions

diff --git a/test/orm/test_lockmode.py b/test/orm/test_lockmode.py
index fc473a329..949fe0d81 100644
--- a/test/orm/test_lockmode.py
+++ b/test/orm/test_lockmode.py
@@ -181,6 +181,15 @@ class CompileTest(_fixtures.FixtureTest, AssertsCompiledSQL):
             dialect="postgresql"
         )
 
+    def test_postgres_update_skip_locked(self):
+        User = self.classes.User
+        sess = Session()
+        self.assert_compile(sess.query(User.id).
+                with_for_update(skip_locked=True),
+            "SELECT users.id AS users_id FROM users FOR UPDATE SKIP LOCKED",
+            dialect="postgresql"
+        )
+
 
     def test_oracle_update(self):
         User = self.classes.User
@@ -190,6 +199,15 @@ class CompileTest(_fixtures.FixtureTest, AssertsCompiledSQL):
             dialect="oracle"
         )
 
+    def test_oracle_update_skip_locked(self):
+        User = self.classes.User
+        sess = Session()
+        self.assert_compile(sess.query(User.id)
+                .with_for_update(skip_locked=True),
+            "SELECT users.id AS users_id FROM users FOR UPDATE SKIP LOCKED",
+            dialect="oracle"
+        )
+
     def test_mysql_read(self):
         User = self.classes.User
         sess = Session()