Function createBasicTests

packages/db/tests/query/basic.test.ts:109–1075

(autoIndex: `off` | `eager`)

}

function createBasicTests(autoIndex: `off` | `eager`) {
  describe(`with autoIndex ${autoIndex}`, () => {
    let usersCollection: ReturnType<typeof createUsersCollection>

    beforeEach(() => {
      usersCollection = createUsersCollection(autoIndex)
    })

    test(`should create, update and delete a live query collection with config`, () => {
      const liveCollection = createLiveQueryCollection({
        startSync: true,
        query: (q) =>
          q.from({ user: usersCollection }).select(({ user }) => ({
            id: user.id,
            name: user.name,
            age: user.age,
            email: user.email,
            active: user.active,
          })),
      })

      const results = liveCollection.toArray

      expect(results).toHaveLength(4)
      expect(results.map((u) => u.name)).toEqual(
        expect.arrayContaining([`Alice`, `Bob`, `Charlie`, `Dave`]),
      )

      // Insert a new user
      const newUser = {
        id: 5,
        name: `Eve`,
        age: 28,
        email: `eve@example.com`,
        active: true,
      }
      usersCollection.utils.begin()
      usersCollection.utils.write({
        type: `insert`,
        value: newUser,
      })
      usersCollection.utils.commit()

      expect(liveCollection.size).toBe(5)
      expect(liveCollection.get(5)).toMatchObject(newUser)

      // Update the new user
      const updatedUser = { ...newUser, name: `Eve Updated` }
      usersCollection.utils.begin()
      usersCollection.utils.write({
        type: `update`,
        value: updatedUser,
      })
      usersCollection.utils.commit()

      expect(liveCollection.size).toBe(5)
      expect(liveCollection.get(5)).toMatchObject(updatedUser)