Differential D20063 Diff 47898 resources/sql/autopatches/20190129.project.01.spaces.php

Changeset View

Standalone View

				<?php

				// See PHI1046. The "spacePHID" column for milestones may have fallen out of
				// sync; correct all existing values.

				$table = new PhabricatorProject();
				$conn = $table->establishConnection('w');
				$table_name = $table->getTableName();

				foreach (new LiskRawMigrationIterator($conn, $table_name) as $project_row) {
				queryfx(
				$conn,
				'UPDATE %R SET spacePHID = %ns
				WHERE parentProjectPHID = %s AND milestoneNumber IS NOT NULL',
				$table,
				$project_row['spacePHID'],
				$project_row['phid']);
				}