postgresql - Sequelizejs 模式同步不返回

Question

我用 node script.js 运行这个 sequelize 代码

const Sequelize = require('./node_modules/sequelize')
const sequelize = new Sequelize('postgres://user:pw@localhost:5432/db')

const customlayer = sequelize.define('customlayer', {
  ogc_fid: {
    type: Sequelize.INTEGER,
    autoIncrement: true,
    field: 'ogc_fid',
    validate: {isInt: true},
    primaryKey: true
  },
  wkb_geometry: {
    type: Sequelize.GEOMETRY('POINT'),
    field: 'wkb_geometry',
    allowNull: false
  },
  createdAt: {
    type: Sequelize.DATE,
    defaultValue: Sequelize.NOW
  },
  updatedAt: {
    type: Sequelize.DATE,
    allowNull: true
  }
})

customlayer.sync({force: true}).catch(err => console.log(err.message))

它有效(日志输出中没有错误，并且在 Postgres 中创建了表)但它不会返回到正常的终端提示......，所以我必须按 Ctrl+C 才能在终端中继续。由于我将此用作 Ansible 脚本的一部分，因此我需要编写脚本以返回，以便 Ansible 可以继续。我怎样才能让它回来？

Answer 1

要返回，您需要在完成后手动关闭连接，例如:

customlayer.sync({force: true})
  .catch(err => console.log(err.message))
  .finally(() => sequelize.close());