[Libreoffice-commits] dev-tools.git: 2 commits - scripts/esc-bug-stats.pl

[Robinson Tryon]

 scripts/esc-bug-stats.pl |6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

New commits:
commit 56830328e5f500787db7be4649ef51dbea55e464
Author: Robinson Tryon 
Date:   Mon Dec 21 20:23:15 2015 -0600

esc-bug-stats: Whiteboard -> Keywords migration

We haven't made a decision about migrating the bibisected36 /
bibisected40 tags to Keywords, so we've tweaked the queries to include
the ~100 bugs for which this detail is applicable.

diff --git a/scripts/esc-bug-stats.pl b/scripts/esc-bug-stats.pl
index 23277ed..496b79c 100755
--- a/scripts/esc-bug-stats.pl
+++ b/scripts/esc-bug-stats.pl
@@ -102,8 +102,8 @@ $reg_open = Bugzilla::get_query($regression_open_query);
 $reg_high = Bugzilla::get_query($regression_high_query);
 
 print STDERR "Querying for bibisection:\n";
-my $bibisect_query = 
"https://$Bugzilla::bugserver/buglist.cgi?f1=keywords=status_whiteboard_name=BibisectedAll_id=578080=1=substring=substring=LibreOffice_based_on=BibisectedAll_format=advanced=---=FIXED=INVALID=WONTFIX=DUPLICATE=WORKSFORME=MOVED=NOTABUG=NOTOURBUG=bibisected=bibisected35older;;
-my $bibisect_open_query = 
"https://$Bugzilla::bugserver/buglist.cgi?f1=keywords=status_whiteboard_name=Bibisected_id=578082=1=substring=substring=LibreOffice_based_on=Bibisected_format=advanced=---=bibisected=bibisected35older;;
+my $bibisect_query = 
"https://$Bugzilla::bugserver/buglist.cgi?f2=status_whiteboard=OP=keywords=status_whiteboard=OR_name=BibisectedAll=0_id=579989=1=substring=substring=substring=substring=changeddate
 
DESC%2Cop_sys%2Cbug_status%2Cpriority%2Cassigned_to%2Cbug_id=LibreOffice_format=advanced=---=FIXED=INVALID=WONTFIX=DUPLICATE=WORKSFORME=MOVED=NOTABUG=NOTOURBUG=bibisected=bibisected35older=bibisected=bibisected";
+my $bibisect_open_query = 
"https://$Bugzilla::bugserver/buglist.cgi?f2=status_whiteboard=OP=keywords=status_whiteboard=OR_name=Bibisected_id=579994=1=substring=substring=substring=substring=LibreOffice_based_on=Bibisected_format=advanced=---=bibisected=bibisected35older=bibisected=bibisected;;
 
 my ($all, $open);
 $all = Bugzilla::get_query($bibisect_query);
commit e5cb2cdabbb1e7cdf5682c0506671d865fd2cc84
Author: Robinson Tryon 
Date:   Thu Dec 17 08:56:53 2015 -0600

esc-bug-stats: Update queries to reflect Whiteboard -> Keywords migration

Updating the Bugzilla queries used to generate stats. We've been
migrating many Whiteboard tags to the Keywords field.

diff --git a/scripts/esc-bug-stats.pl b/scripts/esc-bug-stats.pl
index b5645be..23277ed 100755
--- a/scripts/esc-bug-stats.pl
+++ b/scripts/esc-bug-stats.pl
@@ -102,14 +102,14 @@ $reg_open = Bugzilla::get_query($regression_open_query);
 $reg_high = Bugzilla::get_query($regression_high_query);
 
 print STDERR "Querying for bibisection:\n";
