Closed Bug 442794 Opened 16 years ago Closed 16 years ago

Query: Number of people reviewed patches & contributed to test cases

Categories

(mozilla.org Graveyard :: Server Operations, task)

All
Other
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: natnaree, Assigned: reed)

Details

I want to know:

1. Number of people who reviewed patches in Bugzilla (during the past 6 months before FF3 launch).
- This includes reviews of only products that are categorized as "Client Software" and "Components" (https://bugzilla.mozilla.org/enter_bug.cgi?full=1)

2. Number of "Test Cases" reported in the last 6 months.
Group: infra
Assignee: server-ops → reed
(In reply to comment #0)
> 1. Number of people who reviewed patches in Bugzilla (during the past 6 months
> before FF3 launch).
> - This includes reviews of only products that are categorized as "Client
> Software" and "Components" (https://bugzilla.mozilla.org/enter_bug.cgi?full=1)

265

select distinct flags.setter_id 
from attachments join flagtypes on flags.type_id=flagtypes.id 
join bugs on flags.bug_id = bugs.bug_id 
join products on bugs.product_id=products.id 
join classifications on products.classification_id=classifications.id
where flags.modification_date > '2007-12-17' and flags.modification_date < '2008-06-17' 
and (flags.status = '+' or flags.status = '-') 
and (flagtypes.name = 'review' or flagtypes.name = 'superreview') 
and (classifications.name = 'Client Software' OR classifications.name = 'Components');

> 2. Number of "Test Cases" reported in the last 6 months.

6939

select count(attach_id) as num_attachments
from attachments join longdescs on attachments.bug_id = longdescs.bug_id
and creation_ts = bug_when
where (attachments.description LIKE '%test%' or longdescs.thetext LIKE '%test%')
and creation_ts > '2007-12-17' and creation_ts < '2008-06-17';
Status: NEW → RESOLVED
Closed: 16 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.