Jforrester has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/397628 )
Change subject: Swap archaïc code to use current tables
......................................................................
Swap archaïc code to use current tables
Not sure these are run, but at least they'll now have data.
Change-Id: Ib925704b9df2fa8cb2fb8a302aa13ded5ea812c8
---
M edit/aborts.sql
M edit/aborts_rates.sql
M edit/action.sql
M edit/saves.sql
M edit/saves_rates.sql
M edit/saves_rates_comparative_attempts.sql
M edit/saves_rates_comparative_success_attempts.sql
M edit/saves_rates_comparative_successes.sql
8 files changed, 16 insertions(+), 16 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-edit-data
refs/changes/28/397628/1
diff --git a/edit/aborts.sql b/edit/aborts.sql
index 9375773..34f617f 100644
--- a/edit/aborts.sql
+++ b/edit/aborts.sql
@@ -18,7 +18,7 @@
`event_action.abort.type`,
timestamp
- FROM Edit_10604157
+ FROM Edit_13457736
WHERE event_action = 'abort' OR event_action = 'ready' OR
event_action = 'init'
@@ -30,7 +30,7 @@
`event_action.abort.type`,
timestamp
- FROM Edit_10676603
+ FROM Edit_17520312
WHERE event_action = 'abort' OR event_action = 'ready' OR
event_action = 'init'
diff --git a/edit/aborts_rates.sql b/edit/aborts_rates.sql
index 6453e2f..0839cb3 100644
--- a/edit/aborts_rates.sql
+++ b/edit/aborts_rates.sql
@@ -29,7 +29,7 @@
`event_action.abort.type`,
timestamp
- FROM Edit_10604157
+ FROM Edit_13457736
WHERE event_action = 'abort' OR event_action = 'ready' OR
event_action = 'init'
@@ -41,7 +41,7 @@
`event_action.abort.type`,
timestamp
- FROM Edit_10676603
+ FROM Edit_17520312
WHERE event_action = 'abort' OR event_action = 'ready' OR
event_action = 'init'
diff --git a/edit/action.sql b/edit/action.sql
index 6da5e4d..b6d3339 100644
--- a/edit/action.sql
+++ b/edit/action.sql
@@ -9,13 +9,13 @@
from (select event_action,
timestamp
- from Edit_10604157
+ from Edit_13457736
union all
select event_action,
timestamp
- from Edit_10676603
+ from Edit_17520312
) valid_edit_schema_revisions
group by day
diff --git a/edit/saves.sql b/edit/saves.sql
index 4cf48fe..a86b70d 100644
--- a/edit/saves.sql
+++ b/edit/saves.sql
@@ -13,7 +13,7 @@
event_action,
timestamp
- FROM Edit_10604157
+ FROM Edit_13457736
UNION ALL
@@ -22,7 +22,7 @@
event_action,
timestamp
- FROM Edit_10676603
+ FROM Edit_17520312
) AS valid_edit_schema_revisions
diff --git a/edit/saves_rates.sql b/edit/saves_rates.sql
index 6fe014e..ead2f0e 100644
--- a/edit/saves_rates.sql
+++ b/edit/saves_rates.sql
@@ -22,7 +22,7 @@
event_action,
timestamp
- FROM Edit_10604157
+ FROM Edit_13457736
UNION ALL
@@ -31,7 +31,7 @@
event_action,
timestamp
- FROM Edit_10676603
+ FROM Edit_17520312
) AS valid_edit_schema_revisions
diff --git a/edit/saves_rates_comparative_attempts.sql
b/edit/saves_rates_comparative_attempts.sql
index b514bf6..728f0e0 100644
--- a/edit/saves_rates_comparative_attempts.sql
+++ b/edit/saves_rates_comparative_attempts.sql
@@ -35,7 +35,7 @@
wiki,
timestamp
- FROM Edit_10604157
+ FROM Edit_13457736
UNION ALL
@@ -45,7 +45,7 @@
wiki,
timestamp
- FROM Edit_10676603
+ FROM Edit_17520312
) AS valid_edit_schema_revisions
diff --git a/edit/saves_rates_comparative_success_attempts.sql
b/edit/saves_rates_comparative_success_attempts.sql
index ba86e53..25aebee 100644
--- a/edit/saves_rates_comparative_success_attempts.sql
+++ b/edit/saves_rates_comparative_success_attempts.sql
@@ -35,7 +35,7 @@
wiki,
timestamp
- FROM Edit_10604157
+ FROM Edit_13457736
UNION ALL
@@ -45,7 +45,7 @@
wiki,
timestamp
- FROM Edit_10676603
+ FROM Edit_17520312
) AS valid_edit_schema_revisions
diff --git a/edit/saves_rates_comparative_successes.sql
b/edit/saves_rates_comparative_successes.sql
index 6728ad0..3cedf6c 100644
--- a/edit/saves_rates_comparative_successes.sql
+++ b/edit/saves_rates_comparative_successes.sql
@@ -35,7 +35,7 @@
wiki,
timestamp
- FROM Edit_10604157
+ FROM Edit_13457736
UNION ALL
@@ -45,7 +45,7 @@
wiki,
timestamp
- FROM Edit_10676603
+ FROM Edit_17520312
) AS valid_edit_schema_revisions
--
To view, visit https://gerrit.wikimedia.org/r/397628
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib925704b9df2fa8cb2fb8a302aa13ded5ea812c8
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-edit-data
Gerrit-Branch: master
Gerrit-Owner: Jforrester <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
