1 files changed, 0 insertions, 46 deletions
diff --git a/bin/update-areas b/bin/update-areas
deleted file mode 100755
index a8cc01769..000000000
--- a/bin/update-areas
+++ /dev/null
@@ -1,46 +0,0 @@
-#!/usr/bin/perl -w
-
-# update-areas:
-# One-off script to populate the areas column of the problem table
-#
-# Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved.
-# Email: matthew@mysociety.org. WWW: http://www.mysociety.org
-#
-# $Id: update-areas,v 1.1 2007-08-24 12:27:30 matthew Exp $
-
-use strict;
-require 5.8.0;
-
-# Horrible boilerplate to set up appropriate library paths.
-use FindBin;
-use lib "$FindBin::Bin/../perllib";
-use lib "$FindBin::Bin/../commonlib/perllib";
-
-use mySociety::Config;
-use mySociety::DBHandle qw(dbh select_all);
-use mySociety::MaPit;
-use mySociety::VotingArea;
-
-BEGIN {
-    mySociety::Config::set_file("$FindBin::Bin/../conf/general");
-    mySociety::DBHandle::configure(
-        Name => mySociety::Config::get('FMS_DB_NAME'),
-        User => mySociety::Config::get('FMS_DB_USER'),
-        Password => mySociety::Config::get('FMS_DB_PASS'),
-        Host => mySociety::Config::get('FMS_DB_HOST', undef),
-        Port => mySociety::Config::get('FMS_DB_PORT', undef)
-    );
-}
-
-print "Fetching problems...\n";
-my $ids = select_all("select id, latitude, longitude from problem where areas=''");
-print "Updating areas...\n";
-my $c = 0;
-foreach (@$ids) {
-    my $areas = mySociety::MaPit::get_voting_areas_by_location({latitude=>$_->{latitude}, longitude=>$_->{longitude}}, 'polygon');
-    $areas = ',' . join(',', sort keys %$areas) . ',';
-    dbh()->do('update problem set areas=? where id=?', {}, $areas, $_->{id});
-    dbh()->commit();
-    print "Done: " . (++$c) . "/" . @$ids . "\n";
-}
-