diff options
| author | Matthew Somerville <matthew-github@dracos.co.uk> | 2017-07-13 09:51:00 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2017-08-09 17:03:48 +0100 |
| commit | e00c75d7f19bc45879c254ea77dce32df825f3a7 (patch) | |
| tree | 7fd42ffd93fa244f81a84d8a5ace4f7be03b81c7 /perllib/FixMyStreet/Script/Alerts.pm | |
| parent | 46b9d8989d5ac2f8eedd196d11ceb4baf57728dd (diff) | |
Move FixMyStreet::DB to FixMyStreet::DB::Schema.
Store a schema object on FixMyStreet::DB instead.
Diffstat (limited to 'perllib/FixMyStreet/Script/Alerts.pm')
| -rw-r--r-- | perllib/FixMyStreet/Script/Alerts.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/perllib/FixMyStreet/Script/Alerts.pm b/perllib/FixMyStreet/Script/Alerts.pm index ef1bdb08b..aefe13318 100644 --- a/perllib/FixMyStreet/Script/Alerts.pm +++ b/perllib/FixMyStreet/Script/Alerts.pm @@ -62,7 +62,7 @@ sub send() { $query =~ s/\?/alert.parameter/ if ($query =~ /\?/); $query =~ s/\?/alert.parameter2/ if ($query =~ /\?/); - $query = FixMyStreet::DB->storage->dbh->prepare($query); + $query = FixMyStreet::DB->schema->storage->dbh->prepare($query); $query->execute(); my $last_alert_id; my %data = ( template => $alert_type->template, data => [], schema => $schema ); @@ -225,7 +225,7 @@ sub send() { and (select whenqueued from alert_sent where alert_sent.alert_id = ? and alert_sent.parameter::integer = problem.id) is null and users.email <> ? order by confirmed desc"; - $q = FixMyStreet::DB->storage->dbh->prepare($q); + $q = FixMyStreet::DB->schema->storage->dbh->prepare($q); $q->execute($latitude, $longitude, $d, $alert->whensubscribed, $alert->id, $alert->user->email); while (my $row = $q->fetchrow_hashref) { $schema->resultset('AlertSent')->create( { |