paginator_paginate_test.go

package paginator

import (
	"reflect"
	"time"

	"github.com/pilagod/pointer"
	"gorm.io/gorm"
)

func (s *paginatorSuite) TestPaginateDefaultOptions() {
	s.givenOrders(12)

	// Default Options
	// * Key: ID
	// * Limit: 10
	// * Order: DESC

	var p1 []order
	_, c, _ := New().Paginate(s.db, &p1)
	s.assertIDRange(p1, 12, 3)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(&Config{
		After: *c.After,
	}).Paginate(s.db, &p2)
	s.assertIDRange(p2, 2, 1)
	s.assertBackwardOnly(c)

	var p3 []order
	_, c, _ = New(&Config{
		Before: *c.Before,
	}).Paginate(s.db, &p3)
	s.assertIDRange(p3, 12, 3)
	s.assertForwardOnly(c)
}

/* data type */

func (s *paginatorSuite) TestPaginateSlicePtrs() {
	s.givenOrders(12)

	var p1 []*order
	_, c, _ := New().Paginate(s.db, &p1)
	s.assertIDRange(p1, 12, 3)
	s.assertForwardOnly(c)

	var p2 []*order
	_, c, _ = New(&Config{
		After: *c.After,
	}).Paginate(s.db, &p2)
	s.assertIDRange(p2, 2, 1)
	s.assertBackwardOnly(c)

	var p3 []*order
	_, c, _ = New(&Config{
		Before: *c.Before,
	}).Paginate(s.db, &p3)
	s.assertIDRange(p3, 12, 3)
	s.assertForwardOnly(c)
}

func (s *paginatorSuite) TestPaginateNonSlice() {
	s.givenOrders(3)

	var o order
	_, c, _ := New().Paginate(s.db, &o)
	s.Equal(3, o.ID)
	s.assertNoMore(c)
}

func (s *paginatorSuite) TestPaginateNoMore() {
	s.givenOrders(3)

	var orders []order
	_, c, _ := New().Paginate(s.db, &orders)
	s.assertIDRange(orders, 3, 1)
	s.assertNoMore(c)
}

func (s *paginatorSuite) TestPaginateSpecialCharacter() {
	// ordered by Remark desc -> 2, 1, 4, 3 (":" > "," > "&" > "%")
	s.givenOrders([]order{
		{ID: 1, Remark: ptrStr("a,b,c")},
		{ID: 2, Remark: ptrStr("a:b:c")},
		{ID: 3, Remark: ptrStr("a%b%c")},
		{ID: 4, Remark: ptrStr("a&b&c")},
	})

	cfg := Config{
		Keys:  []string{"Remark"},
		Limit: 3,
	}

	var p1 []order
	_, c, _ := New(&cfg).Paginate(s.db, &p1)
	s.assertIDs(p1, 2, 1, 4)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(
		&cfg,
		WithAfter(*c.After),
	).Paginate(s.db, &p2)
	s.assertIDs(p2, 3)
	s.assertBackwardOnly(c)

	var p3 []order
	_, c, _ = New(
		&cfg,
		WithBefore(*c.Before),
	).Paginate(s.db, &p3)
	s.assertIDs(p3, 2, 1, 4)
	s.assertForwardOnly(c)
}

/* cursor */

func (s *paginatorSuite) TestPaginateForwardShouldTakePrecedenceOverBackward() {
	s.givenOrders(30)

	var p1 []order
	_, c, _ := New().Paginate(s.db, &p1)
	s.assertIDRange(p1, 30, 21)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(&Config{
		After: *c.After,
	}).Paginate(s.db, &p2)
	s.assertIDRange(p2, 20, 11)
	s.assertBothDirections(c)

	var p3 []order
	_, c, _ = New(&Config{
		After:  *c.After,
		Before: *c.Before,
	}).Paginate(s.db, &p3)
	s.assertIDRange(p3, 10, 1)
	s.assertBackwardOnly(c)
}

/* key */

