20180830.phriction.02.maxes.php
3b1294cf4599master

20180830.phriction.02.maxes.php
View Options

			<?php

			// Populate the "maxVersion" column by copying the maximum "version" from the
			// content table.

			$document_table = new PhrictionDocument();
			$content_table = new PhrictionContent();

			$conn = $document_table->establishConnection('w');

			$iterator = new LiskRawMigrationIterator(
			$conn,
			$document_table->getTableName());
			foreach ($iterator as $row) {
			$content = queryfx_one(
			$conn,
			'SELECT MAX(version) max FROM %T WHERE documentPHID = %s',
			$content_table->getTableName(),
			$row['phid']);
			if (!$content) {
			continue;
			}

			queryfx(
			$conn,
			'UPDATE %T SET maxVersion = %d WHERE id = %d',
			$document_table->getTableName(),
			$content['max'],
			$row['id']);
			}