X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=Debbugs%2FBugs.pm;h=5150d11c3c34565c4e7ed59bf0da4e3ce1e78652;hb=0ea01c001c3e07722958665acc783baec2759651;hp=93967e2cb2f8b885a022cfa9cfe2e5cf7eb3d89f;hpb=94f478e92798307fe2c5028afbfc7c88eee06779;p=debbugs.git

diff --git a/Debbugs/Bugs.pm b/Debbugs/Bugs.pm
index 93967e2..5150d11 100644
--- a/Debbugs/Bugs.pm
+++ b/Debbugs/Bugs.pm
@@ -59,7 +59,7 @@ use Debbugs::Packages qw(getsrcpkgs getpkgsrc);
 use Debbugs::Common qw(getparsedaddrs package_maintainer getmaintainers make_list hash_slice);
 use Fcntl qw(O_RDONLY);
 use MLDBM qw(DB_File Storable);
-use List::AllUtils qw(first);
+use List::AllUtils qw(first max);
 use Carp;
 
 =head2 get_bugs
@@ -201,6 +201,9 @@ my %_get_bugs_common_options =
      usertags  => {type => HASHREF,
                    optional => 1,
                   },
+     newest    => {type => SCALAR|ARRAYREF,
+		   optional => 1,
+		  },
      schema => {type     => OBJECT,
                 optional => 1,
                },
@@ -404,7 +407,7 @@ state $_get_bugs_by_idx_options =
    {hash_slice(%_get_bugs_common_options,
                (qw(package submitter severity tag archive),
                 qw(owner src maint bugs correspondent),
-                qw(affects usertags))
+                qw(affects usertags newest))
               )
    };
 sub get_bugs_by_idx{
@@ -420,7 +423,13 @@ sub get_bugs_by_idx{
 	       die "Can't handle empty maint (unmaintained packages) in get_bugs_by_idx";
 	  }
      }
-
+     if ($param{newest}) {
+	 my $newest_bug = newest_bug();
+	 my @bugs = ($newest_bug - max(make_list($param{newest})) + 1) .. $newest_bug;
+	 $param{bugs} = [exists $param{bugs}?make_list($param{bugs}):(),
+			 @bugs,
+			];
+     }
      # We handle src packages, maint and maintenc by mapping to the
      # appropriate binary packages, then removing all packages which
      # don't match all queries
@@ -492,7 +501,7 @@ state $_get_bugs_by_db_options =
    {hash_slice(%_get_bugs_common_options,
                (qw(package submitter severity tag archive),
                 qw(owner src maint bugs correspondent),
-                qw(affects usertags))
+                qw(affects usertags newest))
               ),
     schema => {type     => OBJECT,
               },
@@ -503,12 +512,10 @@ sub get_bugs_by_db{
                               );
      my %bugs = ();
 
+     my $s = $param{schema};
      my $keys = grep {$_ !~ $_non_search_key_regex} keys(%param);
      die "Need at least 1 key to search by" unless $keys;
