Differential D19655 Diff 46975 resources/sql/autopatches/20180910.audit.04.xactions.php

Changeset View

Standalone View

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

				$new_value = $xaction->getNewValue();
				amckinleyUnsubmitted Not Done Inline Actions No need to update `old_value`? amckinley: No need to update `old_value`?
				epriestleyAuthorUnsubmitted Done Inline Actions Oh! Nothing ever uses the old value so I thought it wasn't populated, but I went back and double checked and it actually is. So we don't need to, but I'll update this so we do just for completeness. epriestley: Oh! Nothing ever uses the old value so I thought it wasn't populated, but I went back and…
				if (!isset($status_map[$new_value])) {
				continue;
				}

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