func (s *paginatorSuite) TestPaginateSingleKey() {
	now := time.Now()
	// ordered by CreatedAt desc -> 1, 3, 2
	s.givenOrders([]order{
		{ID: 1, CreatedAt: now.Add(1 * time.Hour)},
		{ID: 2, CreatedAt: now.Add(-1 * time.Hour)},
		{ID: 3, CreatedAt: now},
	})

	cfg := Config{
		Keys:  []string{"CreatedAt"},
		Limit: 2,
	}

	var p1 []order
	_, c, _ := New(&cfg).Paginate(s.db, &p1)
	s.assertIDs(p1, 1, 3)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(
		&cfg,
		WithAfter(*c.After),
	).Paginate(s.db, &p2)
	s.assertIDs(p2, 2)
	s.assertBackwardOnly(c)

	var p3 []order
	_, c, _ = New(
		&cfg,
		WithBefore(*c.Before),
	).Paginate(s.db, &p3)
	s.assertIDs(p3, 1, 3)
	s.assertForwardOnly(c)
}

func (s *paginatorSuite) TestPaginateMultipleKeys() {
	now := time.Now()
	// ordered by (CreatedAt desc, ID desc) -> 2, 3, 1
	s.givenOrders([]order{
		{ID: 1, CreatedAt: now},
		{ID: 2, CreatedAt: now.Add(1 * time.Hour)},
		{ID: 3, CreatedAt: now},
	})

	cfg := Config{
		Keys:  []string{"CreatedAt", "ID"},
		Limit: 2,
	}

	var p1 []order
	_, c, _ := New(&cfg).Paginate(s.db, &p1)
	s.assertIDs(p1, 2, 3)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(
		&cfg,
		WithAfter(*c.After),
	).Paginate(s.db, &p2)
	s.assertIDs(p2, 1)
	s.assertBackwardOnly(c)

	var p3 []order
	_, c, _ = New(
		&cfg,
		WithBefore(*c.Before),
	).Paginate(s.db, &p3)
	s.assertIDs(p3, 2, 3)
	s.assertForwardOnly(c)
}

func (s *paginatorSuite) TestPaginatePointerKey() {
	s.givenOrders([]order{
		{ID: 1, Remark: ptrStr("3")},
		{ID: 2, Remark: ptrStr("2")},
		{ID: 3, Remark: ptrStr("1")},
	})

	cfg := Config{
		Keys:  []string{"Remark", "ID"},
		Limit: 2,
	}

	var p1 []order
	_, c, _ := New(&cfg).Paginate(s.db, &p1)
	s.assertIDs(p1, 1, 2)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(
		&cfg,
		WithAfter(*c.After),
	).Paginate(s.db, &p2)
	s.assertIDs(p2, 3)
	s.assertBackwardOnly(c)

	var p3 []order
	_, c, _ = New(
		&cfg,
		WithBefore(*c.Before),
	).Paginate(s.db, &p3)
	s.assertIDs(p3, 1, 2)
	s.assertForwardOnly(c)
}

func (s *paginatorSuite) TestPaginateRulesShouldTakePrecedenceOverKeys() {
	now := time.Now()
	// ordered by ID desc -> 2, 1
	// ordered by CreatedAt desc -> 1, 2
	s.givenOrders([]order{
		{ID: 1, CreatedAt: now.Add(1 * time.Hour)},
		{ID: 2, CreatedAt: now},
	})

	cfg := Config{
		Rules: []Rule{
			{Key: "CreatedAt"},
		},
		Keys: []string{"ID"},
	}

	var orders []order
	_, _, _ = New(&cfg).Paginate(s.db, &orders)
	s.assertIDs(orders, 1, 2)
}

func (s *paginatorSuite) TestPaginateShouldUseGormColumnTag() {
	s.givenOrders(3)

	type order struct {
		ID        int
		OrderedAt time.Time `json:"orderedAt" gorm:"type:timestamp;column:created_at"`
	}

	var orders []order
	result, _, _ := New(WithKeys("OrderedAt")).Paginate(s.db, &orders)
	s.Nil(result.Error)
	s.assertIDs(orders, 3, 2, 1)
}

/* limit */

func (s *paginatorSuite) TestPaginateLimit() {
	s.givenOrders(10)

	var p1 []order
	_, c, _ := New(&Config{
		Limit: 1,
	}).Paginate(s.db, &p1)
	s.Len(p1, 1)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(&Config{
		Limit: 20,
		After: *c.After,
	}).Paginate(s.db, &p2)
	s.Len(p2, 9)
	s.assertBackwardOnly(c)

	var p3 []order
	_, c, _ = New(&Config{
		Limit:  100,
		Before: *c.Before,
	}).Paginate(s.db, &p3)
	s.Len(p3, 1)
	s.assertForwardOnly(c)
}

/* order */

