massive y2k retro overhaul with sidebar, context processors, and proper database organization

1 files changed, 23 insertions, 0 deletions

diff --git a/database/tags.go b/database/tags.go
new file mode 100644
index 0000000..199087a
--- /dev/null
+++ b/database/tags.go
@@ -0,0 +1,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
+}