|
|
from django.core.management import BaseCommand
|
|
|
from django.db.models import Count
|
|
|
|
|
|
from boards.models import Attachment
|
|
|
from boards.utils import get_domain
|
|
|
|
|
|
|
|
|
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=''):
|
|
|
domain = get_domain(attachment.url)
|
|
|
if domain in domains:
|
|
|
domains[domain] += 1
|
|
|
else:
|
|
|
domains[domain] = 1
|
|
|
|
|
|
domain_list = [(item, domains[item]) for item in domains.keys()]
|
|
|
domain_list = sorted(domain_list, key=lambda domain: -domain[1])
|
|
|
for domain in domain_list:
|
|
|
print('{}: {}'.format(domain[0], domain[1]))
|
|
|
|
|
|
print('* Overall numbers')
|
|
|
print('{} attachments in the system, {} of them as URLs'.format(
|
|
|
Attachment.objects.count(),
|
|
|
Attachment.objects.exclude(url='').count()))
|
|
|
|
|
|
print('* File types')
|
|
|
mimetypes = Attachment.objects.filter(url='')\
|
|
|
.values('mimetype').annotate(count=Count('id'))\
|
|
|
.order_by('-count')
|
|
|
for mimetype in mimetypes:
|
|
|
print('{}: {}'.format(mimetype['mimetype'], mimetype['count']))
|
|
|
|