func (s *paginatorSuite) TestPaginateOrder() {
	now := time.Now()
	// ordered by (CreatedAt desc, ID desc) -> 4, 2, 3, 1
	s.givenOrders([]order{
		{ID: 1, CreatedAt: now},
		{ID: 2, CreatedAt: now.Add(1 * time.Hour)},
		{ID: 3, CreatedAt: now},
		{ID: 4, CreatedAt: now.Add(2 * time.Hour)},
	})

	cfg := Config{
		Keys:  []string{"CreatedAt", "ID"},
		Limit: 2,
	}

	var p1 []order
	_, c, _ := New(
		&cfg,
		WithOrder(ASC),
	).Paginate(s.db, &p1)
	s.assertIDs(p1, 1, 3)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(
		&cfg,
		WithBefore(*c.After),
		WithOrder(DESC),
	).Paginate(s.db, &p2)
	s.assertIDs(p2, 4, 2)
	s.assertForwardOnly(c)

	var p3 []order
	_, c, _ = New(
		&cfg,
		WithBefore(*c.After),
		WithOrder(ASC),
	).Paginate(s.db, &p3)
	s.assertIDs(p3, 1, 3)
	s.assertForwardOnly(c)
}

func (s *paginatorSuite) TestPaginateOrderByKey() {
	now := time.Now()
	// ordered by (CreatedAt desc, ID asc) -> 4, 2, 1, 3
	s.givenOrders([]order{
		{ID: 1, CreatedAt: now},
		{ID: 2, CreatedAt: now.Add(1 * time.Hour)},
		{ID: 3, CreatedAt: now},
		{ID: 4, CreatedAt: now.Add(2 * time.Hour)},
	})

	cfg := Config{
		Rules: []Rule{
			{
				Key: "CreatedAt",
			},
			{
				Key:   "ID",
				Order: ASC,
			},
		},
		Limit: 2,
		Order: DESC, // default order for no order rule
	}

	var p1 []order
	_, c, _ := New(&cfg).Paginate(s.db, &p1)
	s.assertIDs(p1, 4, 2)
	s.assertForwardOnly(c)

	var p2 []order
	_, c, _ = New(
		&cfg,
		WithAfter(*c.After),
	).Paginate(s.db, &p2)
	s.assertIDs(p2, 1, 3)
	s.assertBackwardOnly(c)

	var p3 []order
	_, c, _ = New(
		&cfg,
		WithBefore(*c.Before),
	).Paginate(s.db, &p3)
	s.assertIDs(p3, 4, 2)
	s.assertForwardOnly(c)
}

/* join */

func (s *paginatorSuite) TestPaginateJoinQuery() {
	orders := s.givenOrders(3)
	// total 5 items
	// order 1 -> items (1, 2, 3)
	// order 2 -> items (4, 5)
	// order 3 -> items (6)
	s.givenItems(orders[0], 2)
	s.givenItems(orders[1], 2)
	s.givenItems(orders[2], 1)

	stmt := s.db.
		Table("items").
		Joins("JOIN orders ON orders.id = items.order_id")

	cfg := Config{
		Limit: 3,
	}

	var p1 []item
	_, c, _ := New(&cfg).Paginate(
		stmt.Session(&gorm.Session{}),
		&p1,
	)
	s.assertIDRange(p1, 5, 3)
	s.assertForwardOnly(c)

	var p2 []item
	_, c, _ = New(
		&cfg,
		WithAfter(*c.After),
	).Paginate(
		stmt.Session(&gorm.Session{}),
		&p2,
	)
	s.assertIDRange(p2, 2, 1)
	s.assertBackwardOnly(c)

	var p3 []item
	_, c, _ = New(
		&cfg,
		WithBefore(*c.Before),
	).Paginate(
		stmt.Session(&gorm.Session{}),
		&p3,
	)
	s.assertIDRange(p3, 5, 3)
	s.assertForwardOnly(c)
}

