12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- package clause_test
- import (
- "fmt"
- "testing"
- "github.com/jinzhu/gorm/clause"
- )
- func TestLimit(t *testing.T) {
- results := []struct {
- Clauses []clause.Interface
- Result string
- Vars []interface{}
- }{
- {
- []clause.Interface{clause.Select{}, clause.From{}, clause.Limit{
- Limit: 10,
- Offset: 20,
- }},
- "SELECT * FROM `users` LIMIT 10 OFFSET 20", nil,
- },
- {
- []clause.Interface{clause.Select{}, clause.From{}, clause.Limit{Limit: 10, Offset: 20}, clause.Limit{Offset: 30}},
- "SELECT * FROM `users` LIMIT 10 OFFSET 30", nil,
- },
- {
- []clause.Interface{clause.Select{}, clause.From{}, clause.Limit{Limit: 10, Offset: 20}, clause.Limit{Offset: 30}, clause.Limit{Offset: -10}},
- "SELECT * FROM `users` LIMIT 10", nil,
- },
- {
- []clause.Interface{clause.Select{}, clause.From{}, clause.Limit{Limit: 10, Offset: 20}, clause.Limit{Offset: 30}, clause.Limit{Limit: -10}},
- "SELECT * FROM `users`", nil,
- },
- {
- []clause.Interface{clause.Select{}, clause.From{}, clause.Limit{Limit: 10, Offset: 20}, clause.Limit{Offset: 30}, clause.Limit{Limit: 50}},
- "SELECT * FROM `users` LIMIT 50 OFFSET 30", nil,
- },
- }
- for idx, result := range results {
- t.Run(fmt.Sprintf("case #%v", idx), func(t *testing.T) {
- checkBuildClauses(t, result.Clauses, result.Result, result.Vars)
- })
- }
- }
|