[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  echo "Populating Questions with mail keys...\n";
   4  $table = new PonderQuestion();
   5  $table->openTransaction();
   6  
   7  foreach (new LiskMigrationIterator($table) as $question) {
   8    $id = $question->getID();
   9  
  10    echo "Question {$id}: ";
  11    if (!$question->getMailKey()) {
  12      queryfx(
  13        $question->establishConnection('w'),
  14        'UPDATE %T SET mailKey = %s WHERE id = %d',
  15        $question->getTableName(),
  16        Filesystem::readRandomCharacters(20),
  17        $id);
  18      echo "Generated Key\n";
  19    } else {
  20      echo "-\n";
  21    }
  22  }
  23  
  24  $table->saveTransaction();
  25  echo "Done.\n";