X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=lib%2FDebbugs%2FDB%2FResultSet%2FSrcPkg.pm;fp=lib%2FDebbugs%2FDB%2FResultSet%2FSrcPkg.pm;h=43cc774895b7ce2f74198a7a156144fd848d3b07;hb=dfd1d5b50f0f2d1bae6deb5168de9f0bed11faa9;hp=36fab13e50574e8827088a4d5e56b62a6cb19363;hpb=b402eacc8f657e94c53e517604d341e886e2140d;p=debbugs.git diff --git a/lib/Debbugs/DB/ResultSet/SrcPkg.pm b/lib/Debbugs/DB/ResultSet/SrcPkg.pm index 36fab13..43cc774 100644 --- a/lib/Debbugs/DB/ResultSet/SrcPkg.pm +++ b/lib/Debbugs/DB/ResultSet/SrcPkg.pm @@ -24,8 +24,6 @@ use warnings; use base 'DBIx::Class::ResultSet'; -use Debbugs::DB::Util qw(select_one); - sub src_pkg_and_ver_in_suite { my ($self,$suite) = @_; if (ref($suite)) { @@ -59,23 +57,16 @@ sub src_pkg_and_ver_in_suite { sub get_src_pkg_id { my ($self,$source) = @_; - return $self->result_source->schema->storage-> - dbh_do(sub { - my ($s,$dbh,$src_pkg) = @_; - return select_one($dbh,<<'SQL',$src_pkg); + return $self->result_source->schema-> + select_one(<<'SQL',$source); SELECT id FROM src_pkg where pkg = ?; SQL - }, - $source - ); } sub get_or_create_src_pkg_id { my ($self,$source) = @_; - return $self->result_source->schema->storage-> - dbh_do(sub { - my ($s,$dbh,$source) = @_; - return select_one($dbh,<<'SQL',$source,$source); + return $self->result_source->schema-> + select_one(<<'SQL',$source,$source); WITH ins AS ( INSERT INTO src_pkg (pkg) VALUES (?) ON CONFLICT (pkg,disabled) DO NOTHING RETURNING id @@ -85,9 +76,6 @@ UNION ALL SELECT id FROM src_pkg where pkg = ? AND disabled = 'infinity'::timestamptz LIMIT 1; SQL - }, - $source - ); } 1;