[SQL-CVS] r1950 - SQLObject/trunk/sqlobject

[<sub...@co...>]

Author: phd
Date: 2006-09-26 06:30:07 -0600 (Tue, 26 Sep 2006)
New Revision: 1950

Modified:
   SQLObject/trunk/sqlobject/dbconnection.py
Log:
"FOR UPDATE" should go after limit/offset.


Modified: SQLObject/trunk/sqlobject/dbconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/dbconnection.py	2006-09-26 12:21:09 UTC (rev 1949)
+++ SQLObject/trunk/sqlobject/dbconnection.py	2006-09-26 12:30:07 UTC (rev 1950)
@@ -505,15 +505,15 @@
 
         q = startSelect + ' ' + q
 
-        if ops.get('forUpdate'):
-            q += " FOR UPDATE";
-
         if limit and (start or end):
             # @@: Raising an error might be an annoyance, but some warning is
             # in order.
             #assert ops.get('orderBy'), "Getting a slice of an unordered set is unpredictable!"
             q = self._queryAddLimitOffset(q, start, end)
 
+        if ops.get('forUpdate'):
+            q += " FOR UPDATE";
+
         return q
 
     def _SO_createJoinTable(self, join):