Nestjs 中的 Sequelize 和 TypeScript 集成出错

使用 Nestjs 框架进行开发可以让我们更加高效地构建可扩展的服务器端应用程序。而 Sequelize 是一个功能强大的 ORM（对象关系映射）库，能够帮助我们在 Node.js 中轻松地操作数据库。本文将介绍在 Nestjs 中集成 Sequelize 和 TypeScript 时可能出现的问题，并提供解决方案。

bash
npm install --save @nestjs/sequelize sequelize sequelize-typescript mysql2

typescript
import { SequelizeModule } from '@nestjs/sequelize';
import { ConfigModule, ConfigService } from '@nestjs/config';
@Module({
  imports: [
    SequelizeModule.forRootAsync({
      imports: [ConfigModule],
      useFactory: async (configService: ConfigService) => ({
        dialect: 'mysql',
        host: configService.get('DB_HOST'),
        port: configService.get('DB_PORT'),
        username: configService.get('DB_USERNAME'),
        password: configService.get('DB_PASSWORD'),
        database: configService.get('DB_DATABASE'),
        autoLoadModels: true,
        synchronize: true,
      }),
      inject: [ConfigService],
    }),
  ],
})
export class AppModule {}

typescript
import { Model, Column, Table } from 'sequelize-typescript';
@Table
export class User extends Model {
  @Column
  name: string;
  @Column
  email: string;
  @Column
  age: number;
}

typescript
import { Controller, Get } from '@nestjs/common';
import { InjectModel } from '@nestjs/sequelize';
import { User } from './user.model';
@Controller('users')
export class UserController {
  constructor(
    @InjectModel(User)
    private readonly userModel: typeof User,
  ) {}
  @Get()
  async findAll(): Promise {
    return this.userModel.findAll();
  }
}