From 24b042caa0272da6c8cbafe2067c53371e155a82 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sat, 10 Dec 2011 21:52:06 +0100 Subject: [PATCH] Removes deprecated script upgrade/1.0.1/merge_issues_geocoding.php, use bin/formatAddresses.php instead. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.0.1/merge_issues_geocoding.php | 44 -------------------------------- 1 file changed, 44 deletions(-) delete mode 100755 upgrade/1.0.1/merge_issues_geocoding.php diff --git a/upgrade/1.0.1/merge_issues_geocoding.php b/upgrade/1.0.1/merge_issues_geocoding.php deleted file mode 100755 index df98463..0000000 --- a/upgrade/1.0.1/merge_issues_geocoding.php +++ /dev/null @@ -1,44 +0,0 @@ -#!/usr/bin/php5 -debug = 0; // Do not store backtraces. - -print "Tries to geocode addresses (due a bug in the previous release, all addresses must run once again).\n"; -$time = XDB::fetchOneCell('SELECT COUNT(distinct(pid), jobid) - FROM profile_addresses - WHERE accuracy IS NOT NULL AND accuracy > 0'); -$time = ceil($time / 60 / 24); -print "It will approximately take $time days.\n"; - -$it = XDB::rawIterator('SELECT * - FROM profile_addresses - WHERE accuracy IS NOT NULL AND accuracy > 0 - ORDER BY pid, jobid, type, id'); -$total = $it->total(); -$i = 0; -printf("\r%u / %u", $i, $total); -$pid = 0; -$jobid = 0; -while ($item = $it->next()) { - $address = new Address($item); - $address->format(array('requireGeocoding' => true, 'stripGeocoding' => true)); - $address->delete(); - $address->save(); - if (!($pid == $address->pid && $jobid == $address->jobid)) { - $pid = $address->pid; - $jobid = $address->jobid; - sleep(60); - } - - ++$i; - printf("\r%u / %u", $i, $total); -} -print "\nGeocoding done.\n\n"; -print "That's all folks!\n"; - -/* vim:set et sw=4 sts=4 ts=4: */ -?> -- 2.1.4