gorm/clause/locking_test.go

36 lines
933 B
Go
Raw Permalink Normal View History

2020-02-07 18:45:35 +03:00
package clause_test
import (
"fmt"
"testing"
2020-06-02 04:16:07 +03:00
"gorm.io/gorm/clause"
2020-02-07 18:45:35 +03:00
)
2020-06-06 17:52:08 +03:00
func TestLocking(t *testing.T) {
2020-02-07 18:45:35 +03:00
results := []struct {
Clauses []clause.Interface
Result string
Vars []interface{}
}{
{
2020-06-06 16:35:28 +03:00
[]clause.Interface{clause.Select{}, clause.From{}, clause.Locking{Strength: "UPDATE"}},
2020-02-07 18:45:35 +03:00
"SELECT * FROM `users` FOR UPDATE", nil,
},
{
2020-06-06 16:35:28 +03:00
[]clause.Interface{clause.Select{}, clause.From{}, clause.Locking{Strength: "SHARE", Table: clause.Table{Name: clause.CurrentTable}}},
"SELECT * FROM `users` FOR SHARE OF `users`", nil,
2020-02-07 18:45:35 +03:00
},
{
2020-06-06 16:35:28 +03:00
[]clause.Interface{clause.Select{}, clause.From{}, clause.Locking{Strength: "UPDATE"}, clause.Locking{Strength: "UPDATE", Options: "NOWAIT"}},
"SELECT * FROM `users` FOR UPDATE NOWAIT", nil,
2020-02-07 18:45:35 +03:00
},
}
for idx, result := range results {
t.Run(fmt.Sprintf("case #%v", idx), func(t *testing.T) {
checkBuildClauses(t, result.Clauses, result.Result, result.Vars)
})
}
}