521397 - Add SeaMonkey 2.0 and 2.0.1pre to crash-stats.m.c

Status: RESOLVED FIXED

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

Description

[Robert Kaiser]

SeaMonkey is releasing 2.0 final this month (RC1 has already been built) and the 1.9.1-based builds will be changed to 2.0.1pre, so those versions should be added to crash-stats.m.c for people to search for them.

SQL statements:

insert into productdims(product,version,branch,release)
values('SeaMonkey','2.0','1.9.1','development');
insert into productdims(product,version,branch,release)
values('SeaMonkey','2.0.1pre','1.9.1','development');


I'm not 100% sure of the "release" column, as this is a stable version now, do we need a different value there for "2.0"?

Comment 1

[Shyam Mani [:fox2mike]]

morgamic, please check sql and ack?

Comment 2

[Shyam Mani [:fox2mike]]

morgamic, poke + D'oh ;)

Comment 3

[chizu]

Here's some examples from Firefox 3 to show how the release column is set:
 109 | Firefox     | 3.0       | 1.9.0  | major
 110 | Firefox     | 3.0.1     | 1.9.0  | major
 111 | Firefox     | 3.0.2     | 1.9.0  | major
 112 | Firefox     | 3.0.2pre  | 1.9.0  | development
 113 | Firefox     | 3.0.3     | 1.9.0  | major
 114 | Firefox     | 3.0a5     | 1.9.0  | milestone
 115 | Firefox     | 3.0a5pre  | 1.9.0  | development
 116 | Firefox     | 3.0a6     | 1.9.0  | milestone

It should be 'major' for SeaMonkey 2.0, judging by these.

Comment 4

[Robert Kaiser]

Right, and all the 2.0a* and 2.0b* version should be set to 'milestone', then.

Comment 5

[Michael Morgan [:morgamic]]

The SQL is different now - we'll get it updated tomorrow.

Comment 6

[Robert Kaiser]

Different yet again? wow...

In any case, will you do the changes for the release field for the alphas/betas as well, or should I file another bug for those?

Oh, and I also wonder if we are missing data for the MTBF reports?

Comment 7

[Michael Morgan [:morgamic]]

Frank or Lars can you provide the right SQL please?

Comment 8

[Robert Kaiser]

Standard8 just told me there's a doc for the SQL up at http://code.google.com/p/socorro/wiki/TrackNewProductVersion - he'll provide the statements.

Comment 9

[Mark Banner (:standard8)]

Ok, this should be the SQL we want:

INSERT INTO productdims (product, version, branch, release) 
   VALUES ('SeaMonkey','2.0','1.9.1','major');

INSERT INTO productdims (product, version, branch, release)
   VALUES ('SeaMonkey','2.0.1pre','1.9.1','development');

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-10-10' as start_date, '2009-12-10' as end_date 
     FROM productdims 
     WHERE product = 'SeaMonkey' AND version = '2.0';

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-10-15' as start_date, '2009-12-15' as end_date 
     FROM productdims 
     WHERE product = 'SeaMonkey' AND version = '2.0.1pre';

Comment 10

[Shyam Mani [:fox2mike]]

moragamic, ack?

Comment 11

[Michael Morgan [:morgamic]]

Looks good.  Looking forward to having the admin panel soon!  :)

Comment 12

[Shyam Mani [:fox2mike]]

hawsome!

breakpad=# INSERT INTO productdims (product, version, branch, release) 
breakpad-#    VALUES ('SeaMonkey','2.0','1.9.1','major');
INSERT 0 1
breakpad=# 
breakpad=# INSERT INTO productdims (product, version, branch, release)
breakpad-#    VALUES ('SeaMonkey','2.0.1pre','1.9.1','development');
INSERT 0 1
breakpad=# 
breakpad=# INSERT INTO product_visibility (productdims_id,start_date,end_date) 
breakpad-#      SELECT id, '2009-10-10' as start_date, '2009-12-10' as end_date 
breakpad-#      FROM productdims 
breakpad-#      WHERE product = 'SeaMonkey' AND version = '2.0';
INSERT 0 1
breakpad=# 
breakpad=# INSERT INTO product_visibility (productdims_id,start_date,end_date) 
breakpad-#      SELECT id, '2009-10-15' as start_date, '2009-12-15' as end_date 
breakpad-#      FROM productdims 
breakpad-#      WHERE product = 'SeaMonkey' AND version = '2.0.1pre';
INSERT 0 1

Done.