Golang分页查询API实现教程

type Pagination struct {
    Page  int `json:"page" query:"page"`
    Limit int `json:"limit" query:"limit"`
}

func GetUsers(pagination Pagination) ([]User, int64, error) {
    var users []User
    var total int64
offset := (pagination.Page - 1) * pagination.Limit

db.Model(&User{}).Count(&total)
err := db.Offset(offset).Limit(pagination.Limit).Find(&users).Error
return users, total, err
}

type PagedResponse struct {
    Data       interface{} `json:"data"`
    Total      int64       `json:"total"`
    Page       int         `json:"page"`
    Limit      int         `json:"limit"`
    TotalPages int         `json:"total_pages"`
}

totalPages := int((total + int64(limit) - 1) / int64(limit))

users, total, err := GetUsers(pagination)
if err != nil {
    // 处理错误
}
response := PagedResponse{
    Data:       users,
    Total:      total,
    Page:       pagination.Page,
    Limit:      pagination.Limit,
    TotalPages: totalPages,
}
c.JSON(200, response)