diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2023-03-21 14:43:46 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2023-03-21 14:43:46 -0400 |
| commit | ce4e1770f01a6c19d3a55621529e3f98607d7824 (patch) | |
| tree | d0a9891cf8524561da3e8c29fc19895ec2a86055 /examples/nested_sets | |
| parent | 42b3b80fae8d7b808125efc1dd9a900231c2ed21 (diff) | |
| download | sqlalchemy-ce4e1770f01a6c19d3a55621529e3f98607d7824.tar.gz | |
fix update in nested_sets example
Fixes: #9520
Change-Id: I3dbf62bd9b70fb226cf7c641719df8ac53ec1427
Diffstat (limited to 'examples/nested_sets')
| -rw-r--r-- | examples/nested_sets/nested_sets.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/examples/nested_sets/nested_sets.py b/examples/nested_sets/nested_sets.py index 2412eaf9e..1492f6abd 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, |