Function buildNestedAggregateToArrayQuery

packages/db/tests/query/includes.test.ts:4036–4056

()

    describe(`nested aggregate: count comments per issue (as toArray)`, () => {
      function buildNestedAggregateToArrayQuery() {
        return createLiveQueryCollection((q) =>
          q.from({ p: projects }).select(({ p }) => ({
            id: p.id,
            name: p.name,
            issues: q
              .from({ i: issues })
              .where(({ i }) => eq(i.projectId, p.id))
              .select(({ i }) => ({
                id: i.id,
                title: i.title,
                commentCount: toArray(
                  q
                    .from({ c: comments })
                    .where(({ c }) => eq(c.issueId, i.id))
                    .select(({ c }) => ({ total: count(c.id) })),
                ),
              })),
          })),
        )
      }

      it(`each issue gets its own comment count as an array`, async () => {
        const collection = buildNestedAggregateToArrayQuery()