Last modified: 2014-01-03 15:49:26 UTC
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.
------------------------------------------------------------------------------- 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
