问题描述
使用了node.js的ORM框架Sequelize来操作数据库,通过
sequelize.define()
定义了model模型,然后设置列数据字段的数据类型DataType为Sequelize.JSON, 设置完成后通过
sequelize.sync({ force: true })
初始化数据库后控制台提示报错
相关代码
const Sequelize = require('sequelize')
const db = require('../db')
// 对外暴露model模型
module.exports = db.defineModel('comments', {
pid: Sequelize.STRING(50),
title: Sequelize.STRING(50),
content: Sequelize.STRING(255),
username: Sequelize.STRING(50),
userid: Sequelize.STRING(50),
avatar: {
type: Sequelize.STRING(100),
allowNull: true
},
replyArr: {
type: Sequelize.JSON // JSON 列. 仅限于 PostgreSQL, SQLite and MySQL.
}
})
控制台报错如下: