Function buildSingletonQuery

packages/db/tests/query/includes.test.ts:6523–6540

()

    // For singleton behavior we look up each issue's parent project.
    // Each issue references exactly one project via projectId.
    function buildSingletonQuery() {
      return createLiveQueryCollection((q) =>
        q.from({ i: issues }).select(({ i }) => ({
          id: i.id,
          title: i.title,
          project: materialize(
            q
              .from({ p: projects })
              .where(({ p }) => eq(p.id, i.projectId))
              .select(({ p }) => ({
                id: p.id,
                name: p.name,
              }))
              .findOne(),
          ),
        })),
      )
    }

    it(`findOne() materializes a single value, not an array`, async () => {
      const collection = buildSingletonQuery()