Changeset 591

Timestamp:

Oct 17, 2007, 3:22:37 PM (13 years ago)

Author:

Nick Burch

Message:

Rename import script

File:

• trunk/npemap.org.uk/scripts/npemap-importer/importer.pl (moved) (moved from trunk/npemap.org.uk/scripts/npemap-importer/mirror-api-data) (3 diffs)

trunk/npemap.org.uk/scripts/npemap-importer/importer.pl

@@ -3 +3 @@
 #                   ----------------------
 #
-# This script handles downloading the latest NPEMaps dataset export, and
-#  the latest FreeThePostcode export, and importing them into a local
+# This script handles downloading the latest NPEMaps dataset export (but
+#  not the latest FreeThePostcode export), and importing it into a local
 #  copy of the NPE Maps database.
 # This allows you to run your own copy of the NPE Maps api, and have it
 #  loaded with the latest data nightly / weekly
+# (You will almost certainly want to schedule a run of the
+#  freethepostcode importer too)
+#
 # Warning - you should not be tracking bad postcodes if you use this
-#  script, as it will zap everything between runs!
+#  script, as it will zap everything it has previously imported between
+#   runs!
 
 # Find our private perl libraries
@@ -23 +27 @@
 if($?) { exit $?; }
 
+# Our entry in the sources table
+my $source = 2;
+
 # Clear out the current entries
 my $dbh = setup_dbh();
-my $del = $dbh->prepare("DELETE FROM postcodes");
-$del->execute();
-
-# Our entry in the sources table
-my $source = 2;
+my $del = $dbh->prepare("DELETE FROM postcodes WHERE source = ?");
+$del->execute($source);
 
 # Load up the new ones
@@ -49 +53 @@
 # Close our connection
 $dbh->disconnect;
-
-# Run the FTP importer
-print `$FindBin::Bin/../freethepostcode.org-importer/importer.py --download --no-confirm`;