[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  echo "Populating Legalpad Documents with mail keys...\n";
   4  $table = new LegalpadDocument();
   5  $table->openTransaction();
   6  
   7  foreach (new LiskMigrationIterator($table) as $document) {
   8    $id = $document->getID();
   9  
  10    echo "Document {$id}: ";
  11    if (!$document->getMailKey()) {
  12      queryfx(
  13        $document->establishConnection('w'),
  14        'UPDATE %T SET mailKey = %s WHERE id = %d',
  15        $document->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";