From ce4e1770f01a6c19d3a55621529e3f98607d7824 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 21 Mar 2023 14:43:46 -0400 Subject: [PATCH] fix update in nested_sets example Fixes: #9520 Change-Id: I3dbf62bd9b70fb226cf7c641719df8ac53ec1427 --- examples/nested_sets/nested_sets.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/examples/nested_sets/nested_sets.py b/examples/nested_sets/nested_sets.py index 2412eaf9ec..1492f6abd8 100644 --- a/examples/nested_sets/nested_sets.py +++ b/examples/nested_sets/nested_sets.py @@ -52,7 +52,9 @@ def before_insert(mapper, connection, instance): ) connection.execute( - personnel.update(personnel.c.rgt >= right_most_sibling).values( + personnel.update() + .where(personnel.c.rgt >= right_most_sibling) + .values( lft=case( ( personnel.c.lft > right_most_sibling, -- 2.47.2