From 83f7e53cf4b84bc26101e57b27b4dac0a32a19cc Mon Sep 17 00:00:00 2001
From: "Jakob L. Kreuze" <zerodaysfordays@sdf.org>
Date: Mon, 18 May 2020 12:10:49 -0400
Subject: Implement `tags_for_image`.

---
 src/main.rs | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'src')

diff --git a/src/main.rs b/src/main.rs
index 3e821c2..3e66f9a 100644
--- a/src/main.rs
+++ b/src/main.rs
@@ -101,6 +101,21 @@ impl TagBase {
         )?;
         Ok(())
     }
+
+    fn tags_for_image(&self, image_id: i64) -> Result<Vec<String>> {
+        Ok(self
+            .conn
+            .prepare(
+                "SELECT tags.name, COUNT(mapping.tag) as tag_count
+                      FROM mapping
+                      INNER JOIN images ON images.id = ?
+                      INNER JOIN tags
+                      GROUP BY tags.name",
+            )?
+            .query_map(params![image_id], |row| row.get(0))?
+            .filter_map(|tag| tag.ok())
+            .collect())
+    }
 }
 
 fn main() {
-- 
cgit v1.3