aboutsummaryrefslogtreecommitdiffstats
path: root/pydis_site/apps/api/models
diff options
context:
space:
mode:
authorGravatar Boris Muratov <[email protected]>2021-03-12 16:00:14 +0200
committerGravatar Boris Muratov <[email protected]>2021-03-12 16:00:14 +0200
commitcd797f801abaff8874e75b1ed093e17f67572a37 (patch)
treee801be65256a718e911f78dbddc54b8862c7ecbf /pydis_site/apps/api/models
parentSplit test_no_metricity_user to two tests by endpoints (diff)
Add case in query for voice chat activity
Diffstat (limited to 'pydis_site/apps/api/models')
-rw-r--r--pydis_site/apps/api/models/bot/metricity.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/pydis_site/apps/api/models/bot/metricity.py b/pydis_site/apps/api/models/bot/metricity.py
index db975d4e..5daa5c66 100644
--- a/pydis_site/apps/api/models/bot/metricity.py
+++ b/pydis_site/apps/api/models/bot/metricity.py
@@ -105,6 +105,7 @@ class Metricity:
CASE
WHEN channels.name ILIKE 'help-%%' THEN 'the help channels'
WHEN channels.name ILIKE 'ot%%' THEN 'off-topic'
+ WHEN channels.name ILIKE '%%voice%%' THEN 'voice chats'
ELSE channels.name
END,
COUNT(1)