(db: Kysely<Database>)
| 413 | } |
| 414 | |
| 415 | async function testManyNestedSubqueries(db: Kysely<Database>) { |
| 416 | const r = await db |
| 417 | .selectFrom('person as p1') |
| 418 | .select((eb1) => [ |
| 419 | 'p1.id', |
| 420 | jsonArrayFrom( |
| 421 | eb1 |
| 422 | .selectFrom('pet as pet1') |
| 423 | .whereRef('pet1.owner_id', '=', 'p1.id') |
| 424 | .select((eb2) => [ |
| 425 | 'pet1.id', |
| 426 | jsonObjectFrom( |
| 427 | eb2 |
| 428 | .selectFrom('person as p2') |
| 429 | .whereRef('p2.id', '=', 'pet1.owner_id') |
| 430 | .select((eb3) => [ |
| 431 | 'p2.id', |
| 432 | jsonArrayFrom( |
| 433 | eb3 |
| 434 | .selectFrom('pet as pet2') |
| 435 | .whereRef('pet2.owner_id', '=', 'p2.id') |
| 436 | .select((eb4) => [ |
| 437 | 'pet2.id', |
| 438 | jsonObjectFrom( |
| 439 | eb4 |
| 440 | .selectFrom('person as p3') |
| 441 | .whereRef('p3.id', '=', 'pet2.owner_id') |
| 442 | .select((eb5) => [ |
| 443 | 'p3.id', |
| 444 | jsonArrayFrom( |
| 445 | eb5 |
| 446 | .selectFrom('pet as pet3') |
| 447 | .whereRef('pet3.owner_id', '=', 'p3.id') |
| 448 | .select((eb6) => [ |
| 449 | 'pet3.id', |
| 450 | jsonObjectFrom( |
| 451 | eb6 |
| 452 | .selectFrom('person as p4') |
| 453 | .whereRef('p4.id', '=', 'pet3.owner_id') |
| 454 | .select((eb7) => [ |
| 455 | 'p4.id', |
| 456 | jsonArrayFrom( |
| 457 | eb7 |
| 458 | .selectFrom('pet as pet4') |
| 459 | .whereRef( |
| 460 | 'pet4.owner_id', |
| 461 | '=', |
| 462 | 'p4.id', |
| 463 | ) |
| 464 | .select((eb8) => [ |
| 465 | 'pet4.id', |
| 466 | jsonObjectFrom( |
| 467 | eb8 |
| 468 | .selectFrom('person as p5') |
| 469 | .whereRef( |
| 470 | 'p5.id', |
| 471 | '=', |
| 472 | 'pet4.owner_id', |
nothing calls this directly
no test coverage detected
searching dependent graphs…