TypeScript环境下运行Sequelize种子器与迁移文件报错求助

1. 配置文件与.sequelizerc正确设置 #

• 确保Sequelize配置文件（如config/config.ts）为TypeScript格式，显式指定dialect：

  import { Options } from 'sequelize';
  
  const config: Options = {
    username: process.env.DB_USER || 'postgres',
    password: process.env.DB_PASSWORD || 'password',
    database: process.env.DB_NAME || 'mydb',
    host: process.env.DB_HOST || 'localhost',
    dialect: 'postgres', // 必须显式指定，禁止依赖自动推断
    port: parseInt(process.env.DB_PORT || '5432'),
  };
  
  export default config;
  

• 修改.sequelizerc指向TypeScript源文件，避免编译后路径问题：

  const path = require('path');
  
  module.exports = {
    config: path.resolve(__dirname, 'config', 'config.ts'),
    'models-path': path.resolve(__dirname, 'src', 'models'),
    'seeders-path': path.resolve(__dirname, 'src', 'seeders'),
    'migrations-path': path.resolve(__dirname, 'src', 'migrations'),
  };
  

2. 调整package.json命令 #

用ts-node直接运行Sequelize CLI，跳过编译步骤：

{
  "scripts": {
    "migrate": "ts-node ./node_modules/sequelize-cli/lib/sequelize db:migrate",
    "apply-seeders": "ts-node ./node_modules/sequelize-cli/lib/sequelize db:seed:all",
    "undo-migrate": "ts-node ./node_modules/sequelize-cli/lib/sequelize db:migrate:undo",
    "undo-seeders": "ts-node ./node_modules/sequelize-cli/lib/sequelize db:seed:undo:all"
  }
}

• 安装必要开发依赖：

  npm install --save-dev ts-node typescript
  

3. 种子器与迁移文件的TypeScript规范写法 #

种子器示例（src/seeders/20240520120000-demo-user.ts）：

import { QueryInterface } from 'sequelize';

export async function up(queryInterface: QueryInterface) {
  await queryInterface.bulkInsert('Users', [
    {
      username: 'demo',
      email: 'demo@example.com',
      createdAt: new Date(),
      updatedAt: new Date(),
    },
  ]);
}

export async function down(queryInterface: QueryInterface) {
  await queryInterface.bulkDelete('Users', { username: 'demo' });
}

4. 解决dialect缺失问题 #

• 安装对应数据库驱动（以PostgreSQL为例）：

  npm install pg pg-hstore
  

• 确保配置文件中dialect为字符串字面量，避免动态值导致编译后解析异常。

5. 清理不必要依赖 #

改用ts-node运行源文件后，可卸载引发错误的babel相关依赖（无其他用途时）：

npm uninstall babel-plugin-module-resolver

内容的提问来源于stack exchange，提问作者PirateApp