381997 - Gerv's b.m.o. SQL execution requests

Status: RESOLVED FIXED

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

Description

[Gervase Markham [:gerv]]

This bug is to track some SQL execution requests for bugzilla.mozilla.org - initially, to help with triaging old reviews. Rather than opening a new bug for each one, I'll paste them in here and assign the bug; whoever does it can attach the results and assign the bug back to me.

Gerv

Comment 1

[Gervase Markham [:gerv]]

Request 1. Please execute this request using the -H (HTML output) switch to the mysql client.

SELECT modification_date,
       flags.bug_id,
       flags.attach_id,
       requestee.login_name AS current_requestee,
       component_owner.login_name AS component_owner,
       products.name,
       components.name,
       bugs.bug_status,
       bugs.resolution
FROM   flags LEFT OUTER JOIN profiles AS requestee 
             ON flags.requestee_id = requestee.userid,
       components LEFT OUTER JOIN profiles AS component_owner 
                  ON components.initialowner = component_owner.userid,
       products,
       flagtypes,
       bugs
WHERE  flags.type_id = flagtypes.id
AND    flags.bug_id = bugs.bug_id
AND    bugs.component_id = components.id
AND    products.id = components.product_id
AND    flagtypes.name IN ('review', 'first-review', 'second-review')
AND    flags.status = '?'
AND    modification_date < "2007-01-01"
ORDER BY modification_date;

Thanks :-)

Gerv

Comment 2

[Aravind Gottipati [:aravind]]

Attachment: Output for query in comment1

Comment 3

[Aravind Gottipati [:aravind]]

Attached query output.

Comment 4

[Dave Miller [:justdave]]

Justin's not going to like that this is still in our component (even though it's assigned to someone else) since it'll show up in our triage list ;)

Also, this bug seems to be public, keep that in mind when composing/running the queries, make sure we aren't circumventing any Bugzilla group permissions with the data we're returning.

Comment 5

[Dave Miller [:justdave]]

I'm pretty sure this specific query that he already ran was meant to be publicly viewed.  It's review triage on public bugs.  My note was mainly a reminder for us to be careful what we looked up for him in public ;)

Comment 6

[Gervase Markham [:gerv]]

All good points. I'll be careful about security (in future). Where would this bug best live, if not in this component?

Gerv

Comment 7

[Reed Loden [:reed]]

Reopen when you have more SQL execution requests.