131.migraterevisionquery.php
No OneTemporary
Actions

Size

802 B

Referenced Files

None

Subscribers

None

131.migraterevisionquery.php
View Options

	<?php

	$table = new DifferentialRevision();
	$table->openTransaction();
	$table->beginReadLocking();
	$conn_w = $table->establishConnection('w');

	echo 'Migrating revisions';
	do {
	$revisions = $table->loadAllWhere('branchName IS NULL LIMIT 1000');

	foreach ($revisions as $revision) {
	echo '.';

	$diff = $revision->loadActiveDiff();
	if (!$diff) {
	continue;
	}

	$branch_name = $diff->getBranch();
	$arc_project_phid = $diff->getArcanistProjectPHID();

	queryfx(
	$conn_w,
	'UPDATE %T SET branchName = %s, arcanistProjectPHID = %s WHERE id = %d',
	$table->getTableName(),
	$branch_name,
	$arc_project_phid,
	$revision->getID());
	}
	} while (count($revisions) == 1000);

	$table->endReadLocking();
	$table->saveTransaction();
	echo "\nDone.\n";