umzug down方法未运行

Question

我正在尝试使用umzug/sequelize，但是我根本不能运行down方法。我正在关注这个tutorial。我想基本上用up和down方法创建迁移文件。up方法可以成功执行，但调用down根本不会执行所有umzug.down()方法。

"use strict";
const Promise = require("bluebird");
const sqlite3 = require("sqlite3");
const path = require('path');

module.exports = {
    up: function() {
        return new Promise(function(resolve, reject) {
        /* up is to commit migrations to the database */

        let db = new sqlite3.Database('./database/db.db');

        db.run(`PRAGMA foreign_keys = ON`);


        db.serialize(function() {
            db.run(`CREATE TABLE users (
            id INTEGER PRIMARY KEY,
            name TEXT
            )`);


        });
        db.close();
        });
    },


    down: function() {
        return new Promise(function(resolve, reject) {
        /* roll back database changes made by this migration */
        console.log('in down')
        let db = new sqlite3.Database("./database/db.db");
        db.serialize(function() {

            db.run(`DROP TABLE users`);
        });
        db.close();
        });
    }
};

我的迁移文件也如下所示：

const path = require("path");
const Umzug = require("umzug");

let umzug = new Umzug({
  logging: function() {
    console.log.apply(null, arguments);
  },
  migrations: {
    path: "./database/migrations",
    pattern: /\.js$/
  },
  upName: "up",
  downName: "down"
});

const cmd = process.argv[2].trim();

// this will run your migrations
if(cmd=='up')
{
    umzug.up().then(console.log("Migrations committed"));
}
else if (cmd=='down'){
    umzug.down().then(console.log("Migrations revereted"));
}

当我执行node migrate.js up时，它起作用了。但是down永远不会被执行。我是不是遗漏了什么？

Answer 1

在某些情况下，您将需要对您的up和down函数的Promise调用resolve()或reject()。