Differential D12797 Diff 31275 resources/sql/patches/20130801.pastexactions.php

Changeset View

Standalone View

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