Function createWhereTests

packages/db/tests/query/where.test.ts:235–1795

(autoIndex: `off` | `eager`)

}

function createWhereTests(autoIndex: `off` | `eager`): void {
  describe(`with autoIndex ${autoIndex}`, () => {
    describe(`Comparison Operators`, () => {
      let employeesCollection: ReturnType<typeof createEmployeesCollection>

      beforeEach(() => {
        employeesCollection = createEmployeesCollection(autoIndex)
      })

      test(`eq operator - equality comparison`, () => {
        const hireDateEmployee = createLiveQueryCollection({
          startSync: true,
          query: (q) =>
            q
              .from({ emp: employeesCollection })
              .where(({ emp }) => eq(emp.hire_date, new Date(`2020-01-15`)))
              .select(({ emp }) => ({
                id: emp.id,
                name: emp.name,
                active: emp.active,
                hire_date: emp.hire_date,
              })),
        })
        for (const emp of hireDateEmployee.toArray) {
          expect(emp.hire_date).toStrictEqual(new Date(`2020-01-15`))
        }
        expect(hireDateEmployee.size).toBe(2)

        const activeEmployees = createLiveQueryCollection({
          startSync: true,
          query: (q) =>
            q
              .from({ emp: employeesCollection })
              .where(({ emp }) => eq(emp.active, true))
              .select(({ emp }) => ({
                id: emp.id,
                name: emp.name,
                active: emp.active,
              })),
        })

        expect(activeEmployees.size).toBe(4) // Alice, Bob, Diana, Eve
        expect(activeEmployees.toArray.every((emp) => emp.active)).toBe(true)

        // Test with number equality
        const specificEmployee = createLiveQueryCollection({
          startSync: true,
          query: (q) =>
            q
              .from({ emp: employeesCollection })
              .where(({ emp }) => eq(emp.id, 1))
              .select(({ emp }) => ({ id: emp.id, name: emp.name })),
        })

        expect(specificEmployee.size).toBe(1)
        expect(specificEmployee.get(1)?.name).toBe(`Alice Johnson`)

        // Test live updates