get_grants_by_category.py

nav_options = [
    {'label': 'All', 'keyword': ''},
    {'label': 'Security', 'keyword': 'security'},
    {'label': 'Scalability', 'keyword': 'scalability'},
    {'label': 'UI/UX', 'keyword': 'UI'},
    {'label': 'DeFI', 'keyword': 'defi'},
    {'label': 'Education', 'keyword': 'education'},
    {'label': 'Wallets', 'keyword': 'wallet'},
    {'label': 'Community', 'keyword': 'community'},
    {'label': 'ETH 2.0', 'keyword': 'ETH 2.0'},
    {'label': 'ETH 1.x', 'keyword': 'ETH 1.x'},
]

network = 'mainnet'
from grants.models import Contribution, Grant

for no in nav_options:
    label = no['label']
    keyword = no['keyword']
    grants = Grant.objects.filter(network=network).keyword(keyword)
    grants_pks = grants.values_list('pk', flat=True)
    conributions = Contribution.objects.filter(subscription__grant__pk__in=grants_pks)
    amount = round(sum([conribution.subscription.get_converted_amount() for conribution in conributions if conribution.subscription.get_converted_amount()]))
    print(f"{label}: {conributions.count()} worth ${amount} ")