Differential D7715 Diff 17446 resources/sql/patches/20131205.buildstepordermig.php

Changeset View

Standalone View

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