-my $bibisect_query = 
"https://$Bugzilla::bugserver/buglist.cgi?n2=1=status_whiteboard_id=267679=substring=---=FIXED=INVALID=WONTFIX=DUPLICATE=WORKSFORME=MOVED=NOTABUG=NOTOURBUG_based_on=BibisectedAll=substring_format=advanced=status_whiteboard=bibisected=bibisected35older=LibreOffice_name=BibisectedAll=0;;
-my $bibisect_open_query = 
"https://$Bugzilla::bugserver/buglist.cgi?n2=1=status_whiteboard_id=267685=substring=---_based_on=Bibisected=substring_format=advanced=status_whiteboard=bibisected=bibisected35older=LibreOffice_name=Bibisected=0;;
+my $bibisect_query = 
"https://$Bugzilla::bugserver/buglist.cgi?f1=keywords=status_whiteboard_name=BibisectedAll_id=578080=1=substring=substring=LibreOffice_based_on=BibisectedAll_format=advanced=---=FIXED=INVALID=WONTFIX=DUPLICATE=WORKSFORME=MOVED=NOTABUG=NOTOURBUG=bibisected=bibisected35older;;
+my $bibisect_open_query = 
"https://$Bugzilla::bugserver/buglist.cgi?f1=keywords=status_whiteboard_name=Bibisected_id=578082=1=substring=substring=LibreOffice_based_on=Bibisected_format=advanced=---=bibisected=bibisected35older;;
 
 my ($all, $open);
 $all = Bugzilla::get_query($bibisect_query);
 $open = Bugzilla::get_query($bibisect_open_query);
 print STDERR "\n";
-print STDERR "* Bibisected bugs open: whiteboard 'bibsected'\n";
+print STDERR "* Bibisected bugs open: keyword 'bibisected'\n";
 print STDERR "\t+ $open (of $all) older ?\n";
 print STDERR "\t\t+ http://bit.ly/VQfF3Q\n;;
 print STDERR "\n";
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

[Libreoffice-commits] dev-tools.git: 2 commits - scripts/esc-bug-stats.pl

[Michael Meeks]

 scripts/esc-bug-stats.pl |   13 ++---
 1 file changed, 10 insertions(+), 3 deletions(-)

New commits:
commit 072933624f42e007b017667517cf72c765ccfc52
Author: Michael Meeks michael.me...@collabora.com
Date:   Tue Sep 10 10:46:58 2013 +0100

3.6 open MAB should have no data in future.

diff --git a/scripts/esc-bug-stats.pl b/scripts/esc-bug-stats.pl
index bbd823f..7bc1501 100755
--- a/scripts/esc-bug-stats.pl
+++ b/scripts/esc-bug-stats.pl
@@ -262,7 +262,7 @@ print  EOF
  /table:table-cell
  table:table-cell/
  table:table-cell table:formula=of:=[.L2]-[.B2] 
office:value-type=float calcext:value-type=float/
- table:table-cell office:value-type=float 
office:value=$ver_open{'3.6'} calcext:value-type=float/
+ table:table-cell/
  table:table-cell table:formula=of:=[.M2]-[.D2] 
office:value-type=float calcext:value-type=float/
  table:table-cell office:value-type=float 
office:value=$ver_open{'4.0'} calcext:value-type=float/
  table:table-cell table:formula=of:=[.N2]-[.F2] 
office:value-type=float calcext:value-type=float/
commit 29ccb8460750008351b49956dbae3d579c3c8608
Author: Michael Meeks michael.me...@collabora.com
Date:   Tue Sep 10 09:44:44 2013 +0100

parse some more bugzilla edge cases.

