#! /opt/mailman/mm/venv/bin/python
import os
import sys

sys.path.insert(0, '/opt/mailman/mm')
# The above line is required. The next line doesn't hurt, but it doesn't work
# because the PYTHONPATH environment setting is processed by Python's setup
# and must be in the environment when Python starts to be effective.
os.environ['PYTHONPATH'] = '/opt/mailman/mm'
os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'

import django
django.setup()
from hyperkitty.models.email import Email

lists = {}

for email in Email.objects.all():
        list = email.mailinglist
        size = len(email.as_bytes())
        entry = lists.setdefault(list, [0, 0])
        entry[0] += 1
        entry[1] += size

print('list\tmsgs\tsize')
for list in lists:
    print(f'{list}\t{lists[list][0]}\t{lists[list][1]}')