package category

import (
	"github.com/gin-gonic/gin"

	"github.com/runningwater/gohub/pkg/app"
	"github.com/runningwater/gohub/pkg/database"
	"github.com/runningwater/gohub/pkg/paginator"
)

func Get(idStr string) (category Category) {
	database.DB.Where("id", idStr).First(&category)
	return
}

func GetBy(field, value string) (category Category) {
	database.DB.Where("? = ?", field, value).First(&category)
	return
}

func All() (categories []Category) {
	database.DB.Find(&categories)
	return
}

func IsExist(field, value string) bool {
	var count int64
	database.DB.Model(Category{}).Where("? = ?", field, value).Count(&count)
	return count > 0
}

// Paginate 分页内容
func Paginate(c *gin.Context, pageSize int) (categories []Category, paging paginator.Paging) {
	paging = paginator.Paginate(
		c,
		database.DB.Model(Category{}),
		&categories,
		app.V1URL(database.TableName(&Category{})),
		pageSize,
	)
	return
}