mrhwick

from collections import defaultdict

points = BallotEntry.objects.values(
    'ballot__poll_id',
    'team',
).filter(
    ballot__submission_date__isnull=False
).annotate(
    points=Sum(26-F('rank'))
)

mrhwick

pg_dump -d rcfbpoll -t social_* > social_dump.sql
psql -U postgres -d rcfbpoll -c "drop table social_auth_association;"
psql -U postgres -d rcfbpoll -c "drop table social_auth_code;"
psql -U postgres -d rcfbpoll -c "drop table social_auth_nonce;"
psql -U postgres -d rcfbpoll -c "drop table social_auth_usersocialauth;"
psql -U postgres -d rcfbpoll -c "drop table social_auth_partial;"

pip uninstall social-auth-app-django social-auth-core --yes --no-input

pip install social-auth-app-django

mrhwick

Keybase proof

I hereby claim:

• I am mrhwick on github.
• I am mrhwick (https://keybase.io/mrhwick) on keybase.
• I have a public key whose fingerprint is 2D76 BB74 F245 C20F 55F0 854C 9A8C 5A71 6769 811B

To claim this, I am signing this object: