Skip to content

Instantly share code, notes, and snippets.

@glenrobertson
Created November 30, 2011 23:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save glenrobertson/1411892 to your computer and use it in GitHub Desktop.
Save glenrobertson/1411892 to your computer and use it in GitHub Desktop.
import eventlet, settings, datetime
from crimes.models import Crime
from django.db.models import Min,Max
pool = eventlet.greenpool.GreenPool(settings.DB_CONNECTIONS)
min_max_id = Crime.objects.all().aggregate(Min('id'),Max('id'))
min_id = min_max_id['id__min']
max_id = min_max_id['id__max']
update_agency_last_updated = lambda qs: qs.update(agency_last_updated=datetime.datetime(2000,1,1))
for i in map(lambda x: x * 1000, xrange(max_id / 1000)):
qs = Crime.objects.filter(id__gte=i).filter(id__lt=(i+1000))
pool.spawn_n(update_agency_last_updated, qs)
pool.waitall()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment