X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=bin%2Fdebbugs-updatesqlcache;h=0c00c590f1d456705e700e33c13c1a46f75e382c;hb=e78ac0ab15da5fb8538da0992feba8814b76d0b2;hp=d1948ba73e3b961bf8420eeae3c67de1b6dc3f0a;hpb=40f54c803b08d6d2f17489f4f44c422c9ae898e1;p=debbugs.git diff --git a/bin/debbugs-updatesqlcache b/bin/debbugs-updatesqlcache index d1948ba..0c00c59 100755 --- a/bin/debbugs-updatesqlcache +++ b/bin/debbugs-updatesqlcache @@ -223,27 +223,28 @@ sub update_cache { # association modified push @bugs, map {$_->{'bug_binpackages.id'}} - $s->resultset('BinAssociations')-> + $s->resultset('BinAssociation')-> search_rs({'me.modified' => {'>=',$last_query_time}, }, - {columns => [qw(bug_binpackages.id)], - join => {bin_vers => + {columns => [qw(bug_binpackage.id)], + join => {bin => + {bin_vers => {bin_pkg => - 'bug_binpackages' - }}, + 'bug_binpackage' + }}}, result_class => 'DBIx::Class::ResultClass::HashRefInflator', }, )->all(); # or a source association modified push @bugs, map {$_->{'bug_srcpackages.id'}} - $s->resultset('SrcAssociations')-> + $s->resultset('SrcAssociation')-> search_rs({'me.modified' => {'>=',$last_query_time}, }, - {columns => [qw(bug_srcpackages.id)], - join => {src_vers => + {columns => [qw(bug_srcpackage.id)], + join => {source => {src_pkg => - 'bug_srcpackages' + 'bug_srcpackage' }}, result_class => 'DBIx::Class::ResultClass::HashRefInflator', },