Page MenuHomePhabricator
Paste P15085

lines.csv
ActivePublic

Authored by mmodell on Mar 27 2021, 1:02 AM.
Tags
None
Referenced Files
F34192752: lines.csv
Mar 27 2021, 1:02 AM
Subscribers
None
task_id, change_id, lines_deleted, lines_added
T263927,I4006d66ba467bc70d1782e481d93c49ddfbbdf8b,-5,+29
T263927,I1c6e712d301ab13c4f9f053e2df2caee206d56db,-43,+106
T258314,I8233f4d74d7f6744d64038553aae5f56c8385cd3,-21,+63
T258314,I64497a9ad6e5fe66beccdcd14967ade9cb959138,-8,+7
T258314,I8233f4d74d7f6744d64038553aae5f56c8385cd3,-21,+63
T258314,I0af9a4ef4546e2f9ab7ea21a5085b371bccd6e8a,-9,+12
T258314,I64497a9ad6e5fe66beccdcd14967ade9cb959138,-8,+7
T258314,Id7daa25e3f45cd175afd179627aadc2b345c968a,-4,+10
T234455,Ie8317b5a9d84a16c9b8820aa299059e646f68461,-144,+1396
T196906,I124391cc7b4485081980c5015431404234f40073,-1,+106
T196906,I124391cc7b4485081980c5015431404234f40073,-1,+106
T196906,Id74083fc20ddf906c40e6d149095e8ade4c68572,-0,+12
T262712,I128b4bdbec4f6bea35142153c951fd7b79617106,-97,+1026
T260959,I9ae43663a3cc736270486b6374f023978feb6983,-974,+1737
T260959,Id91849cfc9135140b04decce583234c032a742c6,-72,+4
T260959,Ie0f2f50574c0296fbe2cf5f52a51bd2ef0f06889,-72,+4
T260959,I5a00ba8fbc90aa266a6d77f15e8e398be5463ff4,-20,+192
T255507,Ibc0052b27a6d3cda3eb9663b95b4f45116dcc9f1,-43,+200
T235589,Icae5cdc5b010e23d4956269f64069c0271217af7,-3,+14
T232506,Ic3397e14578527f38d320296127040a524cb8b4b,-71,+148
T232506,I40fc8a709de96aceee14a10c973cd5b0a9a6f063,-798,+1578
T232506,I5d45579200286ff182754e9db7230e9ef801ef0f,-67,+178
T222402,Ifa3f407d7e1d0da6b3b7902c315ba65538add6ec,-10,+10
T36801,I6e7a883caee2a36c11966991b19ba93c229683cf,-2,+99
T5324,I1d4bcb1a63da2e6140bae47340fbbc4900873d3e,-0,+6

Event Timeline

created with this python code and a csv of the task data exported from phabricator as maniphest_tasks.csv

gerrit.py
import requests
import sys
import json

tid = sys.argv[1]
query = {'q': f"bug:{tid}"}
url = 'https://gerrit.wikimedia.org/r/changes/'


res = requests.get(url, params=query)
jsontxt = res.text[4:]
objs = json.loads(jsontxt)
for obj in objs:
  print(f"{tid},{obj['change_id']},-{obj['deletions']},+{obj['insertions']}")

install csvkit:

pip3 install csvkit

pass task ids to gerrit.py

csvcut -c 3 -K 1 maniphest_tasks.csv | xargs -n1 python3 gerrit.py

This could be improved to not need csvcut or for that matter to not even need a csv file at all (just query phabricator's api directly)