From 60fc1773241195f4988ed8066e019bbc42267085 Mon Sep 17 00:00:00 2001
From: GrailFinder <wohilas@gmail.com>
Date: Sun, 2 Jun 2024 15:00:41 +0300
Subject: Enha: add db method to list recs

---
 internal/database/repos/action.go | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'internal/database/repos')

diff --git a/internal/database/repos/action.go b/internal/database/repos/action.go
index 49ad95e..ab1f559 100644
--- a/internal/database/repos/action.go
+++ b/internal/database/repos/action.go
@@ -8,6 +8,18 @@ type ActionRepo interface {
 	DBActionGetByName(name string) (*models.Action, error)
 	DBActionDone(name string) error
 	DBActionsToReset() error
+	DBActionRecommend(username string, at models.ActionType) ([]models.Action, error)
+}
+
+func (p *Provider) DBActionRecommend(
+	username string, at models.ActionType,
+) ([]models.Action, error) {
+	resp := []models.Action{}
+	query := `SELECT * FROM action WHERE username!=$1 AND type=$2 GROUP BY name LIMIT 5;`
+	if err := p.db.Select(&resp, query, username, at); err != nil {
+		return nil, err
+	}
+	return resp, nil
 }
 
 func (p *Provider) DBActionCreate(req *models.Action) error {
-- 
cgit v1.2.3