If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

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

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
RESOLVED FIXED
11 years ago
3 years ago

People

(Reporter: gerv, Assigned: gerv)

Tracking

Details

Attachments

(1 attachment)

(Assignee)

Description

11 years ago
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
(Assignee)

Comment 1

11 years ago
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
Assignee: server-ops → aravind
Created attachment 266145 [details]
Output for query in comment1
Attached query output.
Assignee: aravind → gerv
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.
Group: mozillaorgconfidential
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 ;)
Group: mozillaorgconfidential
(Assignee)

Comment 6

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

Gerv
Reopen when you have more SQL execution requests.
Status: NEW → RESOLVED
Last Resolved: 10 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.