#!/bin/bash
# requires having jq installed; requires running "sortinghat init sortinghat_wm" first
PHAB_PROFILE_JSON="./foo.json"
mysql -h localhost -u user -e " USE sortinghat_wm; CREATE TABLE sync_phab_mw (phabname VARCHAR(255), phabid VARCHAR(40), phabuuid VARCHAR(40), mwname VARCHAR(255), mwid VARCHAR(40), mwuuid VARCHAR(40), randomid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);"
mysql -h localhost -u user -e " USE sortinghat_wm; INSERT INTO sync_phab_mw (mwname, mwid, mwuuid) SELECT identities.username,identities.id, identities.uuid FROM identities WHERE identities.id = identities.uuid AND identities.source = 'wikimedia:mediawiki' AND identities.username NOT LIKE '%.%.%.%' AND identities.username NOT LIKE '%:%:%:%:%:%';"
count=1
while [ $count -lt 11000 ]
do
  mwusername=$(mysql -h localhost -u user -e " USE sortinghat_wm; SELECT mwname FROM sync_phab_mw WHERE randomid = $count;");
  mwusername=${mwusername:7}
  echo '{"names":["'$mwusername'"]}' | arc call-conduit --conduit-uri https://phabricator.wikimedia.org/ --conduit-token xxxxxxxx user.mediawikiquery > $PHAB_PROFILE_JSON
  phabusername=$(more $PHAB_PROFILE_JSON | jq -r '.response[0].userName')
  if [ "$phabusername" != "null" ]; then
    mysql -h localhost -u user -e " USE sortinghat_wm; UPDATE sync_phab_mw SET phabname = (SELECT identities.username FROM identities WHERE identities.username = '$phabusername' AND identities.source = 'wikimedia:its_1') WHERE mwname = '$mwusername'; UPDATE sync_phab_mw SET phabid = (SELECT identities.id FROM identities WHERE identities.username = '$phabusername' AND identities.source = 'wikimedia:its_1') WHERE mwname = '$mwusername'; UPDATE sync_phab_mw SET phabuuid = (SELECT identities.uuid FROM identities WHERE identities.username = '$phabusername' AND identities.source = 'wikimedia:its_1') WHERE mwname = '$mwusername';"
  fi
  count=`expr $count + 1`
  sleep 8
  rm $PHAB_PROFILE_JSON
  # echo "PHABUSERNAME: " $phabusername " /// MWUSERNAME: " $mwusername
done
# then get those items and merge them in the DB: select phabid, mwid from sync_phab_mw where phabuuid != mwuuid;