Ejegg has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/327792 )
Change subject: Stop inserting extra 'A/B testing' boards ...................................................................... Stop inserting extra 'A/B testing' boards Change-Id: Ibb3026cec2a6ce25bc82c8f0a1e5245c5f16d580 --- M schema/0002_abtesting.sql 1 file changed, 6 insertions(+), 5 deletions(-) Approvals: Mepps: Looks good to me, approved jenkins-bot: Verified diff --git a/schema/0002_abtesting.sql b/schema/0002_abtesting.sql index f632a71..37d3d0a 100644 --- a/schema/0002_abtesting.sql +++ b/schema/0002_abtesting.sql @@ -6,13 +6,14 @@ insert ignore into dash_user (id, display_name) value (1, 'Dev User'); --- TODO: Make idempotent +set @board_count = ( select count(*) FROM dash_board WHERE display_name='A/B Testing' AND owner_id = 1 ); + insert ignore into dash_board (display_name, description, owner_id, is_shared) - values ('A/B Testing', 'Banner A/B test results', 1, true); + SELECT 'A/B Testing', 'Banner A/B test results', 1, 1 + FROM dash_user u + WHERE id = 1 AND @board_count = 0; -set @bid = (select id from dash_board where display_name = 'A/B Testing'); - -update dash_user set default_board = @bid where id = 1; +set @bid = (select id from dash_board where owner_id = 1 AND display_name = 'A/B Testing'); insert ignore into dash_widget_instance (widget_id, owner_id, display_name, is_shared) select @wid, 1, display_name, 1 from dash_widget where id = @wid; -- To view, visit https://gerrit.wikimedia.org/r/327792 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ibb3026cec2a6ce25bc82c8f0a1e5245c5f16d580 Gerrit-PatchSet: 2 Gerrit-Project: wikimedia/fundraising/dash Gerrit-Branch: master Gerrit-Owner: Ejegg <ej...@ejegg.com> Gerrit-Reviewer: AndyRussG <andrew.green...@gmail.com> Gerrit-Reviewer: Cdentinger <cdentin...@wikimedia.org> Gerrit-Reviewer: Eileen <emcnaugh...@wikimedia.org> Gerrit-Reviewer: Ejegg <ej...@ejegg.com> Gerrit-Reviewer: Katie Horn <kh...@wikimedia.org> Gerrit-Reviewer: Mepps <me...@wikimedia.org> Gerrit-Reviewer: XenoRyet <dkozlow...@wikimedia.org> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits