Ejegg has uploaded a new change for review. (
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(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/dash
refs/changes/92/327792/1
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: newchange
Gerrit-Change-Id: Ibb3026cec2a6ce25bc82c8f0a1e5245c5f16d580
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/dash
Gerrit-Branch: master
Gerrit-Owner: Ejegg <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
