524435 - Add Thunderbird 3.0 and 3.0.1pre to crash-stats.m.c

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Mark Banner (:standard8)]

Please add Thunderbird 3.0 and 3.0.1pre to the crash-stats version list. Assuming sql is still the same it should be:

insert into branches(product,version,branch)
values('Thunderbird','3.0','1.9.1');
insert into branches(product,version,branch)
values('Thunderbird','3.0.1pre',1.9.1')

Comment 1

[Shyam Mani [:fox2mike]]

morgamic, ack?

Comment 2

[Michael Morgan [:morgamic]]

Frank or Lars - can you provide the right SQL please?

Comment 3

[Frank Griswold [:griswolf] [:fgriswold]]

Eventually, folks will know this URL, and then we will get the admin interface and start over. But for now: 
http://code.google.com/p/socorro/wiki/TrackNewProductVersion

We need more data: The Thunderbird team needs to let us know when to start and stop collecting materialized view summary data.

In this case, the first part of the two-step dance is:

INSERT INTO productdims (product, version, branch, release) 
   VALUES ('Thunderbird','3.0','1.9.1','major');
INSERT INTO productdims (product, version, branch, release) ('Thunderbird','3.0.1pre','1.9.1','development');

We cannot complete the process without the start and stop dates for each version.

Comment 4

[Mark Banner (:standard8)]

(In reply to comment #3)
> Eventually, folks will know this URL, and then we will get the admin interface
> and start over.

That's fine, is there a way to subscribe to updates/changes? I have a semi-automated bug creator that I can just template all the required information into.

Also do you have the bug # for the admin interface?

> In this case, the first part of the two-step dance is:
> 
> INSERT INTO productdims (product, version, branch, release) 
>    VALUES ('Thunderbird','3.0','1.9.1','major');
> INSERT INTO productdims (product, version, branch, release)
> ('Thunderbird','3.0.1pre','1.9.1','development');
> 
> We cannot complete the process without the start and stop dates for each
> version.

So I think you want:

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-11-05' as start_date, '2010-01-05' as end_date 
     FROM productdims 
     WHERE product = 'Thunderbird' AND version = '3.0';

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-11-05' as start_date, '2010-01-05' as end_date 
     FROM productdims 
     WHERE product = 'Thunderbird' AND version = '3.0.1pre';

Comment 5

[Frank Griswold [:griswolf] [:fgriswold]]

Your sql looks right.

track LDAP auth at bug #522349
track 'branch administration' at bug #454620

Comment 6

[Shyam Mani [:fox2mike]]

So the SQL in comment #3 and #4 need to go in?

Comment 7

[Michael Morgan [:morgamic]]

Yep - gogo!

Comment 8

[Shyam Mani [:fox2mike]]

All done.

breakpad=# INSERT INTO productdims (product, version, branch, release) 
breakpad-#    VALUES ('Thunderbird','3.0','1.9.1','major');
INSERT 0 1
breakpad=# INSERT INTO productdims (product, version, branch, release)
VALUES ('Thunderbird','3.0.1pre','1.9.1','development');
INSERT 0 1
breakpad=# INSERT INTO product_visibility (productdims_id,start_date,end_date) 
breakpad-#      SELECT id, '2009-11-05' as start_date, '2010-01-05' as end_date 
breakpad-#      FROM productdims 
breakpad-#      WHERE product = 'Thunderbird' AND version = '3.0';
INSERT 0 1
breakpad=# 
breakpad=# INSERT INTO product_visibility (productdims_id,start_date,end_date) 
breakpad-#      SELECT id, '2009-11-05' as start_date, '2010-01-05' as end_date 
breakpad-#      FROM productdims 
breakpad-#      WHERE product = 'Thunderbird' AND version = '3.0.1pre';
INSERT 0 1