Sequelize - 使用 es6 和模块运行迁移

我不确定我是否做错了什么或者什么。我觉得我正在运行一个现代的、相当常见的堆栈。但我无法让新的 Sequelize v6 与我的设置完美配合。我在 Node v14.17、Sequelize v6.6.2 上，在我的 package.json 中"type": "module"。经过大量的谷歌搜索和修改，我终于弄清楚了如何自动导入我的模型。所以现在我尝试使用迁移工具向模型添加字段。我在迁移文件夹中创建了迁移文件。
看起来像这样：

'use strict';

module.exports = {
    up: async (queryInterface, Sequelize) => {
        /**
         * Add altering commands here.
         *
         * Example:
         * await queryInterface.createTable('users', { id: Sequelize.INTEGER });
         */
        return Promise.all([
            queryInterface.addColumn(
                'Customers', // table name
                'include_core_items', // new field name
                {
                    type: Sequelize.Boolean,
                    allowNull: false,
                    defaultValue: true,
                    after: 'customer_name',
                }
            ),
        ]);
    },

    down: async (queryInterface, Sequelize) => {
        /**
         * Add reverting commands here.
         *
         * Example:
         * await queryInterface.dropTable('users');
         */
        return Promise.all([
            queryInterface.removeColumn('Customers', 'include_core_items'),
        ]);
    },
};

然后我尝试使用以下命令运行迁移：npx sequelize-cli db:migrate我收到以下错误：ERROR: Error reading "config\config.js". Error: Error [ERR_REQUIRE_ESM]: Must use import to load ES Module: C:\...\config\config.js require() of ES modules is not supported. require() of C:\...\config\config.js from C:\Users\...\AppData\Roaming\npm-cache\_npx\12576\node_modules\sequelize-cli\lib\helpers\config-helper.js is an ES module file as it is a .js file whose nearest pare nt package.json contains "type": "module" which defines all .js files in that package scope as ES modules. Instead rename config.js to end in .cjs, change the requiring code to use import(), or remove "type": "module" from C:\...\package.json.

我尝试将配置重命名为 .cjs，然后收到错误：ERROR: Dialect needs to be explicitly supplied as of v4.0.0所以我认为它没有正确读取 ENV 变量或其他内容。

配置.[c]js

// seed command: sequelize seed:create --name PermissionData
// import dotenv from 'dotenv';
// dotenv.config();

import 'dotenv/config.js';

const username = process.env.NAME;
const password = process.env.PASSWORD;
const database = process.env.DATABASE;
const host = process.env.HOST;
const port = process.env.DB_PORT;
const dialect = process.env.DIALECT;
const node_env = process.env.NODE_ENV;
const session_secret = process.env.SESSION_SECRET;
const base_url = process.env.BASE_URL;
const client_url = process.env.CLIENT_APP_LOC;
const secure_cookie = process.env.SECURE_COOKIE;

const config = {
    dev: {
        username,
        password,
        database,
        host,
        port,
        dialect,
        logging: true,
        session_secret,
        base_url,
        client_url,
        secure_cookie,
    },
    testing: {
        username,
        password,
        database,
        host,
        port,
        dialect,
        logging: true,
        session_secret,
        base_url,
        client_url,
        secure_cookie,
    },
    production: {
        username,
        password,
        database,
        host,
        port,
        dialect,
        logging: true,
        session_secret,
        base_url,
        client_url,
        secure_cookie,
    },
};

export default config[node_env];

我最近在尝试运行迁移时遇到了同样的问题。我使用来自的帮助解决了这个问题the docs https://sequelize.org/master/manual/migrations.html#using-babel.

Note:我正在使用节点 v15.0.0

如果您使用 babel，请安装 babel-register 包

npm i --save-dev babel-register

编辑你的.sequelizerc文件包含包导入

require("babel-register");

const path = require('path');

module.exports = {
  'config': path.resolve('config', 'config.json'),
  'models-path': path.resolve('models'),
  'seeders-path': path.resolve('seeders'),
  'migrations-path': path.resolve('migrations')
}

在你的两个.sequelizerc and config.js去掉es6的痕迹，改用普通js（require）进行导入导出。