525957 - Add entries for firefox 3.5.5 to socorro

Status: RESOLVED FIXED

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

Description

[Chris AtLee [:catlee]]

insert into productdims (product, version, branch, release) values ('Firefox','3.5.5', '1.9.1', 'major');
insert into productdims (product, version, branch, release) values ('Firefox','3.5.6pre', '1.9.1', 'development');

Comment 1

[Aravind Gottipati [:aravind]]

Need morgamic to approve any/all prod sql.

Comment 2

[Michael Morgan [:morgamic]]

They are missing the product visibility table -- can you guys add the SQL for that?

Comment 3

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

It would be better if they provide the start and end dates that define the time window when materialized views should be collected. Or I could guess...

Comment 4

[Michael Morgan [:morgamic]]

Start date is today.  We don't have an end date yet.

Comment 5

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

In addition to the sql in the initial bug, do this, per the information at http://code.google.com/p/socorro/wiki/TrackNewProductVersion. I am assuming that 90 days is correct. Alterations can be made later, if needed

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-11-05' as start_date, '2010-02-03' as end_date 
     FROM productdims 
     WHERE product = 'Firefox' AND version = '3.5.5';

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-11-05' as start_date, '2010-02-03' as end_date 
     FROM productdims 
     WHERE product = 'Firefox' AND version = '3.5.6pre';

Comment 6

[Michael Morgan [:morgamic]]

Looks good.  Thanks, Frank.

Comment 7

[Nick Thomas [:nthomas] (UTC+12)]

Anything holding this bug up ?

Comment 8

[Michael Morgan [:morgamic]]

Nope, IT just needs to run it.

Comment 9

[Aravind Gottipati [:aravind]]

All done.