Function buildToArrayToArrayQuery

packages/db/tests/query/includes.test.ts:1933–1958

()

  describe(`nested includes: toArray → toArray`, () => {
    function buildToArrayToArrayQuery() {
      return createLiveQueryCollection((q) =>
        q.from({ p: projects }).select(({ p }) => ({
          id: p.id,
          name: p.name,
          issues: toArray(
            q
              .from({ i: issues })
              .where(({ i }) => eq(i.projectId, p.id))
              .select(({ i }) => ({
                id: i.id,
                title: i.title,
                comments: toArray(
                  q
                    .from({ c: comments })
                    .where(({ c }) => eq(c.issueId, i.id))
                    .select(({ c }) => ({
                      id: c.id,
                      body: c.body,
                    })),
                ),
              })),
          ),
        })),
      )
    }

    it(`initial load: both levels are arrays`, async () => {
      const collection = buildToArrayToArrayQuery()