X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=bin%2Fdebbugs-updatesqlcache;h=b2838463e5c0bb50dffd864171072e1a3b86964a;hb=06a4071fd4b0ea3902310bebffcbbdba6651a165;hp=66a2fdbfad672e8f2605fc25c5b3f3e23d2eb8e2;hpb=9c0a4c1f8fa3b9fd17192d2592e7b6292ef19329;p=debbugs.git diff --git a/bin/debbugs-updatesqlcache b/bin/debbugs-updatesqlcache index 66a2fdb..b283846 100755 --- a/bin/debbugs-updatesqlcache +++ b/bin/debbugs-updatesqlcache @@ -222,11 +222,11 @@ sub update_cache { # select all bugs which are in packages which have had a binary # association modified push @bugs, - map {$_->{'bug_binpackages.id'}} + map {$_->{'bug_binpackages.bug'}} $s->resultset('BinAssociation')-> search_rs({'me.modified' => {'>=',$last_query_time}, }, - {columns => [qw(bug_binpackages.id)], + {columns => [qw(bug_binpackages.bug)], join => {bin => {bin_pkg => 'bug_binpackages' @@ -236,11 +236,11 @@ sub update_cache { )->all(); # or a source association modified push @bugs, - map {$_->{'bug_srcpackages.id'}} + map {$_->{'bug_srcpackages.bug'}} $s->resultset('SrcAssociation')-> search_rs({'me.modified' => {'>=',$last_query_time}, }, - {columns => [qw(bug_srcpackages.id)], + {columns => [qw(bug_srcpackages.bug)], join => {source => {src_pkg => 'bug_srcpackages'