Show More
@@ -1,4 +1,5 b'' | |||||
1 | from django.core.management import BaseCommand |
|
1 | from django.core.management import BaseCommand | |
|
2 | from django.db.models import Count | |||
2 |
|
3 | |||
3 | from boards.models import Attachment |
|
4 | from boards.models import Attachment | |
4 | from boards.utils import get_domain |
|
5 | from boards.utils import get_domain | |
@@ -8,6 +9,7 b' class Command(BaseCommand):' | |||||
8 | help = 'Gather board statistics' |
|
9 | help = 'Gather board statistics' | |
9 |
|
10 | |||
10 | def handle(self, *args, **options): |
|
11 | def handle(self, *args, **options): | |
|
12 | print('* Domains and their usage') | |||
11 | domains = {} |
|
13 | domains = {} | |
12 | for attachment in Attachment.objects.exclude(url=None): |
|
14 | for attachment in Attachment.objects.exclude(url=None): | |
13 | full_domain = attachment.url.split('/')[2] |
|
15 | full_domain = attachment.url.split('/')[2] | |
@@ -17,7 +19,6 b' class Command(BaseCommand):' | |||||
17 | else: |
|
19 | else: | |
18 | domains[domain] = 1 |
|
20 | domains[domain] = 1 | |
19 |
|
21 | |||
20 | print('* Domains and their usage') |
|
|||
21 | for domain in domains: |
|
22 | for domain in domains: | |
22 | print('{}: {}'.format(domain, domains[domain])) |
|
23 | print('{}: {}'.format(domain, domains[domain])) | |
23 |
|
24 | |||
@@ -26,3 +27,9 b' class Command(BaseCommand):' | |||||
26 | Attachment.objects.count(), |
|
27 | Attachment.objects.count(), | |
27 | Attachment.objects.exclude(url=None).count())) |
|
28 | Attachment.objects.exclude(url=None).count())) | |
28 |
|
29 | |||
|
30 | print('* File types') | |||
|
31 | mimetypes = Attachment.objects.filter(url=None)\ | |||
|
32 | .values('mimetype').annotate(count=Count('id'))\ | |||
|
33 | .order_by('-count') | |||
|
34 | for mimetype in mimetypes: | |||
|
35 | print('{}: {}'.format(mimetype['mimetype'], mimetype['count'])) |
General Comments 0
You need to be logged in to leave comments.
Login now