使用Sequelize

Question

我尝试使用Sequelize ORM。在阅读文档时，我看到了示例

const Project = sequelize.define('project', {
title: Sequelize.STRING,
description: Sequelize.TEXT
})

const Task = sequelize.define('task', {
title: Sequelize.STRING,
description: Sequelize.TEXT,
deadline: Sequelize.DATE
})

我解决了实际应用于shell节点的问题。我在命令行中启动了node

var sequelize = require('sequelize')
sequelize.define ...

但是node告诉我这是错误的，sequelize没有方法“定义”。所以现在我想我的错误在哪里，而我的错误是理解文档。

Answer 1

您需要创建sequelize的实例：

const Sequelize = require("sequelize");

const sequelize = new Sequelize(
  database,
  username,
  password,
  {
    host: host,
    logging: false,
    dialect: "mysql",
    port: 3306,
    pool: {
      max: 5,
      min: 0,
      idle: 10000
    }
  }
);

在那之后，定义：

const Project = sequelize.define('project', {
title: Sequelize.STRING,
description: Sequelize.TEXT
})

const Task = sequelize.define('task', {
title: Sequelize.STRING,
description: Sequelize.TEXT,
deadline: Sequelize.DATE
})