gorm-paginate 基于 gorm 的分页插件
gorm-paginate 基于 gorm 的分页插件，支持分页，条件搜索，排序等
介绍
English | 简体中文
GORM分页插件（program implementation for)
特性
-
分页
page：当前页（默认 1）size：每页记录数（默认 10）
-
排序
order_by：排序字段和方向（如created_at desc, name）
-
过滤条件
- 格式：
<field>_<operator>=<value>- 如：
age_gt=20（where age > 20）、name_like=John%（where LIKE ‘John%’）
- 如：
- 支持的比较
eq等于（默认）ne不等于gt大于gte大于等于lt小于lte小于等于between范围搜索like模糊匹配notlike非模糊匹配isisnotin
- 格式：
示例
- 简单分页和排序
GET http://localhost:8080/users?size=10&page=0&order_by=-name,id- 等价的 SQL
SELECT * FROM users ORDER BY name DESC, id ASC LIMIT 10 OFFSET 0- JSON 响应:
{
"page": 1,
"size": 10,
"order_bys": [
{
"field": "name",
"direction": "desc"
},
{
"field": "id",
"direction": "asc"
}
],
"wheres": [],
"comments": [],
"items": [
{
"ID": 29,
"CreatedAt": "2025-03-23T16:12:58.166418+08:00",
"UpdatedAt": "2025-03-23T16:12:58.166418+08:00",
"DeletedAt": null,
"Name": "zxpet",
"Age": 38,
"Balance": 28,
"AccountManager": "bbc"
},
...
],
"total": 200,
"total_pages": 20
}- 条件搜索
GET http://localhost:8080/users?size=10&page=1&age_gt=16&name_like=e%&balance_between=20,250&account_manager_in=zhangsi,lisi- 等价的 SQL
SELECT * FROM users WHERE age > 16 AND name LIKE "e%" and balance BETWEEN 20 AND 250 and account_manager in ("zhangsan", "lisi") LIMIT 10 OFFSET 0- JSON 响应:
{
"page": 1,
"size": 10,
"order_bys": [],
"wheres": [
{
"field": "account_manager",
"operator": "in",
"value": [
"zhangsi",
"lisi"
]
},
{
"field": "age",
"operator": "gt",
"value": "16"
},
{
"field": "name",
"operator": "like",
"value": "e%"
}
],
"comments": [
"invalid operator: between for field: balance"
],
"items": [
{
"ID": 113,
"CreatedAt": "2025-03-23T17:11:45.97259+08:00",
"UpdatedAt": "2025-03-23T17:11:45.97259+08:00",
"DeletedAt": null,
"Name": "etiax",
"Age": 22,
"Balance": 12,
"AccountManager": "zhangsi"
}
],
"total": 200,
"total_pages": 20
}License
© xiexianbin, 2025~time.Now
Released under the Apache License