Unrecognized Data Type Sequelize Postgres

Question

Working on a small project where I need to populate a postgres database based on some log data. I've decided to use Sequelize to create my model and db connection.

When trying to call SignalDegs.create() to insert a record I receive the below error message. I've tried to reference DataTypes and import it instead of Sequalize directly resulting in the same error. Any help would be greatly appreciated!.

Error:

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

Model File:

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 };

Anatoly · Accepted Answer · 2020-02-11 21:21:41Z

2

You don't set a type for the signalID field
Are you sure you want almost all fields of the signaldefs model to participate in primary key?

answered Feb 11, 2020 at 21:21

Anatoly

23.2k3 gold badges33 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ian Over a year ago

I am a bufoon thank you, I personally wouldn't ask all the fields to participate but its a requirement. Thanks again.

Collectives™ on Stack Overflow

Unrecognized Data Type Sequelize Postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related