Neue Datenbankfunktion für das holen der letzten Grils

1 files changed, 8 insertions, 16 deletions

diff --git a/modules/grils/grils.go b/modules/grils/grils.go
index 3ff03ec..135398d 100644
--- a/modules/grils/grils.go
+++ b/modules/grils/grils.go
@@ -105,43 +105,35 @@ func (m *GrilsModule) GetListsOfGril(gril *Gril) error {
 
 func (m *GrilsModule) ProvideDashboardData(user *charakterin.User) []grilist.DashboardCategory {
         var categories []grilist.DashboardCategory
-
         t1 := time.Now()
-        rows, err := m.g.DB.Query(`SELECT id FROM grilist.grils ORDER BY updated_at DESC LIMIT 5`)
+
+        rows, err := m.g.DB.Query(
+                `SELECT id, romaji_name, kanji_name FROM grilist.get_recently_updated_grils();`)
         if err != nil {
                 log.Println(err)
                 return categories
         }
         defer rows.Close()
-        log.Printf("get_newest_grils: %dms", time.Since(t1).Nanoseconds()/1000000)
 
         cat := grilist.DashboardCategory{
                 Title: "Neue Grils",
         }
 
         for rows.Next() {
-                var id int
-                if err := rows.Scan(&id); err != nil {
-                        log.Println(err)
-                        continue
-                }
-
-                t2 := time.Now()
-                gril, err := m.FromID(id)
-                if err != nil {
+                var g Gril
+                if err := rows.Scan(&g.ID, &g.RomajiName, &g.KanjiName); err != nil {
                         log.Println(err)
                         continue
                 }
-                log.Printf("get_gril_from_id_in_newest_grils: %dms", time.Since(t2).Nanoseconds()/1000000)
 
                 cat.Cards = append(cat.Cards, frontend.Card{
-                        Title:       gril.RomajiName,
-                        Description: gril.KanjiName,
+                        Title:       g.RomajiName,
+                        Description: g.KanjiName,
                         Size:        "medium",
                         Actions: []frontend.Action{
                                 frontend.Action{
                                         Name: "anguckieren",
-                                        Link: "/gril/" + gril.Slug(),
+                                        Link: "/gril/" + g.Slug(),
                                 },
                         },
                 })