20131205.buildstepordermig.php
No OneTemporary
Actions

Size

1009 B

Referenced Files

None

Subscribers

None

20131205.buildstepordermig.php
View Options

	<?php

	$table = new HarbormasterBuildPlan();
	$conn_w = $table->establishConnection('w');
	$viewer = PhabricatorUser::getOmnipotentUser();

	// Since HarbormasterBuildStepQuery has been updated to handle the
	// correct order, we can't use the built in database access.

	foreach (new LiskMigrationIterator($table) as $plan) {
	$planname = $plan->getName();
	echo "Migrating steps in {$planname}...\n";

	$rows = queryfx_all(
	$conn_w,
	'SELECT id, sequence FROM harbormaster_buildstep '.
	'WHERE buildPlanPHID = %s '.
	'ORDER BY id ASC',
	$plan->getPHID());

	$sequence = 1;
	foreach ($rows as $row) {
	$id = $row['id'];
	$existing = $row['sequence'];
	if ($existing != 0) {
	echo " - {$id} (already migrated)...\n";
	continue;
	}
	echo " - {$id} to position {$sequence}...\n";
	queryfx(
	$conn_w,
	'UPDATE harbormaster_buildstep '.
	'SET sequence = %d '.
	'WHERE id = %d',
	$sequence,
	$id);
	$sequence++;
	}
	}

	echo "Done.\n";