Re: [Monotone-devel] responses to some IRC discussion of 'automate'

[Thomas Moschny]

On Monday 07 August 2006 14:52, Timothy Brownawell wrote:
> It does not work for branches where the branch heads aren't leaves in
> the revision graph. For example, it fails on net.venge.monotone.visualc8
> or net.venge.monotone.tbrownaw.tester-spinoff .

Here's what I propose instead:

SELECT rev.id
FROM revisions rev
INNER JOIN revision_certs rc 
ON rc.id=rev.id 
AND rc.name='branch' AND rc.value LIKE '${branch}'
EXCEPT
SELECT ra.parent
FROM revision_ancestry ra
INNER JOIN revision_certs rc
ON rc.id=ra.child 
AND rc.name='branch' AND rc.value LIKE '${branch}'

This first fetches all revisions carrying the branch tag in question, than 
subtracts all revisions from that list whose childs also carry the branch 
tag.

To get the head(s) of ${branch}, the result of this has to be passed to 
erase_ancestors. However, it's a rather short list. See also my other mail in 
this thread.

ALso note that LIKE is not quite correct, but used for readability here. 
Instead one should test for equality with a blob like 
X'6E65742E76656E67652E6D6F6E6F746F6E65' ('net.venge.monotone').

Thomas

-- 
Thomas Moschny  <address@hidden>