20131205.buildstepordermig.php
No OneTemporary
Actions

Subscribers

None

File Metadata

	<?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";