resources/sql/autopatches/20180829.phriction.01.mailkey.php

   1 <?php
   2
   3 $document_table = new PhrictionDocument();
   4 $document_conn = $document_table->establishConnection('w');
   5 $document_name = $document_table->getTableName();
   6
   7 $properties_table = new PhabricatorMetaMTAMailProperties();
   8 $conn = $properties_table->establishConnection('w');
   9
  10 $iterator = new LiskRawMigrationIterator($document_conn, $document_name);
  11 foreach ($iterator as $row) {
  12   queryfx(
  13     $conn,
  14     'INSERT IGNORE INTO %T
  15         (objectPHID, mailProperties, dateCreated, dateModified)
  16       VALUES
  17         (%s, %s, %d, %d)',
  18     $properties_table->getTableName(),
  19     $row['phid'],
  20     phutil_json_encode(
  21       array(
  22         'mailKey' => $row['mailKey'],
  23       )),
  24     PhabricatorTime::getNow(),
  25     PhabricatorTime::getNow());
  26 }