Re: buildfarm notifications

Josh Berkus wrote:

>>I am expecting that for the most part people will want the lists of
>>state changes, rather than the lists of all builds or failures. Will
>>Spikesource tests track state changes?
>>    
>>
>
>They'd like to.  CVS makes this kind of challenging.    They'd be happy to 
>have suggestions ...
>  
>

In the buildfarm system, the state of each machine/branch is either OK 
or the stage in the buildfarm process that failed - we stop at the first 
such failure. Since all the data reported is stored in our db, finding 
the previous state is fairly simple - we just run this:
 select coalesce(     (select distinct on (snapshot) stage         from build_status         where sysname = ? and
branch= ? and snapshot < ?         order by snapshot desc         limit 1), 'NEW') as prev_status
 

plugging in the values from the current build.

>  
>
>>BTW, these list are being set up only for announcements, so I would have
>>to grant permission before any results started flowing.
>>    
>>
>
>Yep, that's why I'm mentioning it.
>
>  
>

send me details off-list.

cheers

andrew