From 1208af86126d5e030feda2756a0faf93e4366345 Mon Sep 17 00:00:00 2001
From: Struan Donald <struan@exo.org.uk>
Date: Tue, 25 Mar 2014 17:00:52 +0000
Subject: script to import zerotb clinic data

Closes #703
---
 bin/zerotb_import_clinic_list.pl | 115 +++++++++++++++++++++++++++++++++++++++
 1 file changed, 115 insertions(+)
 create mode 100755 bin/zerotb_import_clinic_list.pl

diff --git a/bin/zerotb_import_clinic_list.pl b/bin/zerotb_import_clinic_list.pl
new file mode 100755
index 000000000..359a63925
--- /dev/null
+++ b/bin/zerotb_import_clinic_list.pl
@@ -0,0 +1,115 @@
+#!/usr/bin/perl
+
+use strict;
+use FixMyStreet::App;
+use Text::CSV;
+use Getopt::Long::Descriptive;
+
+use constant TITLE => 0;
+use constant DESC => 1;
+use constant LATLONG => 2;
+use constant EMAIL => 3;
+
+my ($opt, $usage) = describe_options(
+    '%c %o',
+    ['file|f=s',  "path to csv file with list of clinics", { required => 1 } ],
+    ['email|e=s', "default email address for the updates to be sent to", { required => 1 } ],
+    ['verbose|v',  "print out all services as they are found"],
+    ['help',    "print usage message and exit" ],
+);
+print($usage->text), exit if $opt->help;
+
+my $csv = Text::CSV->new ( { binary => 1 } )  # should set binary attribute.
+                or die "Cannot use CSV: ".Text::CSV->error_diag ();
+open my $fh, "<:encoding(utf8)", $opt->file or die "Failed to open " . $opt->file . ": $!";
+
+my $clinic_user = FixMyStreet::App->model('DB::User')->find_or_create({
+    email => $opt->email
+});
+if ( not $clinic_user->in_storage ) {
+    $clinic_user->insert;
+}
+
+# throw away header line
+my $title_row = $csv->getline( $fh );
+
+while ( my $row = $csv->getline( $fh ) ) {
+    my $clinics = FixMyStreet::App->model('DB::Problem')->search({
+        title => $row->[TITLE]
+    });
+
+    my ($lat, $long) = split(',', $row->[LATLONG]);
+    my $p;
+    my $count = $clinics->count;
+    if ( $count == 0 ) {
+        $p = FixMyStreet::App->model('DB::Problem')->create({
+            title => $row->[TITLE],
+            latitude => $lat,
+            longitude => $long,
+            used_map => 1,
+            anonymous => 1,
+            state => 'unconfirmed',
+            name => '',
+            user => $clinic_user,
+            detail => '',
+            areas => '',
+            postcode => ''
+        });
+    } elsif ( $count == 1 ) {
+        $p = $clinics->first;
+    } else {
+        printf "Too many matches for: %s\n", $row->[TITLE];
+        next;
+    }
+    $p->detail( $row->[DESC] );
+    $p->latitude( $lat );
+    $p->longitude( $long );
+    $p->confirm;
+
+    if ( $p->in_storage ) {
+        printf( "Updating entry for %s\n", $row->[TITLE] ) if $opt->verbose;
+        $p->update;
+    } else {
+        printf( "Creating entry for %s\n", $row->[TITLE] ) if $opt->verbose;
+        $p->insert;
+    }
+    $p->discard_changes;
+
+    # disabling existing alerts in case email addresses have changed
+    my $existing = FixMyStreet::App->model('DB::Alert')->search({
+        alert_type => 'new_updates',
+        parameter => $p->id
+    });
+    $existing->update( { confirmed => 0 } );
+
+    if ( $row->[EMAIL] ) {
+        my $u = FixMyStreet::App->model('DB::User')->find_or_new({
+            email => $row->[EMAIL]
+        });
+        $u->insert unless $u->in_storage;
+        create_update_alert( $u, $p, $opt->verbose );
+    }
+
+    create_update_alert( $clinic_user, $p, $opt->verbose );
+}
+
+sub create_update_alert {
+    my ( $user, $p, $verbose ) = @_;
+    my $a = FixMyStreet::App->model('DB::Alert')->find_or_new({
+        alert_type => 'new_updates',
+        user => $user,
+        parameter => $p->id,
+    });
+
+    $a->confirmed(1);
+
+    if ( $a->in_storage ) {
+        printf( "Updating update alert for %s on %s\n", $user->email, $p->title )
+            if $verbose;
+        $a->update;
+    } else {
+        printf( "Creating update alert for %s on %s\n", $user->email, $p->title )
+            if $verbose;
+        $a->insert;
+    }
+}
-- 
cgit v1.2.3