Function buildCollectionToArrayQuery

packages/db/tests/query/includes.test.ts:1530–1553

()

  describe(`nested includes: Collection → toArray`, () => {
    function buildCollectionToArrayQuery() {
      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,
              comments: toArray(
                q
                  .from({ c: comments })
                  .where(({ c }) => eq(c.issueId, i.id))
                  .select(({ c }) => ({
                    id: c.id,
                    body: c.body,
                  })),
              ),
            })),
        })),
      )
    }

    it(`initial load: issues are Collections, comments are arrays`, async () => {
      const collection = buildCollectionToArrayQuery()