Jforrester has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/397627 )
Change subject: Drop support for the Edit_11448630 schema revision
......................................................................
Drop support for the Edit_11448630 schema revision
Not been written to (except for very oddly-cached code) since
October 2015. No need to keep querying it.
Change-Id: Ibc248c45f0adb86d53df44299544639df8987eaa
---
M edit/failure_rates_by_type.sql
M edit/failure_types_by_user_type.sql
M edit/rates.sql
M edit/sessions.sql
M edit/success_by_user_type.sql
5 files changed, 0 insertions(+), 80 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-edit-data
refs/changes/27/397627/1
diff --git a/edit/failure_rates_by_type.sql b/edit/failure_rates_by_type.sql
index a540e82..75b75a9 100644
--- a/edit/failure_rates_by_type.sql
+++ b/edit/failure_rates_by_type.sql
@@ -38,23 +38,6 @@
`event_action.saveFailure.type`,
clientIp,
event_editingSessionId
- from Edit_11448630
- where
- event_editor = '{editor}' and
- ('{wiki}' = 'all' or wiki = '{wiki}') and
- timestamp >= '{from_timestamp}' and
- timestamp < '{to_timestamp}'
-
- # Add in events using the new schema. To be removed once everything
- # is switched over.
- union all
-
- select
- timestamp,
- event_action,
- `event_action.saveFailure.type`,
- clientIp,
- event_editingSessionId
from Edit_13457736
where
event_editor = '{editor}' and
diff --git a/edit/failure_types_by_user_type.sql
b/edit/failure_types_by_user_type.sql
index 22c294f..c0651ff 100644
--- a/edit/failure_types_by_user_type.sql
+++ b/edit/failure_types_by_user_type.sql
@@ -21,19 +21,6 @@
from (
( select timestamp, `event_user.class`,
`event_user.editCount`, `event_action.saveFailure.type`
- from Edit_11448630
- where
- event_editor = '{editor}' and
- ('{wiki}' = 'all' or wiki = '{wiki}') and
- timestamp >= '{from_timestamp}' and
- timestamp < '{to_timestamp}' and
- `event_action` = 'saveFailure' and
- `event_action.saveFailure.type` is not null )
-
- union all
-
- ( select timestamp, `event_user.class`,
- `event_user.editCount`, `event_action.saveFailure.type`
from Edit_13457736
where
event_editor = '{editor}' and
diff --git a/edit/rates.sql b/edit/rates.sql
index f41906a..f16e267 100644
--- a/edit/rates.sql
+++ b/edit/rates.sql
@@ -22,22 +22,6 @@
event_action,
clientIp,
event_editingSessionId
- from Edit_11448630
- where
- event_editor = '{editor}' and
- ('{wiki}' = 'all' or wiki = '{wiki}') and
- timestamp >= '{from_timestamp}' and
- timestamp < '{to_timestamp}'
-
- # Add in events using the new schema. To be removed once
everything
- # is switched over.
- union all
-
- select
- timestamp,
- event_action,
- clientIp,
- event_editingSessionId
from Edit_13457736
where
event_editor = '{editor}' and
diff --git a/edit/sessions.sql b/edit/sessions.sql
index e84f56e..fab56c9 100644
--- a/edit/sessions.sql
+++ b/edit/sessions.sql
@@ -8,22 +8,6 @@
event_action,
clientIp,
event_editingSessionId
- from Edit_11448630
- where
- event_editor = '{editor}' and
- ('{wiki}' = 'all' or wiki = '{wiki}') and
- timestamp >= '{from_timestamp}' and
- timestamp < '{to_timestamp}'
-
- # Add in events using the new schema. To be removed once
everything
- # is switched over.
- union all
-
- select
- timestamp,
- event_action,
- clientIp,
- event_editingSessionId
from Edit_13457736
where
event_editor = '{editor}' and
diff --git a/edit/success_by_user_type.sql b/edit/success_by_user_type.sql
index 6a09f0a..2f8ec97 100644
--- a/edit/success_by_user_type.sql
+++ b/edit/success_by_user_type.sql
@@ -34,24 +34,6 @@
event_editingSessionId,
`event_user.class`,
`event_user.editCount` as edit_count
- from Edit_11448630
- where
- event_editor = '{editor}' and
- ('{wiki}' = 'all' or wiki = '{wiki}') and
- timestamp >= '{from_timestamp}' and
- timestamp < '{to_timestamp}'
-
- # Add in events using the new schema. To be removed once
everything
- # is switched over.
- union all
-
- select
- timestamp,
- event_action,
- clientIp,
- event_editingSessionId,
- `event_user.class`,
- `event_user.editCount` as edit_count
from Edit_13457736
where
event_editor = '{editor}' and
--
To view, visit https://gerrit.wikimedia.org/r/397627
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ibc248c45f0adb86d53df44299544639df8987eaa
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