func (s *paginatorSuite) TestPaginateJoinQueryWithAlias() {
	orders := s.givenOrders(2)
	// total 6 items
	// order 1 -> items (1, 3, 5)
	// order 2 -> items (2, 4, 6)
	for i := 0; i < 3; i++ {
		s.givenItems(orders[0], 1)
		s.givenItems(orders[1], 1)
	}

	type itemDTO struct {
		ID      int
		OrderID int
	}

	stmt := s.db.
		Select("its.id AS id, ods.id AS order_id").
		Table("items AS its").
		Joins("JOIN orders AS ods ON ods.id = its.order_id")

	cfg := Config{
		Rules: []Rule{
			{
				Key:     "OrderID",
				SQLRepr: "ods.id",
			},
			{
				Key:     "ID",
				SQLRepr: "its.id",
			},
		},
		Limit: 3,
	}

	var p1 []itemDTO
	_, c, _ := New(&cfg).Paginate(
		stmt.Session(&gorm.Session{}),
		&p1,
	)
	s.assertIDs(p1, 6, 4, 2)
	s.assertForwardOnly(c)

	var p2 []itemDTO
	_, c, _ = New(
		&cfg,
		WithAfter(*c.After),
	).Paginate(
		stmt.Session(&gorm.Session{}),
		&p2,
	)
	s.assertIDs(p2, 5, 3, 1)
	s.assertBackwardOnly(c)

	var p3 []itemDTO
	_, c, _ = New(
		&cfg,
		WithBefore(*c.Before),
	).Paginate(
		stmt.Session(&gorm.Session{}),
		&p3,
	)
	s.assertIDs(p3, 6, 4, 2)
	s.assertForwardOnly(c)
}

/* NULL replacement */

func (s *paginatorSuite) TestPaginateReplaceNULL() {
	s.givenOrders([]order{
		{ID: 1, Remark: ptrStr("r1")},
		{ID: 2, Remark: nil},
		{ID: 3, Remark: ptrStr("r3")},
		{ID: 4, Remark: nil},
		{ID: 5, Remark: ptrStr("r5")},
	})

	cfg := Config{
		Rules: []Rule{
			{
				Key:             "Remark",
				NULLReplacement: "",
			},
			{
				Key: "ID",
			},
		},
		Limit: 3,
	}

	var p1 []order

	_, c, _ := New(&cfg).Paginate(s.db, &p1)

	s.assertIDs(p1, 5, 3, 1)
	s.assertForwardOnly(c)

	var p2 []order

	_, c, _ = New(&cfg, WithAfter(*c.After)).Paginate(s.db, &p2)

	s.assertIDs(p2, 4, 2)
	s.assertBackwardOnly(c)

	var p3 []order

	_, c, _ = New(&cfg, WithBefore(*c.Before)).Paginate(s.db, &p3)

	s.assertIDs(p3, 5, 3, 1)
	s.assertForwardOnly(c)
}

func (s *paginatorSuite) TestPaginateCustomTypeInt() {
	s.givenOrders(9)

	cfg := &Config{
		Limit: 3,
		Rules: []Rule{
			{
				Key:     "Data",
				Order:   DESC,
				SQLRepr: "data #>> '{keyInt}'",
				SQLType: pointer.String("numeric"),
				CustomType: &CustomType{
					Meta: "keyInt",
					Type: reflect.TypeOf(0),
				},
			},
		},
	}

	var p1 []order
	_, c, _ := New(cfg).Paginate(s.db, &p1)
	s.Len(p1, 3)
	s.assertForwardOnly(c)
	s.assertIDs(p1, 9, 8, 7)

	var p2 []order
	_, c, _ = New(cfg, WithAfter(*c.After)).Paginate(s.db, &p2)
	s.Len(p2, 3)
	s.assertBothDirections(c)
	s.assertIDs(p2, 6, 5, 4)

	var p3 []order
	_, c, _ = New(cfg, WithAfter(*c.After)).Paginate(s.db, &p3)
	s.Len(p3, 3)
	s.assertBackwardOnly(c)
	s.assertIDs(p3, 3, 2, 1)

	// go back
	var p2Back []order
	_, c, _ = New(cfg, WithBefore(*c.Before)).Paginate(s.db, &p2Back)
	s.Len(p2Back, 3)
	s.assertBothDirections(c)
	s.assertIDs(p2Back, 6, 5, 4)

	var p1Back []order
	_, c, _ = New(cfg, WithBefore(*c.Before)).Paginate(s.db, &p1Back)
	s.Len(p1Back, 3)
	s.assertForwardOnly(c)
	s.assertIDs(p1, 9, 8, 7)
}

