Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20130801.pastexactions.php
| <?php | <?php | ||||
| $table = new PhabricatorPaste(); | $table = new PhabricatorPaste(); | ||||
| $x_table = new PhabricatorPasteTransaction(); | $x_table = new PhabricatorPasteTransaction(); | ||||
| $conn_w = $table->establishConnection('w'); | $conn_w = $table->establishConnection('w'); | ||||
| $conn_w->openTransaction(); | $conn_w->openTransaction(); | ||||
| echo "Adding transactions for existing paste objects...\n"; | echo pht('Adding transactions for existing paste objects...')."\n"; | ||||
| $rows = new LiskRawMigrationIterator($conn_w, 'pastebin_paste'); | $rows = new LiskRawMigrationIterator($conn_w, 'pastebin_paste'); | ||||
| foreach ($rows as $row) { | foreach ($rows as $row) { | ||||
| $id = $row['id']; | $id = $row['id']; | ||||
| echo "Adding transactions for paste id {$id}...\n"; | echo pht('Adding transactions for paste id %d...', $id)."\n"; | ||||
| $xaction_phid = PhabricatorPHID::generateNewPHID( | $xaction_phid = PhabricatorPHID::generateNewPHID( | ||||
| PhabricatorApplicationTransactionTransactionPHIDType::TYPECONST); | PhabricatorApplicationTransactionTransactionPHIDType::TYPECONST); | ||||
| queryfx( | queryfx( | ||||
| $conn_w, | $conn_w, | ||||
| 'INSERT INTO %T (phid, authorPHID, objectPHID, viewPolicy, editPolicy, | 'INSERT INTO %T (phid, authorPHID, objectPHID, viewPolicy, editPolicy, | ||||
| transactionType, oldValue, newValue, | transactionType, oldValue, newValue, | ||||
| Show All 16 Lines | queryfx( | ||||
| $row['dateCreated'], | $row['dateCreated'], | ||||
| $row['dateCreated'], | $row['dateCreated'], | ||||
| 0); | 0); | ||||
| } | } | ||||
| $conn_w->saveTransaction(); | $conn_w->saveTransaction(); | ||||
| echo "Done.\n"; | echo pht('Done.')."\n"; | ||||