Differential D12797 Diff 31275 resources/sql/autopatches/20141113.auditdupes.php

Changeset View

Standalone View

	<?php			<?php

	$table = new PhabricatorRepositoryAuditRequest();			$table = new PhabricatorRepositoryAuditRequest();
	$conn_w = $table->establishConnection('w');			$conn_w = $table->establishConnection('w');

	echo "Removing duplicate Audit requests...\n";			echo pht('Removing duplicate Audit requests...')."\n";
	$seen_audit_map = array();			$seen_audit_map = array();
	foreach (new LiskMigrationIterator($table) as $request) {			foreach (new LiskMigrationIterator($table) as $request) {
	$commit_phid = $request->getCommitPHID();			$commit_phid = $request->getCommitPHID();
	$auditor_phid = $request->getAuditorPHID();			$auditor_phid = $request->getAuditorPHID();
	if (isset($seen_audit_map[$commit_phid][$auditor_phid])) {			if (isset($seen_audit_map[$commit_phid][$auditor_phid])) {
	$request->delete();			$request->delete();
	}			}

	if (!isset($seen_audit_map[$commit_phid])) {			if (!isset($seen_audit_map[$commit_phid])) {
	$seen_audit_map[$commit_phid] = array();			$seen_audit_map[$commit_phid] = array();
	}			}

	$seen_audit_map[$commit_phid][$auditor_phid] = 1;			$seen_audit_map[$commit_phid][$auditor_phid] = 1;
	}			}

	echo "Done.\n";			echo pht('Done.')."\n";