Modern Docker Management, Designed for Everyone
Go composecontainer-managementcontainersdockerdocker-composedocker-managementgoself-hostedsveltekittypescriptweb-ui
package pagination
import (
"fmt"
"strings"
kit "go.getarcane.app/kit/pkg"
"go.getarcane.app/kit/pkg/mapping"
"gorm.io/gorm"
)
// ApplyFilter adds a WHERE clause to the GORM query.
// It detects comma-separated values and uses IN (?) for multiple values,
// or = ? for single values.
func ApplyFilter(q *gorm.DB, column, value string) *gorm.DB {
if value == "" {
return q
}
if strings.Contains(value, ",") {
return q.Where(column+" IN ?", kit.TrimNonEmpty(strings.Split(value, ",")))
}
return q.Where(column+" = ?", value)
}
// ApplyLikeSearch adds a LIKE search condition using the same wildcard pattern
// for every placeholder in condition.
func ApplyLikeSearch(q *gorm.DB, search, condition string) *gorm.DB {
term := strings.TrimSpace(search)
if term == "" {
return q
}
pattern := "%" + term + "%"
args := make([]any, strings.Count(condition, "?"))
for i := range args {
args[i] = pattern
}
return q.Where(condition, args...)
}
// PaginateSortAndMapDB paginates DB records and maps them to API DTOs.
func (params QueryParams) PaginateSortAndMapDB[M, D any](query *gorm.DB, records *[]M) ([]D, Response, error) {
paginationResp, err := PaginateAndSortDB(params, query, records)
if err != nil {
return nil, Response{}, fmt.Errorf("paginate db records: %w", err)
}
out, err := mapping.MapSlice[M, D](*records)
if err != nil {
return nil, Response{}, fmt.Errorf("map db records: %w", err)
}
return out, paginationResp, nil
}
// ApplyBooleanFilter adds a WHERE clause for boolean columns.
// It detects comma-separated values and maps "true"/"1" to true and "false"/"0" to false.
func ApplyBooleanFilter(q *gorm.DB, column, value string) *gorm.DB {
if value == "" {
return q
}
parts := strings.Split(value, ",")
var boolValues []bool
for _, part := range parts {
if value, valid := kit.ParseBool(part); valid {
boolValues = append(boolValues, value)
}
}
if len(boolValues) == 1 {
return q.Where(column+" = ?", boolValues[0])
} else if len(boolValues) > 1 {
return q.Where(column+" IN ?", boolValues)
}
return q
}