• Do only one thing
• Non breaking API changes
• Tested
  • I checked this patch at Refactor code for FOR UPDATE clause c-bata/goptuna#171.

What did this pull request do?

This PR is for automatically skipping FOR UPDATE (and FOR SHARE) clause.

See go-gorm/gorm#3687 for details.

User Case Description

Currently, it is required to write following code:

if s.db.Dialector.Name() == "sqlite" {
	result = tx.First(&study, "study_id = ?", studyID)
} else {
	result = tx.Clauses(clause.Locking{Strength: "UPDATE"}).First(&study, "study_id = ?", studyID)
}

https://github.com/c-bata/goptuna/blob/9e9699a4394bf94f2a311ba4574a507ac833c824/rdb.v2/storage.go#L216-L224

From this patch, we can write it like below:

result = tx.Clauses(clause.Locking{Strength: "UPDATE"}).First(&study, "study_id = ?", studyID)