DEV: add more counts to analyze missing

DEV: add more counts to analyze missing

diff --git a/lib/tasks/uploads.rake b/lib/tasks/uploads.rake
index 3489081..cf8712f 100644
--- a/lib/tasks/uploads.rake
+++ b/lib/tasks/uploads.rake
@@ -1037,6 +1037,18 @@ def analyze_missing
     if count > 0
       puts "Found #{count} uploaded avatars"
     end
+    count = DB.query_single(<<~SQL, ids: ids).first
+      SELECT COUNT(*) FROM user_avatars WHERE gravatar_upload_id IN (:ids)
+    SQL
+    if count > 0
+      puts "Found #{count} gravatars"
+    end
+    count = DB.query_single(<<~SQL, ids: ids).first
+      SELECT COUNT(*) FROM user_avatars WHERE custom_upload_id IN (:ids)
+    SQL
+    if count > 0
+      puts "Found #{count} custom uploaded avatars"
+    end
   end
 
 end

GitHub sha: ec173a72

1 Like