node.js – Sequelize Deprecated Error Message

node.js – Sequelize Deprecated Error Message

These were the best explanations that I found for this deprecation warning:

https://github.com/sequelize/sequelize/issues/8417

http://docs.sequelizejs.com/manual/tutorial/querying.html#operators-aliases

Adding operatorsAliases: false did override the warning message in my application.

const Sequelize = require(sequelize)
const sequelize = new Sequelize(
  DB_NAME,
  USERNAME, 
  PASSWORD,
  {
    host: HOSTNAME,
    dialect: mysql,
    logging: false,
    freezeTableName: true,
    operatorsAliases: false
  }
)

Note: as of [email protected] I started receiving Invalid value errors from Sequelize. I relented and used the following code to enable symbol operators:

const Sequelize = require(sequelize)
const Op = Sequelize.Op
const sequelize = new Sequelize(
  DB_NAME,
  USERNAME, 
  PASSWORD,
  {
    host: HOSTNAME,
    dialect: mysql,
    logging: false,
    freezeTableName: true,
    operatorsAliases: {
      $and: Op.and,
      $or: Op.or,
      $eq: Op.eq,
      $gt: Op.gt,
      $lt: Op.lt,
      $lte: Op.lte,
      $like: Op.like
    }
  }
)

Updating to version:

sequelize: ^5.8.6

and removing operatorsAliases param from

new Sequelize()

removed depreciation warning

node.js – Sequelize Deprecated Error Message

const sequelize = new Sequelize({
  username: process.env.DBUSERNAME,
  host: process.env.DBHOST,
  database: process.env.DBNAME,
  password: process.env.DBPASSWORD,
  dialect: postgres,
  define: {
    timestamps: false,
  },
  operatorsAliases: false,
  pool: {
    max: 5,
    min: 0,
    idle: 10000
  },

});

Leave a Reply

Your email address will not be published.