mysql - 在 sequelize.athenticate() 上使用 await 时，Node.js 脚本不会结束

Question

这是我用来启动 Sequelize 和验证的代码。我需要等待 await authenticate() 方法以确保数据库已准备好供其他应用程序组件使用:

'use strict';

(async () =>
{
    let Sequelize=require('sequelize');
    let seq = new Sequelize('admin_apptoolset', 'root', 'root', 
        {
            host: 'localhost',
            dialect: 'mysql',
            operatorsAliases: false,
            pool: 
            {
                max: 5,
                min: 0,
                acquire: 30000,
                idle: 10000
            }
        });

        console.log("Trying to connect to database...");
        await seq.authenticate();
        console.log("Connected to database...");

        return;
})()

我可以看到两个控制台日志是如何转储到控制台的，但是进程在返回后不会退出。它不应该起作用吗？

提前致谢。

Answer 1

您需要断开与数据库的连接，因为它会阻止事件战利品退出。在return;

之前添加 seq.close();

(async () => {
    let Sequelize = require("sequelize");
    let seq = new Sequelize("admin_apptoolset", "root", "root", {
        host: "localhost",
        dialect: "mysql",
        operatorsAliases: false,
        pool: {
            max: 5,
            min: 0,
            acquire: 30000,
            idle: 10000
        }
    });
    console.log("Trying to connect to database...");
    await seq.authenticate();
    console.log("Connected to database...");
    seq.close(); // close connection
    return;
})();