func (s *paginatorSuite) TestPaginateCustomTypeString() {
	s.givenOrders(9)

	cfg := &Config{
		Limit: 3,
		Rules: []Rule{
			{
				Key:     "Data",
				Order:   DESC,
				SQLRepr: "data #>> '{keyString}'",
				SQLType: pointer.String("text"),
				CustomType: &CustomType{
					Meta: "keyString",
					Type: reflect.TypeOf(""),
				},
			},
		},
	}

	var p1 []order
	_, c, _ := New(cfg).Paginate(s.db, &p1)
	s.Len(p1, 3)
	s.assertForwardOnly(c)
	s.assertIDs(p1, 9, 8, 7)

	var p2 []order
	_, c, _ = New(cfg, WithAfter(*c.After)).Paginate(s.db, &p2)
	s.Len(p2, 3)
	s.assertBothDirections(c)
	s.assertIDs(p2, 6, 5, 4)

	var p3 []order
	_, c, _ = New(cfg, WithAfter(*c.After)).Paginate(s.db, &p3)
	s.Len(p3, 3)
	s.assertIDs(p3, 3, 2, 1)
	s.assertBackwardOnly(c)

	// go back
	var p2Back []order
	_, c, _ = New(cfg, WithBefore(*c.Before)).Paginate(s.db, &p2Back)
	s.Len(p2Back, 3)
	s.assertBothDirections(c)
	s.assertIDs(p2Back, 6, 5, 4)

	// go back
	var p1Back []order
	_, c, _ = New(cfg, WithBefore(*c.Before)).Paginate(s.db, &p1Back)
	s.Len(p1Back, 3)
	s.assertForwardOnly(c)
	s.assertIDs(p1, 9, 8, 7)
}

func (s *paginatorSuite) TestPaginateCustomTypeNullable() {
	s.givenOrders([]order{
		{
			ID:     1,
			Remark: ptrStr("1"),
			NullableCustomData: NullString{
				String: "A",
				Valid:  true,
			},
		},
		{
			ID:     2,
			Remark: ptrStr("2"),
			NullableCustomData: NullString{
				String: "",
				Valid:  false,
			},
		},
		{
			ID:     3,
			Remark: ptrStr("2"),
			NullableCustomData: NullString{
				String: "B",
				Valid:  true,
			},
		},
	})

	cfg := &Config{
		Limit: 1,
		Rules: []Rule{
			{
				Key:   "Remark",
				Order: ASC,
			},
			{
				Key:     "NullableCustomData",
				Order:   ASC,
				SQLType: pointer.String("text"),
				CustomType: &CustomType{
					Type: reflect.TypeOf(NullString{}),
				},
				NULLReplacement: "",
			},
		},
	}

	var p1 []order
	_, c, _ := New(cfg).Paginate(s.db, &p1)
	s.Len(p1, 1)
	s.assertForwardOnly(c)
	s.assertIDs(p1, 1)

	var p2 []order
	_, c, _ = New(cfg, WithAfter(*c.After)).Paginate(s.db, &p2)
	s.Len(p2, 1)
	s.assertBothDirections(c)
	s.assertIDs(p2, 2)

	var p3 []order
	_, c, _ = New(cfg, WithAfter(*c.After)).Paginate(s.db, &p3)
	s.Len(p3, 1)
	s.assertBackwardOnly(c)
	s.assertIDs(p3, 3)

	// back to page 2
	var p4 []order
	_, c, _ = New(cfg, WithBefore(*c.Before)).Paginate(s.db, &p4)
	s.Len(p4, 1)
	s.assertBothDirections(c)
	s.assertIDs(p4, 2)

	// back to page 1
	var p5 []order
	_, c, _ = New(cfg, WithBefore(*c.Before)).Paginate(s.db, &p5)
	s.Len(p5, 1)
	s.assertForwardOnly(c)
	s.assertIDs(p5, 1)
}

/* compatibility */

