898068 - add graph server sql definitions for new talos test 'tart' to graphs.mozilla.org and graphs.allizom.org

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Joel Maher ( :jmaher ) (UTC -8)]

Here is the sql we need on both databases:

insert into tests values (NULL,"tart","Tab Animation Test",1,1,20);
insert into tests values (NULL,"tart_nochrome","Tab Animation Test, NoChrome",1,1,20);

insert into pages values (NULL, 20, "simple-open-DPI1.half.TART");
insert into pages values (NULL, 20, "simple-open-DPI1.all.TART");
insert into pages values (NULL, 20, "simple-open-DPI1.error.TART");
insert into pages values (NULL, 20, "simple-close-DPI1.half.TART");
insert into pages values (NULL, 20, "simple-close-DPI1.all.TART");
insert into pages values (NULL, 20, "simple-close-DPI1.error.TART");
insert into pages values (NULL, 20, "icon-open-DPI1.half.TART");
insert into pages values (NULL, 20, "icon-open-DPI1.all.TART");
insert into pages values (NULL, 20, "icon-open-DPI1.error.TART");
insert into pages values (NULL, 20, "icon-close-DPI1.half.TART");
insert into pages values (NULL, 20, "icon-close-DPI1.all.TART");
insert into pages values (NULL, 20, "icon-close-DPI1.error.TART");
insert into pages values (NULL, 20, "icon-open-DPI2.half.TART");
insert into pages values (NULL, 20, "icon-open-DPI2.all.TART");
insert into pages values (NULL, 20, "icon-open-DPI2.error.TART");
insert into pages values (NULL, 20, "icon-close-DPI2.half.TART");
insert into pages values (NULL, 20, "icon-close-DPI2.all.TART");
insert into pages values (NULL, 20, "icon-close-DPI2.error.TART");
insert into pages values (NULL, 20, "newtab-open-preload-no.half.TART");
insert into pages values (NULL, 20, "newtab-open-preload-no.all.TART");
insert into pages values (NULL, 20, "newtab-open-preload-no.error.TART");
insert into pages values (NULL, 20, "newtab-open-preload-yes.half.TART");
insert into pages values (NULL, 20, "newtab-open-preload-yes.all.TART");
insert into pages values (NULL, 20, "newtab-open-preload-yes.error.TART");

Comment 1

[Brandon Johnson [:cyborgshadow]]

Executed on the staging and production database.

For the record, graphs databases have different names than "graphs_mozilla_org" and "graphs_allizom_org".

See the mana page for graphs for the proper names, "graphs_mozilla_org_new" and "graphs_stage2_prod".

https://mana.mozilla.org/wiki/display/websites/graphs.mozilla.org#graphs.mozilla.org-Database