如何使用jest和sequelize-typescript对数据库调用进行单元测试

npm install --save-dev jest sequelize sequelize-typescript

import { Sequelize } from 'sequelize-typescript';
import { User } from './models/User'; // 假设我们有一个名为User的模型

describe('Database Tests', () => {
  let sequelize: Sequelize;

  beforeAll(() => {
    sequelize = new Sequelize({
      dialect: 'mysql', // 数据库类型，这里以MySQL为例
      host: 'localhost',
      port: 3306,
      username: 'your_username',
      password: 'your_password',
      database: 'your_database',
    });

    sequelize.addModels([User]); // 添加模型到Sequelize实例中
  });

  afterAll(async () => {
    await sequelize.close(); // 关闭数据库连接
  });

  beforeEach(async () => {
    await User.sync({ force: true }); // 每个测试用例执行前，先清空User表
  });

  it('should create a new user', async () => {
    const user = await User.create({
      name: 'John Doe',
      email: 'john@example.com',
    });

    expect(user.id).toBeDefined(); // 断言用户ID已定义
    expect(user.name).toBe('John Doe'); // 断言用户名正确
    expect(user.email).toBe('john@example.com'); // 断言用户邮箱正确
  });

  it('should retrieve an existing user', async () => {
    const existingUser = await User.create({
      name: 'Jane Smith',
      email: 'jane@example.com',
    });

    const retrievedUser = await User.findOne({
      where: { id: existingUser.id },
    });

    expect(retrievedUser).toBeDefined(); // 断言已检索到用户
    expect(retrievedUser.name).toBe('Jane Smith'); // 断言用户名正确
    expect(retrievedUser.email).toBe('jane@example.com'); // 断言用户邮箱正确
  });
});

{
  "scripts": {
    "test": "jest"
  },
  "jest": {
    "testEnvironment": "node"
  }
}

npm test