Differential D16111 Diff 38770 resources/sql/patches/20130801.pastexactions.php

Changeset View

Standalone View

resources/sql/patches/20130801.pastexactions.php

	<?php			<?php

	$table = new PhabricatorPaste();			// Long ago, this migration populated initial "create" transactions for old
	$x_table = new PhabricatorPasteTransaction();			// pastes from before transactions came into existence. It was removed after
				// about three years.
				epriestleyAuthorUnsubmitted Not Done Inline Actions I just nuked these since they aren't too interesting and aren't even correct anymore (in modern code, they should be `TYPE_CREATE`). Didn't seem worthwhile to try to update this since it's ancient. epriestley: I just nuked these since they aren't too interesting and aren't even correct anymore (in modern…
	$conn_w = $table->establishConnection('w');
	$conn_w->openTransaction();

	echo pht('Adding transactions for existing paste objects...')."\n";

	$rows = new LiskRawMigrationIterator($conn_w, 'pastebin_paste');
	foreach ($rows as $row) {

	$id = $row['id'];
	echo pht('Adding transactions for paste id %d...', $id)."\n";

	$xaction_phid = PhabricatorPHID::generateNewPHID(
	PhabricatorApplicationTransactionTransactionPHIDType::TYPECONST);

	queryfx(
	$conn_w,
	'INSERT INTO %T (phid, authorPHID, objectPHID, viewPolicy, editPolicy,
	transactionType, oldValue, newValue,
	contentSource, metadata, dateCreated, dateModified,
	commentVersion)
	VALUES (%s, %s, %s, %s, %s, %s, %ns, %ns, %s, %s, %d, %d, %d)',
	$x_table->getTableName(),
	$xaction_phid,
	$row['authorPHID'],
	$row['phid'],
	'public',
	$row['authorPHID'],
	PhabricatorPasteTransaction::TYPE_CONTENT,
	'null',
	$row['filePHID'],
	PhabricatorContentSource::newForSource(
	PhabricatorOldWorldContentSource::SOURCECONST)->serialize(),
	'[]',
	$row['dateCreated'],
	$row['dateCreated'],
	0);

	}

	$conn_w->saveTransaction();

	echo pht('Done.')."\n";