From 6ffa881ed739d62ec36b0d5bf0bf8f4f179d62b5 Mon Sep 17 00:00:00 2001
From: jan <jan@ruken.pw>
Date: Mon, 28 Dec 2015 22:36:35 +0100
Subject: =?UTF-8?q?versuchen,=20die=20performance=20zu=20erh=C3=B6hen=20in?=
 =?UTF-8?q?dem=20wir=20nicht=20grils=5Fflattened=20f=C3=BCr=20updated=5Fat?=
 =?UTF-8?q?=20verwenden,=20weil=20das=20view=20extrem=20langsam=20ist.?=
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 a38f41f..8ec7bcb 100644
--- a/modules/grils/grils.go
+++ b/modules/grils/grils.go
@@ -97,17 +97,30 @@ func (m *GrilsModule) GetListsOfGril(gril *Gril) error {
 func (m *GrilsModule) ProvideDashboardData(user *charakterin.User) []grilist.DashboardCategory {
 	var categories []grilist.DashboardCategory
 
-	grils, err := m.getGrils(`1 = 1 ORDER BY updated_at DESC LIMIT 5`)
+	rows, err := m.g.DB.Query(`SELECT id FROM grilist.grils ORDER BY updated_at DESC LIMIT 5`)
 	if err != nil {
 		log.Println(err)
 		return categories
 	}
+	defer rows.Close()
 
 	cat := grilist.DashboardCategory{
 		Title: "Neue Grils",
 	}
 
-	for _, gril := range grils {
+	for rows.Next() {
+		var id int
+		if err := rows.Scan(&id); err != nil {
+			log.Println(err)
+			continue
+		}
+
+		gril, err := m.FromID(id)
+		if err != nil {
+			log.Println(err)
+			continue
+		}
+
 		cat.Cards = append(cat.Cards, frontend.Card{
 			Title:       gril.RomajiName,
 			Description: gril.KanjiName,
@@ -120,7 +133,6 @@ func (m *GrilsModule) ProvideDashboardData(user *charakterin.User) []grilist.Das
 			},
 		})
 	}
-
 	categories = append(categories, cat)
 	return categories
 }
-- 
cgit v0.10.1