aboutsummaryrefslogtreecommitdiff
path: root/database/tags.go
blob: 199087afdf4dbba26f55fbbbc57a06ff06de517d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
package database

import (
	"imageboard/models"
)

func GetTotalTagsCount() (int64, error) {
	var count int64
	err := DB.Model(&models.Tag{}).Where("is_deleted = ?", false).Count(&count).Error
	return count, err
}

func GetPopularTags(limit int) ([]models.Tag, error) {
	var tags []models.Tag
	err := DB.Where("is_deleted = ?", false).Order("count DESC").Limit(limit).Find(&tags).Error
	return tags, err
}

func GetRecentTags(limit int) ([]models.Tag, error) {
	var tags []models.Tag
	err := DB.Where("is_deleted = ?", false).Order("created_at DESC").Limit(limit).Find(&tags).Error
	return tags, err
}