Differential D12797 Diff 31275 resources/sql/patches/20130507.releephrqmailkeypop.php

Changeset View

Standalone View

	<?php			<?php

	echo "Populating Releeph requests with mail keys...\n";			echo pht('Populating Releeph requests with mail keys...')."\n";

	$table = new ReleephRequest();			$table = new ReleephRequest();
	$table->openTransaction();			$table->openTransaction();

	// From ponder-mailkey-populate.php...			// From ponder-mailkey-populate.php...
	foreach (new LiskMigrationIterator($table) as $rq) {			foreach (new LiskMigrationIterator($table) as $rq) {
	$id = $rq->getID();			$id = $rq->getID();

	echo "RQ{$id}: ";			echo "RQ{$id}: ";
	if (!$rq->getMailKey()) {			if (!$rq->getMailKey()) {
	queryfx(			queryfx(
	$rq->establishConnection('w'),			$rq->establishConnection('w'),
	'UPDATE %T SET mailKey = %s WHERE id = %d',			'UPDATE %T SET mailKey = %s WHERE id = %d',
	$rq->getTableName(),			$rq->getTableName(),
	Filesystem::readRandomCharacters(20),			Filesystem::readRandomCharacters(20),
	$id);			$id);
	echo "Generated Key\n";			echo pht('Generated Key')."\n";
	} else {			} else {
	echo "-\n";			echo "-\n";
	}			}
	}			}

	$table->saveTransaction();			$table->saveTransaction();
	echo "Done.\n";			echo pht('Done.')."\n";