From 52adceb6be36c121d3cfb16e7bf29ec4889dc6ec Mon Sep 17 00:00:00 2001
From: "Jakob L. Kreuze" <zerodaysfordays@sdf.org>
Date: Sat, 6 Jun 2020 15:22:27 -0400
Subject: Fix `tags_for_image`.

The function wasn't filtering for the given `image_id`.
---
 src/database.rs | 7 +++----
 1 file changed, 3 insertions(+), 4 deletions(-)

diff --git a/src/database.rs b/src/database.rs
index 54f511f..b83fc9b 100644
--- a/src/database.rs
+++ b/src/database.rs
@@ -170,11 +170,10 @@ impl TagDatabase {
         Ok(self
             .0
             .prepare(
-                "SELECT tags.name, COUNT(mapping.tag) as tag_count
+                "SELECT tags.name
                  FROM mapping
-                 INNER JOIN images ON images.id = ?
-                 INNER JOIN tags
-                 GROUP BY tags.name;",
+                 INNER JOIN tags ON mapping.tag = tags.id
+                 WHERE mapping.image = ?;",
             )?
             .query_map(params![image_id], |row| row.get(0))?
             .filter_map(|tag| tag.ok())
-- 
cgit v1.3