rootninja

Batch adding users to the cc list for multiple components can take forever, and it’s a lot of click click click click click, which I despise.

If you want to add a user to all of the components in bugzilla, you don’t have to go through the gui. In fact, you can change just about anything in bugzilla by connecting to the database directly and modifying the tables. I find this much faster than repetitively navigating through the web front end.

I just updated 50+ components and it took me 2 minutes to do. But if I’m just updating a component or two, I wouldn’t fiddle with the database directly. It’s just not worth the hassle since you could do it in the same amount of time from the front end.

Connect to the database

$ psql -d bugzilla

Find the user’s userid that you’re looking for in the profiles table

bugzilla=# select userid, login_name from profiles order by user_id;

Find the components for which you would like to add people to the cc list

bugzilla=# select id, name from components order by name;

You can add the dilbert user, whose id is 18, to all the components in one swoop

bugzilla=# insert into component_cc
select distinct 18, select distinct component_id from component_cc);

Or you can change the select to match whatever you want. Until I tried it, I didn’t know you could hold one value constant like that while selecting a distinct range like that. I thought that was pretty neat!