--- a/src/core/migrations/0013_order_images.py Thu Nov 07 17:29:10 2013 +0100
+++ b/src/core/migrations/0013_order_images.py Fri Nov 08 16:10:15 2013 +0100
@@ -31,10 +31,10 @@
#total = 3
#for i,notice in enumerate(orm['core.notice'].objects.filter(image=True, id__in=["111520","111521","111522"])) :
total = orm['core.notice'].objects.filter(image=True).count()
- for i,notice in enumerate(orm['core.notice'].objects.filter(image=True)) :
+ for i,notice in enumerate(orm['core.notice'].objects.filter(image=True).iterator()) :
writer = show_progress(i+1, total, u"Processing notice %s" % notice.id, 50, writer)
#print "notice " + str(notice.id)
- for j,img in enumerate(notice.images.all().order_by('relative_url')):
+ for j,img in enumerate(notice.images.all().order_by('relative_url').iterator()):
# Set order
img.order = j
# Set main picture for notice
@@ -50,7 +50,7 @@
img.save()
#print " " + str(img.relative_url) + " order = " + str(img.order) + ", large = " + str(img.large) + ", main = " + str(img.main)
- if not ((i+1) % 5000):
+ if not ((i+1) % 100):
transaction.commit()
reset_queries()