launchpad-dev team mailing list archive

[Tim Penhey <tim@xxxxxxxxxx>]

On Wed, 26 May 2010 10:26:33 Tim Penhey wrote:
> I'm sure I'll end up with more questions later.

And here is a real doozey.

In a list of branches, we have the following ACLs to check for *every* branch:

The ACL of the target:
  * project
  * distro series source package
    * of which possibly any three could be private?

The ACL of the owner:
  * possibly a private team

The ACL of the branch itself

How can we do this with a single query over the branch table?

Tim