From 61e94a8474fd3b05205450899bdd185447ac7c28 Mon Sep 17 00:00:00 2001
From: Nathan Perry <np@nathanperry.dev>
Date: Sat, 17 Aug 2024 05:15:07 -0400
Subject: fix rarememe, quiet playback gc logs

---
 src/bot.rs    | 20 ++++++++++++++------
 src/db/mod.rs |  4 ++--
 2 files changed, 16 insertions(+), 8 deletions(-)

diff --git a/src/bot.rs b/src/bot.rs
index 704d699..2f44ba5 100644
--- a/src/bot.rs
+++ b/src/bot.rs
@@ -502,7 +502,7 @@ pub async fn run() -> anyhow::Result<()> {
         loop {
             ticker.tick().await;
 
-            tracing::debug!("running songbird info gc");
+            tracing::trace!("running songbird info gc");
 
             let Some(songbird) = ({
                 let data = client_data.read().await;
@@ -535,11 +535,19 @@ pub async fn run() -> anyhow::Result<()> {
                 result
             });
 
-            tracing::debug!(
-                queued_tracks = active_uuids.len(),
-                n_gced = n_removed,
-                "songbird info gc done"
-            );
+            if n_removed > 0 {
+                tracing::debug!(
+                    queued_tracks = active_uuids.len(),
+                    n_gced = n_removed,
+                    "songbird info gc done"
+                );
+            } else {
+                tracing::trace!(
+                    queued_tracks = active_uuids.len(),
+                    n_gced = n_removed,
+                    "songbird info gc done"
+                );
+            }
         }
     });
 
diff --git a/src/db/mod.rs b/src/db/mod.rs
index a8d66e5..56a8190 100644
--- a/src/db/mod.rs
+++ b/src/db/mod.rs
@@ -340,12 +340,12 @@ pub async fn rare_meme(
         FROM meme_count
             RIGHT JOIN memes ON memes.id = meme_count.meme_id
             INNER JOIN metadata ON metadata.id = memes.metadata_id
-        WHERE memes.guild = $3 AND ((memes.audio_id IS NULL) = $1 OR $2)
+        WHERE (memes.audio_id IS NULL) = $1 OR $2
     ),
     least_used AS (
         SELECT
                meme_id,
-               TRUNC(time_diff / (ct + 1)) as play_prop
+               (TRUNC(time_diff / (ct + 1))::double precision) as play_prop
         FROM aggregate
     )
     SELECT
-- 
cgit v1.3.1