Differential D18034 Diff 43380 resources/sql/autopatches/20141106.uniqdrafts.php

Changeset View

Standalone View

	<?php			<?php

	// Destroy duplicate drafts before storage adjustment adds a unique key to this			// This table has been removed; see T12104 for details.
	// table. See T1191. We retain the newest draft.

	// (We can't easily do this in a single SQL statement because MySQL won't let us
	// modify a table that's joined in a subquery.)

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

	$duplicates = queryfx_all(
	$conn_w,
	'SELECT DISTINCT u.id id FROM %T u
	JOIN %T v
	ON u.objectPHID = v.objectPHID
	AND u.authorPHID = v.authorPHID
	AND u.draftKey = v.draftKey
	AND u.id < v.id',
	$table->getTableName(),
	$table->getTableName());

	$duplicates = ipull($duplicates, 'id');
	foreach (PhabricatorLiskDAO::chunkSQL($duplicates) as $chunk) {
	queryfx(
	$conn_w,
	'DELETE FROM %T WHERE id IN (%Q)',
	$table->getTableName(),
	$chunk);
	}