ponder-mailkey-populate.php
36e2d02d6ec5master

ponder-mailkey-populate.php
View Options

			<?php

			echo pht('Populating Questions with mail keys...')."\n";
			$table = new PonderQuestion();
			$table->openTransaction();

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

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

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