Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/autopatches/20181219.pholio.02.imagemigrate.php
- This file was added.
<?php | |||||
// Old images used a "mockID" instead of a "mockPHID" to reference mocks. | |||||
// Set the "mockPHID" column to the value that corresponds to the "mockID". | |||||
$image = new PholioImage(); | |||||
$mock = new PholioMock(); | |||||
$conn = $image->establishConnection('w'); | |||||
$iterator = new LiskRawMigrationIterator($conn, $image->getTableName()); | |||||
foreach ($iterator as $image_row) { | |||||
if ($image_row['mockPHID']) { | |||||
continue; | |||||
} | |||||
$mock_id = $image_row['mockID']; | |||||
$mock_row = queryfx_one( | |||||
$conn, | |||||
'SELECT phid FROM %R WHERE id = %d', | |||||
$mock, | |||||
$mock_id); | |||||
if (!$mock_row) { | |||||
continue; | |||||
} | |||||
queryfx( | |||||
$conn, | |||||
'UPDATE %R SET mockPHID = %s WHERE id = %d', | |||||
$image, | |||||
$mock_row['phid'], | |||||
$image_row['id']); | |||||
} |