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