[Webkit-unassigned] [Bug 40744] Rietveld review queue: Need a way to fetch patches to be processed

[bugzilla-daemon at webkit.org]

https://bugs.webkit.org/show_bug.cgi?id=40744


Julie Parent <jparent at google.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         AssignedTo|webkit-unassigned at lists.web |jparent at google.com
                   |kit.org                     |




--- Comment #1 from Julie Parent <jparent at google.com>  2010-06-16 16:09:36 PST ---
I think we'll need a way to do a custom query, that will look something like:

# Gets all attachment ids for attachements taht are not obsolete, are patches, have some flag set, and don't have in-rietveld set.
SELECT flags.attach_id FROM flags,attachments WHERE attachments.isobsolete = 0 and attachments.ispatch = 1 and flags.attach_id = attachments.attach_id and flags.attach_id not in (SELECT attach_id FROM flags,flagtypes WHERE  flags.type_id = flagtypes.id and flagtypes.name = "in-rietveld")

# Gets all attachment ids for attachments that are not obsolete, are patches, have no flag set.
SELECT attachments.attach_id FROM attachments WHERE attachments.isobsolete = 0 and attachments.ispatch = 1 and attachments.bug_id not in (SELECT bug_id FROM flags)

and we'll need to exclude any security bugs.

-- 
Configure bugmail: https://bugs.webkit.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.