func (s *paginatorSuite) TestPaginateConsistencyBetweenBuilderAndKeyOptions() {
	now := time.Now()
	s.givenOrders([]order{
		{ID: 1, CreatedAt: now},
		{ID: 2, CreatedAt: now},
		{ID: 3, CreatedAt: now},
		{ID: 4, CreatedAt: now},
		{ID: 5, CreatedAt: now},
	})

	var temp []order
	result, c, err := New(
		WithKeys("CreatedAt", "ID"),
		WithLimit(3),
	).Paginate(s.db, &temp)
	if err != nil {
		s.FailNow(err.Error())
	}
	if result.Error != nil {
		s.FailNow(result.Error.Error())
	}

	anchorCursor := *c.After

	var optOrders, builderOrders []order
	var optCursor, builderCursor Cursor

	// forward - keys

	opts := []Option{
		WithKeys("CreatedAt", "ID"),
		WithLimit(3),
		WithOrder(ASC),
		WithAfter(anchorCursor),
	}

	_, optCursor, _ = New(opts...).Paginate(s.db, &optOrders)

	s.assertIDs(optOrders, 4, 5)
	s.assertBackwardOnly(optCursor)

	p := New()
	p.SetKeys("CreatedAt", "ID")
	p.SetLimit(3)
	p.SetOrder(ASC)
	p.SetAfterCursor(anchorCursor)

	_, builderCursor, _ = p.Paginate(s.db, &builderOrders)

	s.assertIDs(builderOrders, 4, 5)
	s.assertBackwardOnly(builderCursor)

	s.Equal(optOrders, builderOrders)
	s.Equal(optCursor, builderCursor)

	// backward - keys

	opts = []Option{
		WithKeys("CreatedAt", "ID"),
		WithLimit(3),
		WithOrder(ASC),
		WithBefore(anchorCursor),
	}

	_, optCursor, _ = New(opts...).Paginate(s.db, &optOrders)

	s.assertIDs(optOrders, 1, 2)
	s.assertForwardOnly(optCursor)

	p = New()
	p.SetKeys("CreatedAt", "ID")
	p.SetLimit(3)
	p.SetOrder(ASC)
	p.SetBeforeCursor(anchorCursor)

	_, builderCursor, _ = p.Paginate(s.db, &builderOrders)

	s.assertIDs(builderOrders, 1, 2)
	s.assertForwardOnly(builderCursor)

	s.Equal(optOrders, builderOrders)
	s.Equal(optCursor, builderCursor)
}

func (s *paginatorSuite) TestPaginateConsistencyBetweenBuilderAndRuleOptions() {
	now := time.Now()
	s.givenOrders([]order{
		{ID: 1, CreatedAt: now},
		{ID: 2, CreatedAt: now},
		{ID: 3, CreatedAt: now},
		{ID: 4, CreatedAt: now},
		{ID: 5, CreatedAt: now},
	})

	var temp []order
	result, c, err := New(
		WithKeys("CreatedAt", "ID"),
		WithLimit(3),
	).Paginate(s.db, &temp)
	if err != nil {
		s.FailNow(err.Error())
	}
	if result.Error != nil {
		s.FailNow(result.Error.Error())
	}
	anchorCursor := *c.After

	var optOrders, builderOrders []order
	var optCursor, builderCursor Cursor

	// forward - rules

	opts := []Option{
		WithRules([]Rule{
			{Key: "CreatedAt"},
			{Key: "ID"},
		}...),
		WithLimit(3),
		WithOrder(ASC),
		WithAfter(anchorCursor),
	}

	_, optCursor, _ = New(opts...).Paginate(s.db, &optOrders)

	s.assertIDs(optOrders, 4, 5)
	s.assertBackwardOnly(optCursor)

	p := New()
	p.SetRules([]Rule{
		{Key: "CreatedAt"},
		{Key: "ID"},
	}...)
	p.SetLimit(3)
	p.SetOrder(ASC)
	p.SetAfterCursor(anchorCursor)

	_, builderCursor, err = p.Paginate(s.db, &builderOrders)

	s.assertIDs(builderOrders, 4, 5)
	s.assertBackwardOnly(builderCursor)

	s.Equal(optOrders, builderOrders)
	s.Equal(optCursor, builderCursor)

	// backward - rules

	opts = []Option{
		WithRules([]Rule{
			{Key: "CreatedAt"},
			{Key: "ID"},
		}...),
		WithLimit(3),
		WithOrder(ASC),
		WithBefore(anchorCursor),
	}

	_, optCursor, _ = New(opts...).Paginate(s.db, &optOrders)

	s.assertIDs(optOrders, 1, 2)
	s.assertForwardOnly(optCursor)

	p = New()
	p.SetRules([]Rule{
		{Key: "CreatedAt"},
		{Key: "ID"},
	}...)
	p.SetLimit(3)
	p.SetOrder(ASC)
	p.SetBeforeCursor(anchorCursor)

	_, builderCursor, _ = p.Paginate(s.db, &builderOrders)

	s.assertIDs(builderOrders, 1, 2)
	s.assertForwardOnly(builderCursor)

	s.Equal(optOrders, builderOrders)
	s.Equal(optCursor, builderCursor)
}