WebUI: Implement build groups to add a port to multiple builds

[Wesley Shields]

On Wed, Oct 13, 2010 at 12:12:28AM +0200, Beat G?tzi wrote:
> Hi,
> 
> During the DevSummit at EuroBSDCon we had several discussions about
> missing features of the Tinderbox WebUI. The most requested feature was
> the ability to add a port to multiple builds at the same time.
> 
> This patch against Tinderbox HEAD allows to create build groups and add
> a port to multiple builds in the tinderd queue list view:
> http://tmp.chruetertee.ch/tinderbox-buildgroups-20101012.patch
> 
> This feature requires a database change:
> MySQL:
> CREATE TABLE build_groups(
> 	build_group_name VARCHAR(30) NOT NULL,
> 	build_id INTEGER REFERENCES builds(build_id) ON UPDATE CASCADE,
> 	PRIMARY KEY (build_group_name, build_id)
> );
> 
> PostgreSQL:
> CREATE TABLE build_groups(
> 	build_group_name VARCHAR(30) NOT NULL,
> 	build_id INTEGER REFERENCES builds(build_id) ON UPDATE CASCADE,
> 	PRIMARY KEY (build_group_name, build_id)
> );
> 
> To create build groups you need to log in with the www admin user.
> 
> Changing and deleting build groups is not implemented yet as I don't
> know if this is really required.

I certainly think this is a good idea. I've been using a simple shell
script to queue up a given port in all the builds for me. Being able to
do it from a web-ui will certainly make things easier for some people
though.

-- WXS