#!/usr/bin/php5 -q debug = 0; // Do not store backtraces print "(Re)Formats postal addresses for all addresses in the database.\n"; $it = XDB::rawIterator('SELECT * FROM profile_addresses ORDER BY pid, jobid, type, id'); $total = $it->total(); $i = 0; $j = 0; printf("\r%u / %u", $i, $total); while ($item = $it->next()) { $address = new Address($item); $address->format(array('postalText' => true)); $address->delete(); $address->save(); ++$i; if ($i == 100) { ++$j; $i = 0; printf("\r%u / %u", $i + 100 * $j, $total); } } print "Done.\n"; // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>