-     my $rs = $param{schema}->resultset('Bug');
-     if (exists $param{package}) {
-	 $rs = $rs->search({-or => {map 'bin_package.'}})
-     }
+     my $rs = $s->resultset('Bug');
      if (exists $param{severity}) {
          $rs = $rs->search({'severity.severity' =>
 			    [make_list($param{severity})],
@@ -525,13 +532,30 @@ sub get_bugs_by_db{
                               );
          }
      }
+     if (exists $param{newest}) {
+	 $rs =
+	     $rs->search({},
+			{order_by => {-desc => 'me.creation'},
+			 rows => max(make_list($param{newest})),
+			},
+			);
+     }
      if (exists $param{correspondent}) {
-         $rs = $rs->search({'message_correspondents.addr' =>
-			    [make_list($param{correspondent})],
+	 my $message_rs =
+	     $s->resultset('Message')->
+	     search({'correspondent.addr' =>
+		     [make_list($param{correspondent})],
+		    },
+		   {join => {message_correspondents => 'correspondent'},
+		    columns => ['id'],
+		    group_by => ['me.id'],
+		   },
+		   );
+         $rs = $rs->search({'bug_messages.message' =>
+			   {-in => $message_rs->get_column('id')->as_query()},
 			   },
-                          {join => {correspondent =>
-                                   {bug_messages =>
-                                   {message => 'message_correspondents'}}}},
+                          {join => 'bug_messages',
+			  },
                           );
      }
      if (exists $param{affects}) {
@@ -540,6 +564,8 @@ sub get_bugs_by_db{
 				    [@aff_list],
 				    'src_pkg.pkg' =>
 				    [@aff_list],
+				    'me.unknown_affects' =>
+				    [@aff_list]
 				   },
 			   },
                           {join => [{bug_affects_binpackages => 'bin_pkg'},
@@ -549,38 +575,80 @@ sub get_bugs_by_db{
                           );
      }
      if (exists $param{package}) {
-         $rs = $rs->search({'bin_pkg.pkg' =>
-			    [make_list($param{package})],
+         $rs = $rs->search({-or => {'bin_pkg.pkg' =>
+				    [make_list($param{package})],
+				    'me.unknown.package' =>
+				    [make_list($param{package})]},
 			   },
                           {join => {bug_binpackages => 'bin_pkg'}});
      }
-     if (exists $param{maintainer}) {
+     if (exists $param{maint}) {
 	 my @maint_list =
 	     map {$_ eq '' ? undef : $_}
-	     make_list($param{maintainer});
-	 $rs = $rs->search({-or => {correspondent => [@maint_list],
-				    correspondent2 => [@maint_list],
+	     make_list($param{maint});
+	 my $bin_pkgs_rs =
+	     $s->resultset('BinPkg')->
+	     search({'correspondent.addr' => [@maint_list]},
+		   {join => {bin_vers =>
+			    {src_ver =>
+			    {maintainer => 'correspondent'}}},
+		    columns => ['id'],
+		    group_by => ['me.id'],
+		   },
+		   );
+	 my $src_pkgs_rs =
+	     $s->resultset('SrcPkg')->
+	     search({'correspondent.addr' => [@maint_list]},
+		   {join => {src_vers =>
+			    {maintainer => 'correspondent'}},
+		    columns => ['id'],
+		    group_by => ['me.id'],
+		   },
+		   );
+	 $rs = $rs->search({-or => {'bug_binpackages.bin_pkg' =>
+				   { -in => $bin_pkgs_rs->get_column('id')->as_query},
+				    'bug_srcpackages.src_pkg' => 
+				   { -in => $bin_pkgs_rs->get_column('id')->as_query},
 				   },
 			   },
-			  {join => {bug_affects_binpackage =>
-				   {bin_pkg =>
-				   {bin_ver =>
-				   {src_ver =>
-				   {maintainer => 'correspondent'}
-				   }}},
-				   {bug_affects_srcpackage =>
-				   {src_pkg =>
-				   {src_ver =>
-				   {maintainer => 'correspondent'}
-				   }}}}
-			  }
+			  {join => ['bug_binpackages',
+				    'bug_srcpackages',
+				   ]}
 			  );
      }
      if (exists $param{src}) {
-         $rs = $rs->search({-or => {map {('src_pkg.pkg' => $_)}
-				    make_list($param{src})},
+	 # identify all of the srcpackages and binpackages that match first
+	 my $src_pkgs_rs =
+	 $s->resultset('SrcPkg')->
+	     search({-or => [map {('me.pkg' => $_,
+				  )}
+			     make_list($param{src})],
+		     columns => ['id'],
+		     group_by => ['me.id'],
+		    },
+		   );
+	 my $bin_pkgs_rs =
+	 $s->resultset('BinPkg')->
+	     search({-or => [map {('src_pkg.pkg' => $_,
+				  )}
+			     make_list($param{src})],
+		     },
+		   {join => {bin_vers => {src_ver => 'src_pkg'}},
+		    columns => ['id'],
+		    group_by => ['me.id'],
+		   });
+         $rs = $rs->search({-or => {'bug_binpackages.bin_pkg' =>
+				   { -in => $bin_pkgs_rs->get_column('id')->as_query},
+				    'bug_srcpackages.src_pkg' => 
+				   { -in => $bin_pkgs_rs->get_column('id')->as_query},
+				    'me.unknown_package' =>
+				    [make_list($param{src})],
+				   },
 			   },
-                          {join => {bug_srcpackages => 'src_pkg'}});
+			  {join => ['bug_binpackages',
+				    'bug_srcpackages',
+				   ]}
+			  );
      }
      # tags are very odd, because we must handle usertags.
      if (exists $param{tag}) {
@@ -632,6 +700,13 @@ sub get_bugs_flatfile{
 			       spec   => $_get_bugs_flatfile_options
 			      );
      my $flatfile;
+     if ($param{newest}) {
+	 my $newest_bug = newest_bug();
+	 my @bugs = ($newest_bug - max(make_list($param{newest})) + 1) .. $newest_bug;
+	 $param{bugs} = [exists $param{bugs}?make_list($param{bugs}):(),
+			 @bugs,
+			];
+     }
      if ($param{archive}) {
 	  $flatfile = IO::File->new("$config{spool_dir}/index.archive", 'r')
 	       or die "Unable to open $config{spool_dir}/index.archive for reading: $!";