github.com/systematiccaos/gorm@v1.22.6/clause/locking_test.go (about)

     1  package clause_test
     2  
     3  import (
     4  	"fmt"
     5  	"testing"
     6  
     7  	"github.com/systematiccaos/gorm/clause"
     8  )
     9  
    10  func TestLocking(t *testing.T) {
    11  	results := []struct {
    12  		Clauses []clause.Interface
    13  		Result  string
    14  		Vars    []interface{}
    15  	}{
    16  		{
    17  			[]clause.Interface{clause.Select{}, clause.From{}, clause.Locking{Strength: "UPDATE"}},
    18  			"SELECT * FROM `users` FOR UPDATE", nil,
    19  		},
    20  		{
    21  			[]clause.Interface{clause.Select{}, clause.From{}, clause.Locking{Strength: "SHARE", Table: clause.Table{Name: clause.CurrentTable}}},
    22  			"SELECT * FROM `users` FOR SHARE OF `users`", nil,
    23  		},
    24  		{
    25  			[]clause.Interface{clause.Select{}, clause.From{}, clause.Locking{Strength: "UPDATE"}, clause.Locking{Strength: "UPDATE", Options: "NOWAIT"}},
    26  			"SELECT * FROM `users` FOR UPDATE NOWAIT", nil,
    27  		},
    28  	}
    29  
    30  	for idx, result := range results {
    31  		t.Run(fmt.Sprintf("case #%v", idx), func(t *testing.T) {
    32  			checkBuildClauses(t, result.Clauses, result.Result, result.Vars)
    33  		})
    34  	}
    35  }