Optimistic Locking

Sequelize has built-in support for optimistic locking through a model instance version count.

Whenever Sequelize needs to modify the model, it will make sure that the version count on the model instance is equal to the version count in the database. If the counts are different, an OptimisticLockError will be thrown.

Enabling optimistic locking

Optimistic locking is disabled by default and can be enabled by using the @Version decorator on the attribute of your model that should be used as the version count.

TypeScript

import { InferCreationAttributes, InferAttributes, Model, CreationOptional } from '@sequelize/core';
import { Version } from '@sequelize/core/decorators-legacy';

class User extends Model<InferAttributes<User>, InferCreationAttributes<User>> {
  @Version
  declare version: CreationOptional<number>;
}

JavaScript

import { Model } from '@sequelize/core';
import { Version } from '@sequelize/core/decorators-legacy';

class User extends Model {
  @Version
  version;
}