Interface Yiisoft\ActiveRecord\OptimisticLockInterface

The interface should be implemented by Active Record classes to support optimistic locking.

Optimistic locking allows multiple users to access the same record for edits and avoids potential conflicts. If a user attempts to save the record upon some stale data (because another user has modified the data), an {@see \Yiisoft\ActiveRecord\OptimisticLockException} exception will be thrown, and the update or deletion is skipped.

Optimistic locking is only supported by {@see \Yiisoft\ActiveRecord\update()} and {@see \Yiisoft\ActiveRecord\delete()} methods.

To use optimistic locking:

1. Create a column to store the version number of each row. The column type should be BIGINT DEFAULT 0. Implement {@see \Yiisoft\ActiveRecord\optimisticLockPropertyName()} method to return the name of this column.
2. In the Web form that collects the user input, add a hidden field that stores the lock version of the recording being updated.
3. In the controller action that does the data updating, try to catch the {@see \Yiisoft\ActiveRecord\OptimisticLockException} and implement necessary business logic (e.g., merging the changes, prompting stated data) to resolve the conflict.