如何使用jest模拟Knex

npm install jest knex

const knex = require('knex');
const myCode = require('./myCode');

const mockKnex = jest.fn(() => ({
  // 模拟的Knex方法
  // ...
}));

myCode.setKnex(mockKnex); // 传递模拟的Knex实例

function getUsers() {
  return knex('users').select('*');
}

module.exports = { getUsers };

test('should get users', async () => {
  const expectedUsers = [{ id: 1, name: 'John' }];

  // 模拟Knex方法的返回值
  mockKnex.mockReturnValue({
    select: jest.fn().mockResolvedValue(expectedUsers),
  });

  const result = await myCode.getUsers();

  expect(result).toEqual(expectedUsers);
  expect(mockKnex).toHaveBeenCalledTimes(1);
  expect(mockKnex().select).toHaveBeenCalledWith('*');
});