X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=lib%2FDebbugs%2FDB%2FResultSet%2FMessage.pm;h=f5cf894b9e6f5f0b43a60f2bb9610779b1e22f3e;hb=dfd1d5b50f0f2d1bae6deb5168de9f0bed11faa9;hp=08509ce701212ad03ac37a146c59aaed5c6ff2af;hpb=b402eacc8f657e94c53e517604d341e886e2140d;p=debbugs.git diff --git a/lib/Debbugs/DB/ResultSet/Message.pm b/lib/Debbugs/DB/ResultSet/Message.pm index 08509ce..f5cf894 100644 --- a/lib/Debbugs/DB/ResultSet/Message.pm +++ b/lib/Debbugs/DB/ResultSet/Message.pm @@ -24,14 +24,10 @@ use warnings; use base 'DBIx::Class::ResultSet'; -use Debbugs::DB::Util qw(select_one); - sub get_message_id { my ($self,$msg_id,$from,$to,$subject) = @_; - return $self->result_source->schema->storage-> - dbh_do(sub { - my ($dbh,$msg_id,$from,$to,$subject) = @_; - my $mi = select_one($dbh,<<'SQL',@_[1..$#_],@_[1..$#_]); + return $self->result_source->schema-> + select_one(<<'SQL',@_,@_); WITH ins AS ( INSERT INTO message (msgid,from_complete,to_complete,subject) VALUES (?,?,?,?) ON CONFLICT (msgid,from_complete,to_complete,subject) DO NOTHING RETURNING id @@ -42,11 +38,6 @@ SELECT id FROM correspondent WHERE msgid=? AND from_complete = ? AND to_complete = ? AND subject = ? LIMIT 1; SQL - return $mi; -}, - @_[1..$#_] - ); - }