From 6b2eec91f21d4aa28e68f18435c8636f377a4b2a Mon Sep 17 00:00:00 2001
From: "terry%mozilla.org" <>
Date: Wed, 22 Mar 2000 00:47:04 +0000
Subject: Patch by "Matt Masson" <matthew@zeroknowledge.com> -- allow
 definition of different target milestones by product.

---
 sanitycheck.cgi | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'sanitycheck.cgi')

diff --git a/sanitycheck.cgi b/sanitycheck.cgi
index e7008f799..ee6d5e188 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -194,6 +194,25 @@ foreach my $ref (@checklist) {
     }
 }
 
+# Adding check for Target Milestones / products - matthew@zeroknowledge.com
+Status("Checking milestone/products");
+
+@checklist = ();
+SendSQL("select distinct product, target_milestone from bugs");
+while (@row = FetchSQLData()) {
+    my @copy = @row;
+    push(@checklist, \@copy);
+}
+
+foreach my $ref (@checklist) {
+    my ($product, $milestone) = (@$ref);
+    SendSQL("SELECT count(*) FROM milestones WHERE product = '$product' AND value = '$milestone'");
+    if(FetchOneColumn() != 1) {
+        Alert("Bug(s) found with invalud product/milestone: $product/$milestone");
+    }
+}
+
+
 
 Status("Checking components/products");
 
-- 
cgit v1.2.3-24-g4f1b