Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20131020.pxactionmig.php
| <?php | <?php | ||||
| $project_table = new PhabricatorProject(); | $project_table = new PhabricatorProject(); | ||||
| $conn_w = $project_table->establishConnection('w'); | $conn_w = $project_table->establishConnection('w'); | ||||
| $conn_w->openTransaction(); | $conn_w->openTransaction(); | ||||
| $src_table = 'project_legacytransaction'; | $src_table = 'project_legacytransaction'; | ||||
| $dst_table = 'project_transaction'; | $dst_table = 'project_transaction'; | ||||
| echo "Migrating Project transactions to new format...\n"; | echo pht('Migrating Project transactions to new format...')."\n"; | ||||
| $content_source = PhabricatorContentSource::newForSource( | $content_source = PhabricatorContentSource::newForSource( | ||||
| PhabricatorContentSource::SOURCE_LEGACY, | PhabricatorContentSource::SOURCE_LEGACY, | ||||
| array())->serialize(); | array())->serialize(); | ||||
| $rows = new LiskRawMigrationIterator($conn_w, $src_table); | $rows = new LiskRawMigrationIterator($conn_w, $src_table); | ||||
| foreach ($rows as $row) { | foreach ($rows as $row) { | ||||
| $id = $row['id']; | $id = $row['id']; | ||||
| $project_id = $row['projectID']; | $project_id = $row['projectID']; | ||||
| echo "Migrating transaction #{$id} (Project {$project_id})...\n"; | echo pht('Migrating transaction #%d (Project %d)...', $id, $project_id)."\n"; | ||||
| $project_row = queryfx_one( | $project_row = queryfx_one( | ||||
| $conn_w, | $conn_w, | ||||
| 'SELECT phid FROM %T WHERE id = %d', | 'SELECT phid FROM %T WHERE id = %d', | ||||
| $project_table->getTableName(), | $project_table->getTableName(), | ||||
| $project_id); | $project_id); | ||||
| if (!$project_row) { | if (!$project_row) { | ||||
| continue; | continue; | ||||
| ▲ Show 20 Lines • Show All 53 Lines • ▼ Show 20 Lines | queryfx( | ||||
| // Created, Modified | // Created, Modified | ||||
| $row['dateCreated'], | $row['dateCreated'], | ||||
| $row['dateModified']); | $row['dateModified']); | ||||
| } | } | ||||
| $conn_w->saveTransaction(); | $conn_w->saveTransaction(); | ||||
| echo "Done.\n"; | echo pht('Done.')."\n"; | ||||