Page MenuHomePhabricator

DBQ-84 Edits that were reverted by Cluebot
Closed, ResolvedPublic

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-84.
Summary: Edits that were reverted by Cluebot
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: (none)


From: Tim Sears <sears.tim@gmail.com>

Date: Thu, 17 Dec 2009 04:10:52

I would like a list of [difs] that were reverted by Cluebot. Perhaps go back 100000 reverts? Please email them to me if you could. Im not sure how much effort these queries take, so if this is too much to ask, please feel free to do a lesser amount.


Version: unspecified
Severity: minor

Details

Reference
bz59338

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:24 AM
bzimport set Reference to bz59338.

From: CBM <cbm.wikipedia@gmail.com>

Date: Thu, 17 Dec 2009 13:06:49

Are you saying you want the diff links (e.g. http://en.wikipedia.org/w/index.php?&diff=148534552&oldid=prev ) or that you want the actual contents of the diffs? The links can be generated easily. The contents of the diffs cannot be generated with a database query.

The query to make the list of diff links is

select concat('http://en.wikipedia.org/w/index.php?oldid=prev&diff=', rev_id)
from revision where rev_user_text = 'ClueBot'
and rev_comment like 'Reverting%' limit 100000;

I have sent the output to the original user.


From: Tim Sears <sears.tim@gmail.com>

Date: Thu, 17 Dec 2009 16:58:24

IM sorry, i must not have been entirely clear. I want the edit that was REVERTED by cluebot. To use the example you gave: instead of http://en.wikipedia.org/w/index.php?oldid=prev&diff=147988274 , i want http://en.wikipedia.org/w/index.php?title=Black&diff=prev&oldid=147988129 (the edit that was reverted). Thanks for your speedy response!


From: MZMcBride <mzmcbride@gmail.com>

Date: Fri, 18 Dec 2009 04:05:42

Done. Results are here: http://toolserver.org/~mzmcbride/dbq/dbq-84.txt.gz

Basically, I just scripted a query to hit the database a lot. The query was similar to:

cursor2.execute('''
SELECT
  revision1.rev_id AS cluebot,
  (SELECT revision2.rev_id FROM revision AS revision2 WHERE revision2.rev_page = %s AND revision1.rev_timestamp > revision2.rev_timestamp ORDER BY 
revision2.rev_timestamp DESC LIMIT 1) AS pre_cluebot
FROM revision AS revision1
WHERE revision1.rev_id = %s;
''' , (rev_page, rev_id))

Resolving as FIXED.

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: (none)
CC list: b@mzmcbride.com, cbm.wikipedia@gmail.com