()
| 3374 | ua = aliased(User, sel.subquery()) |
| 3375 | |
| 3376 | def go(): |
| 3377 | eq_( |
| 3378 | sess.query(ua) |
| 3379 | .options( |
| 3380 | joinedload(ua.orders) |
| 3381 | .joinedload(Order.items) |
| 3382 | .joinedload(Item.keywords) |
| 3383 | ) |
| 3384 | .join(ua.orders) |
| 3385 | .join(Order.items) |
| 3386 | .join(Item.keywords) |
| 3387 | .filter(Keyword.name.in_(["red", "big", "round"])) |
| 3388 | .all(), |
| 3389 | [ |
| 3390 | User( |
| 3391 | name="jack", |
| 3392 | orders=[ |
| 3393 | Order( |
| 3394 | description="order 1", |
| 3395 | items=[ |
| 3396 | Item( |
| 3397 | description="item 1", |
| 3398 | keywords=[ |
| 3399 | Keyword(name="red"), |
| 3400 | Keyword(name="big"), |
| 3401 | Keyword(name="round"), |
| 3402 | ], |
| 3403 | ), |
| 3404 | Item( |
| 3405 | description="item 2", |
| 3406 | keywords=[ |
| 3407 | Keyword(name="red", id=2), |
| 3408 | Keyword(name="small", id=5), |
| 3409 | Keyword(name="square"), |
| 3410 | ], |
| 3411 | ), |
| 3412 | Item( |
| 3413 | description="item 3", |
| 3414 | keywords=[ |
| 3415 | Keyword(name="green", id=3), |
| 3416 | Keyword(name="big", id=4), |
| 3417 | Keyword(name="round", id=6), |
| 3418 | ], |
| 3419 | ), |
| 3420 | ], |
| 3421 | ), |
| 3422 | Order( |
| 3423 | description="order 3", |
| 3424 | items=[ |
| 3425 | Item( |
| 3426 | description="item 3", |
| 3427 | keywords=[ |
| 3428 | Keyword(name="green", id=3), |
| 3429 | Keyword(name="big", id=4), |
| 3430 | Keyword(name="round", id=6), |
| 3431 | ], |
| 3432 | ), |
| 3433 | Item( |
nothing calls this directly
no test coverage detected