From eefc8c985400cd458e561d61299a2b81bdff1189 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 19 Jul 2022 11:13:59 -0400 Subject: [PATCH] render all three elements selected in bundle example Fixes: #8013 Change-Id: I9b5f800d94abd80d07ca5f58c24f111618415674 --- doc/build/orm/queryguide.rst | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) diff --git a/doc/build/orm/queryguide.rst b/doc/build/orm/queryguide.rst index 22edad3742..8de7ed2a3c 100644 --- a/doc/build/orm/queryguide.rst +++ b/doc/build/orm/queryguide.rst @@ -257,16 +257,15 @@ allows sets of column expressions to be grouped in result rows:: ... Bundle("email", Address.email_address) ... ).join_from(User, Address) {sql}>>> for row in session.execute(stmt): - ... print(f"{row.user.name} {row.email.email_address}") + ... print(f"{row.user.name} {row.user.fullname} {row.email.email_address}") SELECT user_account.name, user_account.fullname, address.email_address FROM user_account JOIN address ON user_account.id = address.user_id [...] (){stop} - spongebob spongebob@sqlalchemy.org - sandy sandy@sqlalchemy.org - sandy squirrel@squirrelpower.org - patrick pat999@aol.com - squidward stentcl@sqlalchemy.org - + spongebob Spongebob Squarepants spongebob@sqlalchemy.org + sandy Sandy Cheeks sandy@sqlalchemy.org + sandy Sandy Cheeks squirrel@squirrelpower.org + patrick Patrick Star pat999@aol.com + squidward Squidward Tentacles stentcl@sqlalchemy.org The :class:`_orm.Bundle` is potentially useful for creating lightweight views as well as custom column groupings such as mappings. -- 2.47.2