Function buildAggregateQuery

packages/db/tests/query/includes.test.ts:3871–3882

()

  describe(`aggregates in child queries`, () => {
    describe(`single-group aggregate: count issues per project (as Collection)`, () => {
      function buildAggregateQuery() {
        return createLiveQueryCollection((q) =>
          q.from({ p: projects }).select(({ p }) => ({
            id: p.id,
            name: p.name,
            issueCount: q
              .from({ i: issues })
              .where(({ i }) => eq(i.projectId, p.id))
              .select(({ i }) => ({ total: count(i.id) })),
          })),
        )
      }

      it(`each project gets its own aggregate result`, async () => {
        const collection = buildAggregateQuery()