better-testing

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