src/core/migrations/0013_order_images.py
changeset 179 5df15024a40b
parent 175 7331ecc46cba
child 334 169b7cfd1f58
--- 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()