node.js - 无法识别的数据类型 Sequelize Postgres

Question

在一个小项目中工作，我需要根据一些日志数据填充 postgres 数据库。我决定使用 Sequelize 来创建我的模型和数据库连接。

尝试调用 SignalDegs.create() 插入记录时，我收到以下错误消息。我试图引用 DataTypes 并导入它而不是 Sequalize 直接导致相同的错误。任何帮助将不胜感激!。

错误:

throw new Error(`Unrecognized datatype for attribute "${this.name}.${name}"`);
        ^
Error: Unrecognized datatype for attribute 

模型文件:

const Sequelize = require('sequelize');
const db = require('../database/index.js');

const SignalDefs = db.define(
  'signaldefs',
  {
    signalType: { primaryKey: true, type: Sequelize.STRING },
    messageSource: { primaryKey: true, type: Sequelize.STRING },
    messageName: { primaryKey: true, type: Sequelize.STRING },
    signalName: { primaryKey: true, type: Sequelize.STRING },
    unit: { primaryKey: true, type: Sequelize.STRING },
    signalID: { autoIncrement: true }
  },
  { freezeTableName: true }
);

const FloatSignals = db.define(
  'floatsignals',
  {
    floatValue: { type: Sequelize.FLOAT },
    time: { primaryKey: true, type: Sequelize.DATE },
    vehicleID: { primaryKey: true, type: Sequelize.INTEGER },
    signal: { primaryKey: true, type: Sequelize.INTEGER }
  },
  { freezeTableName: true }
);

module.exports = { SignalDefs, FloatSignals };

Answer 1

您没有为 signalID 字段设置类型

确定要让signaldefs 模型的几乎所有字段都参与主键吗？