Modern Docker Management, Designed for Everyone
Go composecontainer-managementcontainersdockerdocker-composedocker-managementgoself-hostedsveltekittypescriptweb-ui
package pagination
import (
"testing"
"github.com/libtnb/sqlite"
"github.com/stretchr/testify/require"
"gorm.io/gorm"
"gorm.io/gorm/logger"
)
// Widgets with duplicate names, inserted in neither id nor name order, so that
// only a deterministic ORDER BY yields a stable page walk.
func newTieBreakTestDB(t *testing.T) *gorm.DB {
t.Helper()
db, err := gorm.Open(sqlite.Open(":memory:"), &gorm.Config{Logger: logger.Default.LogMode(logger.Silent)})
require.NoError(t, err)
require.NoError(t, db.AutoMigrate(&widget{}))
for _, w := range []widget{
{ID: "c", Name: "X"},
{ID: "a", Name: "X"},
{ID: "e", Name: "Y"},
{ID: "b", Name: "X"},
{ID: "d", Name: "Y"},
} {
require.NoError(t, db.Create(&w).Error)
}
return db
}
func walkWidgetPages(t *testing.T, db *gorm.DB, sort string) []string {
t.Helper()
var ids []string
for start := 0; start < 5; start += 2 {
var got []widget
_, err := PaginateAndSortDB(QueryParams{
Start: start, Limit: 2,
Sort: sort, Order: "asc",
}, db.Model(&widget{}), &got)
require.NoError(t, err)
for _, w := range got {
ids = append(ids, w.ID)
}
}
return ids
}
func TestPaginateAndSortDB_NoSortFallsBackToIDOrder(t *testing.T) {
db := newTieBreakTestDB(t)
require.Equal(t, []string{"a", "b", "c", "d", "e"}, walkWidgetPages(t, db, ""))
}
func TestPaginateAndSortDB_SortTiesBrokenByID(t *testing.T) {
db := newTieBreakTestDB(t)
require.Equal(t, []string{"a", "b", "c", "d", "e"}, walkWidgetPages(t, db, "name"))
}
func TestPaginateAndSortDB_CallerIDOrderSkipsTieBreak(t *testing.T) {
db := newTieBreakTestDB(t)
require.True(t, orderedByIDInternal(db.Model(&widget{}).Order("name").Order("widgets.id DESC")))
require.True(t, orderedByIDInternal(db.Model(&widget{}).Order("`id` DESC")))
require.False(t, orderedByIDInternal(db.Model(&widget{}).Order("name DESC")))
require.False(t, orderedByIDInternal(db.Model(&widget{})))
var got []widget
_, err := PaginateAndSortDB(QueryParams{Limit: 5}, db.Model(&widget{}).Order("id DESC"), &got)
require.NoError(t, err)
require.Equal(t, "e", got[0].ID)
}