Differential D15327 Diff 36968 resources/sql/autopatches/20160222.almanac.1.properties.php

Changeset View

Standalone View

				<?php

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

				// We're going to JSON-encode the value in each row: previously rows stored
				// plain strings, but now they store JSON, so we need to update them.

				foreach (new LiskMigrationIterator($table) as $property) {
				$key = $property->getFieldName();

				$current_row = queryfx_one(
				$conn_w,
				'SELECT fieldValue FROM %T WHERE id = %d',
				$table->getTableName(),
				$property->getID());

				if (!$current_row) {
				continue;
				}

				queryfx(
				$conn_w,
				'UPDATE %T SET fieldValue = %s WHERE id = %d',
				$table->getTableName(),
				phutil_json_encode($current_row['fieldValue']),
				$property->getID());
				}