update_timezones.py

from django.conf import settings
from django.db import IntegrityError

from account.models import ParselyAPIKey, Publisher
from django.core.exceptions import ObjectDoesNotExist

import csv
result = {}
with open('iheart_timezones.csv') as f:
    reader = csv.reader(f)
    for row in reader:
        k, v = row
        result[k] = v

for k,v in result.items():
    try:
        apikey = ParselyAPIKey.objects.get(key=k)
        apikey.timezone = v
        apikey.save()
    except ObjectDoesNotExist:
        print "{} does not exist, skipping".format(k)
        continue