Composite Primary Key in Sequelize

model-user.js

/*
 * Migration
 */
'use strict';
module.exports = {
  up: function(queryInterface, Sequelize) {
    return queryInterface.createTable('Users', {
      firstName: {
        type: Sequelize.STRING
      },
      lastName: {
        type: Sequelize.STRING
      },
      email: {
        type: Sequelize.STRING
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE
      }
    })
    .then(() => {
      return queryInterface.sequelize.query('ALTER TABLE "Users" ADD CONSTRAINT "username" PRIMARY KEY ("firstName", "lastName")');
    })
  },
  down: function(queryInterface, Sequelize) {
    return queryInterface.dropTable('Users');
  }
};

/*
 * Model
 */
'use strict';
module.exports = function(sequelize, DataTypes) {
  var User = sequelize.define('users', {
    firstName: {
      type: DataTypes.STRING,
      primaryKey: true,
    },
    lastName: {
      type: DataTypes.STRING,
      primaryKey: true,
    },
    email: DataTypes.STRING
  });
  User.removeAttribute('id');
  return User;
};

@narayana1043
You've still got to use the where clause in findOne()
Something like this findOne({where:{composite_key_1:value})

Let me know if this was helpful, Thanks.

When I create a composite key, by specifying primaryKey: true multiple times, am I able to find out the name of the composite key to use in the where clause?

Thanks

@ narayana1043
Todavía tienes que usar la wherecláusula en findOne()
algo como estofindOne({where:{composite_key_1:value})
Hágame saber si esto fue útil, gracias.

Cuando creo una clave compuesta, al especificar primaryKey: truevarias veces, ¿puedo averiguar el nombre de la clave compuesta para usar en la cláusula where?

Gracias

Hi!!! You could know how to get the name thanks