Count Top Team Subscriptions

gistfile1.txt

from models.subscription import Subscription
from collections import defaultdict

counts = defaultdict(int)
for s in Subscription.query(Subscription.model_type==1).fetch():
    counts[s.model_key] += 1

sorted_counts = sorted(counts.items(), key=lambda x: -x[1])
for team, count in sorted_counts[:100]:
    print team, count