geminispace.info

commit 8b004af54d160a78fdb6d261d4e2478483d2c082
parent 5c9e5267cf88cff4a3a0db55183fcba822b55c18
Author: René Wagner <rwa@clttr.info>
Date:   Wed, 26 May 2021 13:06:36 +0200

unify capitalisation of charset in statistics

Diffstat:
M
gus/lib/index_statistics.py
 | 
4
++--

1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/gus/lib/index_statistics.py b/gus/lib/index_statistics.py
@@ -40,12 +40,12 @@ JOIN page AS p
 ON p.id == c.page_id
 GROUP BY p.content_type
 ORDER BY 2 desc""").dicts())
-    charset_frequencies = (Page.raw("""SELECT p.charset, count(p.charset) as 'count'
+    charset_frequencies = (Page.raw("""SELECT upper(p.charset), count(p.id) as 'count'
 FROM indexable_crawl AS c
 JOIN page AS p
 ON p.id == c.page_id
 WHERE p.charset IS NOT NULL
-GROUP BY p.charset
+GROUP BY upper(p.charset)
 ORDER BY 2 desc""").dicts())
     index_modification_time = Crawl.select(fn.MAX(Crawl.timestamp)).scalar()