SQL for reverted and changes

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

SQL for reverted and changes

Strainu
Hi,

Can someone help me with an SQL snippet for reverted changes? I know some
tools have this metric but I am not able to isolate the relevant query in
their code.

Thanks,
  Strainu
_______________________________________________
Wikitech-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: SQL for reverted and changes

Federico Leva (Nemo)
This is not a trivial query to perform. There are various strategies and
possible data sources:
https://meta.wikimedia.org/wiki/Research:Revert

If you only care about identity reverts, working with rev_sha1 might be
enough for you.

Federico

_______________________________________________
Wikitech-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: SQL for reverted and changes

Strainu
În dum., 8 sept. 2019 la 13:03, Federico Leva (Nemo)
<[hidden email]> a scris:
>
> This is not a trivial query to perform. There are various strategies and
> possible data sources:
> https://meta.wikimedia.org/wiki/Research:Revert

Thanks Frederico, that python code is very close to what (I believe) I need.

Strainu

>
> If you only care about identity reverts, working with rev_sha1 might be
> enough for you.
>
> Federico
>
> _______________________________________________
> Wikitech-l mailing list
> [hidden email]
> https://lists.wikimedia.org/mailman/listinfo/wikitech-l

_______________________________________________
Wikitech-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/wikitech-l