sequelize - is it possible to use findByPk when Primary key is composite key?

Question

I have model called session with composite key of three properties: seesionId, userNameId and accountId. In order to create new record I need to check if there's already session with the same userNameId and accountId.

the API of findByPk: public static async findByPk(param: number | string | Buffer, options: object): Promise

I don't understated how to pass userNameId and accountId together.

SESSION MODEL

export class Session extends Model<Session> implements ISessionModel {
    @PrimaryKey
    @Default(DataType.UUIDV4)
    @AllowNull(false)
    @Column(DataType.UUID)
    sessionId: string;

    @PrimaryKey
    @IsUUID(4)
    @AllowNull(false)
    @Column(DataType.UUID)
    accountId: string;

    @PrimaryKey
    @AllowNull(false)
    @Column
    userNameId: string;

    @AllowNull(false)
    @Column
    userName: string;
..
..
}

As far as I know Sequelize doesn't support composite primary keys. — Anatoly, Jul 14 '20 at 20:14

score 3 · Answer 1 · answered Nov 18 '20 at 21:16

The docs does not specify a way to do that, but lists the ways you can find records through sequelize: (https://sequelize.org/master/manual/model-querying-finders.html)

I had to use findOne instead of findByPk

This is on plain javascript, where we try to find a record for a model with composite keys:

const res = await db.MyModel.findOne({
  where: {
    entityOneId: args.entity_one_id,
    entityTwoId: args.entity_two_id,
  }
});

sequelize - is it possible to use findByPk when Primary key is composite key?

1 Answers1