20130801.pastexactions.php
bd7420c4bb7eproduction

20130801.pastexactions.php
View Options

			<?php

			$table = new PhabricatorPaste();
			$x_table = new PhabricatorPasteTransaction();

			$conn_w = $table->establishConnection('w');
			$conn_w->openTransaction();

			echo "Adding transactions for existing paste objects...\n";

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

			$id = $row['id'];
			echo "Adding transactions for paste id {$id}...\n";

			$xaction_phid = PhabricatorPHID::generateNewPHID(
			PhabricatorApplicationTransactionPHIDTypeTransaction::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(
			PhabricatorContentSource::SOURCE_LEGACY,
			array())->serialize(),
			'[]',
			$row['dateCreated'],
			$row['dateCreated'],
			0);

			}

			$conn_w->saveTransaction();

			echo "Done.\n";