20180910.audit.04.xactions.php
61f179ed3c29production

20180910.audit.04.xactions.php
View Options

			<?php

			$table = new PhabricatorAuditTransaction();
			$conn = $table->establishConnection('w');

			$status_map = array(
			0 => 'none',
			1 => 'needs-audit',
			2 => 'concern-raised',
			3 => 'partially-audited',
			4 => 'audited',
			5 => 'needs-verification',
			);

			$state_type = DiffusionCommitStateTransaction::TRANSACTIONTYPE;

			foreach (new LiskMigrationIterator($table) as $xaction) {
			if ($xaction->getTransactionType() !== $state_type) {
			continue;
			}

			$old_value = $xaction->getOldValue();
			$new_value = $xaction->getNewValue();

			$any_change = false;

			if (isset($status_map[$old_value])) {
			$old_value = $status_map[$old_value];
			$any_change = true;
			}

			if (isset($status_map[$new_value])) {
			$new_value = $status_map[$new_value];
			$any_change = true;
			}

			if (!$any_change) {
			continue;
			}

			queryfx(
			$conn,
			'UPDATE %T SET oldValue = %s, newValue = %s WHERE id = %d',
			$table->getTableName(),
			phutil_json_encode($old_value),
			phutil_json_encode($new_value),
			$xaction->getID());
			}