better-testing

20141107.ssh.4.keymig.php
View Options

			<?php

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

			echo pht('Updating SSH public key indexes...')."\n";

			$keys = new LiskMigrationIterator($table);
			foreach ($keys as $key) {
			$id = $key->getID();

			echo pht('Updating key %d...', $id)."\n";

			try {
			$hash = $key->toPublicKey()->getHash();
			} catch (Exception $ex) {
			echo pht('Key has bad format! Removing key.')."\n";
			queryfx(
			$conn_w,
			'DELETE FROM %T WHERE id = %d',
			$table->getTableName(),
			$id);
			continue;
			}

			$collision = queryfx_all(
			$conn_w,
			'SELECT * FROM %T WHERE keyIndex = %s AND id < %d',
			$table->getTableName(),
			$hash,
			$key->getID());
			if ($collision) {
			echo pht('Key is a duplicate! Removing key.')."\n";
			queryfx(
			$conn_w,
			'DELETE FROM %T WHERE id = %d',
			$table->getTableName(),
			$id);
			continue;
			}

			queryfx(
			$conn_w,
			'UPDATE %T SET keyIndex = %s WHERE id = %d',
			$table->getTableName(),
			$hash,
			$key->getID());
			}

			echo pht('Done.')."\n";