From e8dfefb97cd43bc03d202872b99931f61324fe80 Mon Sep 17 00:00:00 2001 From: BOBOTANG Date: Thu, 5 Sep 2024 02:26:52 +0800 Subject: [PATCH] Fix the runtime issue related to the join operation in the association example (#11721) --- examples/association/basic_association.py | 2 +- examples/association/proxied_association.py | 3 ++- 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/examples/association/basic_association.py b/examples/association/basic_association.py index d2271ad430..7a5b46097e 100644 --- a/examples/association/basic_association.py +++ b/examples/association/basic_association.py @@ -105,7 +105,7 @@ if __name__ == "__main__": ) # print customers who bought 'MySQL Crowbar' on sale - q = session.query(Order).join("order_items", "item") + q = session.query(Order).join(OrderItem).join(Item) q = q.filter( and_(Item.description == "MySQL Crowbar", Item.price > OrderItem.price) ) diff --git a/examples/association/proxied_association.py b/examples/association/proxied_association.py index 0ec8fa899a..65dcd6c0b6 100644 --- a/examples/association/proxied_association.py +++ b/examples/association/proxied_association.py @@ -112,7 +112,8 @@ if __name__ == "__main__": # print customers who bought 'MySQL Crowbar' on sale orders = ( session.query(Order) - .join("order_items", "item") + .join(OrderItem) + .join(Item) .filter(Item.description == "MySQL Crowbar") .filter(Item.price > OrderItem.price) ) -- 2.47.2