Describe the feature

There is a section in documentation describing locking https://gorm.io/docs/advanced_query.html#Locking-FOR-UPDATE. The section doesn't provide that much explanation on locking so it could be expanded. I created a PR which could solve the issue https://github.com/go-gorm/gorm.io/pull/725

Another thing from API perspective it would be easier to use if the library has predefined values for locking strength and locking options. To solve this problem I created another PR. https://github.com/go-gorm/gorm/pull/6719

Please let me know what do you think about suggested changes.

Motivation

Make locking API easier to understand.

Related Issues

Comment From: github-actions[bot]

This issue has been automatically marked as stale because it has been open 360 days with no activity. Remove stale label or comment or this will be closed in 180 days