Changeset 325

Timestamp:

Nov 5, 2006, 12:42:23 PM (14 years ago)

Author:

Nick Burch

Message:

Optionally, limit to just working on one postcode

File:

• trunk/npemap.org.uk/scripts/process-problems (modified) (2 diffs)

trunk/npemap.org.uk/scripts/process-problems

@@ -10 +10 @@
 use NPEMap;
 
+# Optionally, limit by the postcode ID
+my $postcode_id = shift;
+my $postcode_where = "";
+if($postcode_id && $postcode_id =~ /^\d+$/) {
+        $postcode_where = " AND p.id = $postcode_id ";
+}
+
+# Get the postcodes
 my $dbh = setup_dbh() or die $!;
 
@@ -17 +25 @@
          p.easting, p.northing
 FROM     bad_postcodes AS b INNER JOIN postcodes AS p ON (b.postcode = p.id)
-WHERE    not b.actioned
+WHERE    not b.actioned   $postcode_where
 ORDER BY p.id, b.created_at
 EOF