Added statistics on file format usage

boards/management/commands/statistics.py

@@ -1,4 +1,5 b''
 from django.core.management import BaseCommand
+from django.db.models import Count
 
 from boards.models import Attachment
 from boards.utils import get_domain
@@ -8,6 +9,7 b' class Command(BaseCommand):'
     help = 'Gather board statistics'
 
     def handle(self, *args, **options):
+        print('* Domains and their usage')
         domains = {}
         for attachment in Attachment.objects.exclude(url=None):
             full_domain = attachment.url.split('/')[2]
@@ -17,7 +19,6 b' class Command(BaseCommand):'
             else:
                 domains[domain] = 1
 
-        print('* Domains and their usage')
         for domain in domains:
             print('{}: {}'.format(domain, domains[domain]))
 
@@ -26,3 +27,9 b' class Command(BaseCommand):'
             Attachment.objects.count(),
             Attachment.objects.exclude(url=None).count()))
 
+        print('* File types')
+        mimetypes = Attachment.objects.filter(url=None)\
+                .values('mimetype').annotate(count=Count('id'))\
+                .order_by('-count')
+        for mimetype in mimetypes:
+            print('{}: {}'.format(mimetype['mimetype'], mimetype['count']))