Andrew Bogott has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/383935 )
Change subject: maintain-views: Add ip_changes view
......................................................................
maintain-views: Add ip_changes view
Add a new view for all wikis that exposes rows where the IPs have not
been revision deleted (Revision::DELETED_USER).
Bug: T173891
Change-Id: Ia72432daf0c81a9cdf5f5978fe54181ba5dedfe0
---
M modules/role/templates/labs/db/views/maintain-views.yaml
1 file changed, 8 insertions(+), 0 deletions(-)
Approvals:
Andrew Bogott: Looks good to me, approved
Brian Wolff: Looks good to me, but someone else must approve
jenkins-bot: Verified
diff --git a/modules/role/templates/labs/db/views/maintain-views.yaml
b/modules/role/templates/labs/db/views/maintain-views.yaml
index 8d8b8ab..7656725 100644
--- a/modules/role/templates/labs/db/views/maintain-views.yaml
+++ b/modules/role/templates/labs/db/views/maintain-views.yaml
@@ -246,6 +246,14 @@
gu_hidden, gu_registration, NULL as gu_password_reset_key, NULL as
gu_password_reset_expiration,
NULL as gu_auth_token
where: gu_hidden=''
+ ip_changes:
+ source:
+ - ip_changes
+ - revision
+ view: >
+ select ipc_rev_id, ipc_rev_timestamp, ipc_hex
+ # 4 == Revision::DELETED_USER
+ where: ipc_rev_id = rev_id AND (rev_deleted & 4) = 0
ipblocks:
source: ipblocks
view: >
--
To view, visit https://gerrit.wikimedia.org/r/383935
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ia72432daf0c81a9cdf5f5978fe54181ba5dedfe0
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: BryanDavis <bda...@wikimedia.org>
Gerrit-Reviewer: Andrew Bogott <abog...@wikimedia.org>
Gerrit-Reviewer: Brian Wolff <bawolff...@gmail.com>
Gerrit-Reviewer: Giuseppe Lavagetto <glavage...@wikimedia.org>
Gerrit-Reviewer: Marostegui <maroste...@wikimedia.org>
Gerrit-Reviewer: Rush <r...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
