20141113.auditdupes.php
310373ebc43fproduction

20141113.auditdupes.php
View Options

			<?php

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

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

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

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

			echo "Done.\n";