resources/sql/autopatches/20151130.phurl.mailkey.2.php

   1 <?php
   2
   3 $table = new PhabricatorPhurlURL();
   4 $conn_w = $table->establishConnection('w');
   5 $iterator = new LiskMigrationIterator($table);
   6 foreach ($iterator as $url) {
   7   $id = $url->getID();
   8
   9   echo pht('Adding mail key for Phurl %d...', $id);
  10   echo "\n";
  11
  12   queryfx(
  13     $conn_w,
  14     'UPDATE %T SET mailKey = %s WHERE id = %d',
  15     $table->getTableName(),
  16     Filesystem::readRandomCharacters(20),
  17     $id);
  18 }