diff --git a/scripts/esc-bug-stats.pl b/scripts/esc-bug-stats.pl
index 9375352..bbd823f 100755
--- a/scripts/esc-bug-stats.pl
+++ b/scripts/esc-bug-stats.pl
@@ -32,9 +32,13 @@ sub get_deps($)
 
 my $bug_count = -1;
 while (my $line = shift (@bugs)) {
-   if ($line =~ m/^\s*depends on\s*$/) {
+   if ($line =~ m/does not depend on any open bugs/) {
+   $bug_count = 0;
+   last;
+   }
+   elsif ($line =~ m/^\s*depends on\s*$/) {
$line = shift @bugs;
-#  print STDERR Have depends on\n;
+#  print STDERR Have depends on '$line'\n;
if ($line =~ m/^\s*(\d+)\s*$/) {
my $num = $1;
$line = shift @bugs;
@@ -43,6 +47,9 @@ sub get_deps($)
$bug_count = $num;
last;
}
+   } elsif ($line =~ m/\s+one\s+/) { # special case for one
+   $bug_count = 1;
+   last;
} else {
print STDERR odd depends on follow-on: '$line'\n;
}
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

[Libreoffice-commits] dev-tools.git: 2 commits - scripts/esc-bug-stats.pl

[Michael Meeks]

 scripts/esc-bug-stats.pl |  249 ---
 1 file changed, 237 insertions(+), 12 deletions(-)

New commits:
commit 9ccb1417e77bc8af353e4db281dfd2d69ea3
Author: Michael Meeks michael.me...@suse.com
Date:   Sat Aug 10 10:25:39 2013 +0100

Improve flat ods.

diff --git a/scripts/esc-bug-stats.pl b/scripts/esc-bug-stats.pl
index 307964c..ea8c65d 100755
--- a/scripts/esc-bug-stats.pl
+++ b/scripts/esc-bug-stats.pl
@@ -117,7 +117,7 @@ $component_count{'Migration'} = 
get_deps(https://bugs.freedesktop.org/showdepen
 $component_count{'Crashes'} = 
get_query(https://bugs.freedesktop.org/buglist.cgi?keywords=regressionkeywords_type=allwordslist_id=296015short_desc=crashquery_based_on=CrashRegressionsquery_format=advancedbug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=NEEDINFOshort_desc_type=allwordssubstrproduct=LibreOfficeknown_name=CrashRegressions;);
 $component_count{'Borders'} = 
get_query(https://bugs.freedesktop.org/buglist.cgi?keywords=regressionkeywords_type=allwordslist_id=296016short_desc=borderquery_based_on=BorderRegressionsquery_format=advancedbug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=NEEDINFOshort_desc_type=allwordssubstrproduct=LibreOfficeknown_name=BorderRegressions;);
 
-my @reg_toquery = ( 'Spreadsheet', 'Presentation', 'Database', 'Drawing', 
'LibreOffice', 'Writer', 'BASIC' );
+my @reg_toquery = ( 'Spreadsheet', 'Presentation', 'Database', 'Drawing', 
'Libreoffice', 'Writer', 'BASIC' );
 for my $component (@reg_toquery) {
 $component_count{$component} = 
get_query(https://bugs.freedesktop.org/buglist.cgi?keywords=regressionkeywords_type=allwordslist_id=296025query_format=advancedbug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=NEEDINFObug_status=PLEASETESTcomponent=$componentproduct=LibreOffice;);
 }
@@ -290,7 +290,7 @@ EOF
 ;
 
 my @output_order = ( 'Spreadsheet', 'Presentation', 'Database', 'Drawing',
-'LibreOffice', 'Borders', 'Crashes', 'BASIC', 'Writer/RTF',
+'Libreoffice', 'Borders', 'Crashes', 'BASIC', 'Writer/RTF',
 'Writer', 'Migration' );
 
 for my $foo (@output_order) {
commit 703a95af4f604e91bb70d7c20f1abdc56ddea169
Author: Michael Meeks michael.me...@suse.com
Date:   Tue Aug 6 13:44:15 2013 +0200

Print out flat-ods to accelerate bug-metrics build.

diff --git a/scripts/esc-bug-stats.pl b/scripts/esc-bug-stats.pl
index 9604ece..307964c 100755
--- a/scripts/esc-bug-stats.pl
+++ b/scripts/esc-bug-stats.pl
@@ -1,5 +1,8 @@
 #!/usr/bin/perl -w
 
+# use me for testing XML pretty printing etc.
+my $fast_debug = 0;
+
 sub get_url($)
 {
 my $url = shift;
@@ -16,6 +19,9 @@ sub get_url($)
 sub get_deps($)
 {
 my ($url) = @_;
+
+return 42 if ($fast_debug);
+
 my @bugs = get_url($url);
 
 my $bug_count = -1;
@@ -42,6 +48,9 @@ sub get_deps($)
 sub get_query($)
 {
 my ($url) = @_;
+
+return 6 if ($fast_debug);
+
 my @bugs = get_url($url);
 
 my $bug_count = -1;
@@ -61,6 +70,9 @@ my %bug_to_ver = (
 '3.6' = '6'
 );
 
+my %ver_open;
+my %ver_total;
+
 print STDERR Querying for open MABs:\n;
 for my $ver (sort keys %bug_to_ver) {
 my $bug = $bug_to_ver{$ver};
@@ -68,7 +80,9 @@ for my $ver (sort keys %bug_to_ver) {
 my $all = get_deps($base_url);
 my $open = get_deps($base_url . hide_resolved=1);
 $percent = ($open * 100.0) / $all;
-print $ver: $open/$all - $percent%\n;
+print STDERR $ver: $open/$all - $percent%\n;
+$ver_open{$ver} = $open;
+$ver_total{$ver} = $all;
 }
 
 my ($reg_all, $reg_open);
@@ -86,15 +100,15 @@ my $bibisect_open_query = 
https://bugs.freedesktop.org/buglist.cgi?n2=1f1=stat
 my ($all, $open);
 $all = get_query($bibisect_query);
 $open = get_query($bibisect_open_query);
-print \n;
-print * Bibisected bugs open: whiteboard 'bibsected'\n;
-print \t+ $open (of $all) older ?\n;
-print \t\t+ http://bit.ly/VQfF3Q\n;;
-print \n;
+print STDERR \n;
+print STDERR * Bibisected bugs open: whiteboard 'bibsected'\n;
+print STDERR \t+ $open (of $all) older ?\n;
+print STDERR \t\t+ http://bit.ly/VQfF3Q\n;;
+print STDERR \n;
 
-print * all bugs tagged with 'regression'\n;
-print \t+ $reg_open(+?) bugs open of $reg_all(+?) total\n;
-print \n;
+print STDERR * all bugs tagged with 'regression'\n;
+print STDERR \t+ $reg_open(+?) bugs open of $reg_all(+?) total\n;
+print STDERR \n;
 
 my %component_count;
 
@@ -103,13 +117,224 @@ $component_count{'Migration'} = 
get_deps(https://bugs.freedesktop.org/showdepen
 $component_count{'Crashes'} = 
get_query(https://bugs.freedesktop.org/buglist.cgi?keywords=regressionkeywords_type=allwordslist_id=296015short_desc=crashquery_based_on=CrashRegressionsquery_format=advancedbug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=NEEDINFOshort_desc_type=allwordssubstrproduct=LibreOfficeknown_name=CrashRegressions;);
 

[Libreoffice-commits] dev-tools.git: 2 commits - scripts/esc-bug-stats.pl

[Michael Meeks]

 scripts/esc-bug-stats.pl |   41 +
 1 file changed, 33 insertions(+), 8 deletions(-)

New commits:
commit ef176103cee3a24981f6f6fa74e96e3fddae9227
Author: Michael Meeks michael.me...@suse.com
Date:   Wed Jun 12 14:06:55 2013 +0100

add 4.2 MAB tracker.

diff --git a/scripts/esc-bug-stats.pl b/scripts/esc-bug-stats.pl
index 772ee7b..9604ece 100755
--- a/scripts/esc-bug-stats.pl
+++ b/scripts/esc-bug-stats.pl
@@ -55,6 +55,7 @@ sub get_query($)
 }
 
 my %bug_to_ver = (
+'4.2' = '65675',
 '4.1' = '60270',
 '4.0' = '54157',
 '3.6' = '6'
commit da559c284479eef84c596444e8b5a43a95fea847
Author: Michael Meeks michael.me...@suse.com
Date:   Tue Apr 30 14:28:52 2013 +0100

more completeness / fidelity improvements for esc bug stat generation.

diff --git a/scripts/esc-bug-stats.pl b/scripts/esc-bug-stats.pl
index 9a7a152..772ee7b 100755
--- a/scripts/esc-bug-stats.pl
+++ b/scripts/esc-bug-stats.pl
@@ -60,7 +60,7 @@ my %bug_to_ver = (
 '3.6' = '6'
 );
 
-print Querying for open MABs:\n;
+print STDERR Querying for open MABs:\n;
 for my $ver (sort keys %bug_to_ver) {
 my $bug = $bug_to_ver{$ver};
 my $base_url = https://bugs.freedesktop.org/showdependencytree.cgi?id=; . 
$bug;
@@ -70,21 +70,45 @@ for my $ver (sort keys %bug_to_ver) {
 print $ver: $open/$all - $percent%\n;
 }
 
-my ($all, $open);
+my ($reg_all, $reg_open);
 
-print Querying for regressions:\n;
+print STDERR Querying for regressions:\n;
 my 
$regression_query=https://bugs.freedesktop.org/buglist.cgi?columnlist=bug_severity%2Cpriority%2Ccomponent%2Cop_sys%2Cassigned_to%2Cbug_status%2Cresolution%2Cshort_desckeywords=regression%2C%20keywords_type=allwordslist_id=267671product=LibreOfficequery_format=advancedorder=bug_idlimit=0;;
 my 
$regression_open_query=https://bugs.freedesktop.org/buglist.cgi?keywords=regression%2C%20keywords_type=allwordslist_id=267687columnlist=bug_severity%2Cpriority%2Ccomponent%2Cop_sys%2Cassigned_to%2Cbug_status%2Cresolution%2Cshort_descresolution=---query_based_on=Regressionsquery_format=advancedproduct=LibreOfficeknown_name=Regressionslimit=0;;
-$all = get_query($regression_query);
-$open = get_query($regression_open_query);
-print $open/$all\n;
+$reg_all = get_query($regression_query);
+$reg_open = get_query($regression_open_query);
 
-print Querying for bibisection:\n;
+print STDERR Querying for bibisection:\n;
 my $bibisect_query = 
https://bugs.freedesktop.org/buglist.cgi?n2=1f1=status_whiteboardlist_id=267679o1=substringresolution=---resolution=FIXEDresolution=INVALIDresolution=WONTFIXresolution=DUPLICATEresolution=WORKSFORMEresolution=MOVEDresolution=NOTABUGresolution=NOTOURBUGquery_based_on=BibisectedAllo2=substringquery_format=advancedf2=status_whiteboardv1=bibisectedv2=bibisected35olderproduct=LibreOfficeknown_name=BibisectedAlllimit=0;;
 my $bibisect_open_query = 
https://bugs.freedesktop.org/buglist.cgi?n2=1f1=status_whiteboardlist_id=267685o1=substringresolution=---query_based_on=Bibisectedo2=substringquery_format=advancedf2=status_whiteboardv1=bibisectedv2=bibisected35olderproduct=LibreOfficeknown_name=Bibisectedlimit=0;;
 
+my ($all, $open);
 $all = get_query($bibisect_query);
 $open = get_query($bibisect_open_query);
-print $open/$all\n;
+print \n;
+print * Bibisected bugs open: whiteboard 'bibsected'\n;
+print \t+ $open (of $all) older ?\n;
+print \t\t+ http://bit.ly/VQfF3Q\n;;
+print \n;
+
+print * all bugs tagged with 'regression'\n;
+print \t+ $reg_open(+?) bugs open of $reg_all(+?) total\n;
+print \n;
+
+my %component_count;
 
+# custom pieces
+$component_count{'Migration'} = 
get_deps(https://bugs.freedesktop.org/showdependencytree.cgi?id=43489hide_resolved=1;);
+$component_count{'Crashes'} = 
get_query(https://bugs.freedesktop.org/buglist.cgi?keywords=regressionkeywords_type=allwordslist_id=296015short_desc=crashquery_based_on=CrashRegressionsquery_format=advancedbug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=NEEDINFOshort_desc_type=allwordssubstrproduct=LibreOfficeknown_name=CrashRegressions;);
+$component_count{'Borders'} = 
get_query(https://bugs.freedesktop.org/buglist.cgi?keywords=regressionkeywords_type=allwordslist_id=296016short_desc=borderquery_based_on=BorderRegressionsquery_format=advancedbug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=NEEDINFOshort_desc_type=allwordssubstrproduct=LibreOfficeknown_name=BorderRegressions;);
+
+my @reg_toquery = ( 'Writer', 'Spreadsheet', 'Libreoffice', 'Presentation', 
'Database', 'Drawing', 'BASIC' );
+for my $component (@reg_toquery) {
+$component_count{$component} = 
get_query(https://bugs.freedesktop.org/buglist.cgi?keywords=regressionkeywords_type=allwordslist_id=296025query_format=advancedbug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=NEEDINFObug_status=PLEASETESTcomponent=$componentproduct=LibreOffice;);
+}
+
+print \t* ~Component   count net *\n;
+for my