diff options
author | Matthew Somerville <matthew-github@dracos.co.uk> | 2015-01-19 16:20:55 +0000 |
---|---|---|
committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2015-01-19 16:35:36 +0000 |
commit | 2e8df1a5a6610c43e0c1bda15d018fa16738061b (patch) | |
tree | e06b0a33d399caf5ba0fb94186f609617496740e /bin/load-contacts | |
parent | 7fa239a9c2122074bb65bbb0ac7d30d922a4f761 (diff) |
Tidy up of bin directory.
Remove some unneeded scripts, move others to cobrand-specific
directories.
Diffstat (limited to 'bin/load-contacts')
-rwxr-xr-x | bin/load-contacts | 49 |
1 files changed, 0 insertions, 49 deletions
diff --git a/bin/load-contacts b/bin/load-contacts deleted file mode 100755 index b18699db1..000000000 --- a/bin/load-contacts +++ /dev/null @@ -1,49 +0,0 @@ -#!/usr/bin/perl -w - -# canonicalise-csv: -# Convert provided CSV file into one with standard names for MaPit -# -# Copyright (c) 2006 UK Citizens Online Democracy. All rights reserved. -# Email: matthew@mysociety.org. WWW: http://www.mysociety.org -# -# $Id: load-contacts,v 1.3 2007-08-02 11:44:59 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::Random; - -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) - ); - - if (!dbh()->selectrow_array('select secret from secret for update of secret')) { - local dbh()->{HandleError}; - dbh()->do('insert into secret (secret) values (?)', {}, unpack('h*', mySociety::Random::random_bytes(32))); - } - dbh()->commit(); -} - -open(FP, "$FindBin::Bin/../data/councils_canonical.csv"); -while (<FP>) { - s/\r?\n//g; - my ($id, $email) = split /,/; - dbh()->do("INSERT INTO contacts (area_id, email, editor, whenedited, note) - VALUES (?, ?, 'import', ms_current_timestamp(), 'Initial import')", - {}, $id, $email); -} -dbh()->commit(); -close(FP); |