From 46185bf12dd907e536aa216a03c818f40f88cae8 Mon Sep 17 00:00:00 2001
From: rtz12 <koenig@fagott.pw>
Date: Mon, 3 Oct 2016 15:44:55 +0200
Subject: =?UTF-8?q?Neue=20Datenbankfunktion=20f=C3=BCr=20das=20holen=20der?=
 =?UTF-8?q?=20letzten=20Grils?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit


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(),
 				},
 			},
 		})
-- 
cgit v0.10.1