github.com/systematiccaos/gorm@v1.22.6/clause/select_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 TestSelect(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{}},
    18  			"SELECT * FROM `users`", nil,
    19  		},
    20  		{
    21  			[]clause.Interface{clause.Select{
    22  				Columns: []clause.Column{clause.PrimaryColumn},
    23  			}, clause.From{}},
    24  			"SELECT `users`.`id` FROM `users`", nil,
    25  		},
    26  		{
    27  			[]clause.Interface{clause.Select{
    28  				Columns: []clause.Column{clause.PrimaryColumn},
    29  			}, clause.Select{
    30  				Columns: []clause.Column{{Name: "name"}},
    31  			}, clause.From{}},
    32  			"SELECT `name` FROM `users`", nil,
    33  		},
    34  		{
    35  			[]clause.Interface{clause.Select{
    36  				Expression: clause.CommaExpression{
    37  					Exprs: []clause.Expression{
    38  						clause.NamedExpr{"?", []interface{}{clause.Column{Name: "id"}}},
    39  						clause.NamedExpr{"?", []interface{}{clause.Column{Name: "name"}}},
    40  						clause.NamedExpr{"LENGTH(?)", []interface{}{clause.Column{Name: "mobile"}}},
    41  					},
    42  				},
    43  			}, clause.From{}},
    44  			"SELECT `id`, `name`, LENGTH(`mobile`) FROM `users`", nil,
    45  		},
    46  	}
    47  
    48  	for idx, result := range results {
    49  		t.Run(fmt.Sprintf("case #%v", idx), func(t *testing.T) {
    50  			checkBuildClauses(t, result.Clauses, result.Result, result.Vars)
    51  		})
    52  	}
    53  }