hoo's T132839-Workarounds.sh
ActivePublic
Actions

Authored by hoo on May 27 2017, 5:52 PM.

Tags

None

Referenced Files

	F8201261: hoo's T132839-Workarounds.sh
	May 27 2017, 5:52 PM

Subscribers

None

	#!/bin/bash
	echo -n 'Removing ext ids in item context '

	i=0
	while [ $i -lt 35 ]; do
	echo -n '.'
	sql --write wikidatawiki -e "DELETE FROM wbs_propertypairs WHERE pid1 IN (SELECT pi_property_id FROM wb_property_info WHERE pi_type = 'external-id') AND context = 'item' LIMIT 5000"
	let i++
	sleep 3
	done

	pids=(17 18 276 301 373 463 495 571 641 1344 1448 1476)

	for pid in "${pids[@]}"; do
	echo
	echo "Removing P$pid item context"
	sql --write wikidatawiki -e "DELETE FROM wbs_propertypairs WHERE pid1 = '$pid' AND context = 'item' LIMIT 5000"
	done

	echo
	echo "Removing P31 qualifier suggestions for P569, P570, P571, P576"
	sql --write wikidatawiki -e "DELETE FROM wbs_propertypairs WHERE context = 'qualifier' AND pid1 IN(569, 570, 571, 576) AND pid2 = 31 LIMIT 5000"

hoo's T132839-Workarounds.shActivePublicActions