resources/sql/autopatches/20210316.almanac.15.intiative-mailkey.php

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