Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/autopatches/20210316.almanac.01.device-mailkey.php
- This file was added.
| <?php | |||||
| $device_table = new AlmanacDevice(); | |||||
| $device_conn = $device_table->establishConnection('w'); | |||||
| $properties_table = new PhabricatorMetaMTAMailProperties(); | |||||
| $conn = $properties_table->establishConnection('w'); | |||||
| $iterator = new LiskRawMigrationIterator( | |||||
| $device_conn, | |||||
| $device_table->getTableName()); | |||||
| foreach ($iterator as $row) { | |||||
| queryfx( | |||||
| $conn, | |||||
| 'INSERT IGNORE INTO %R | |||||
| (objectPHID, mailProperties, dateCreated, dateModified) | |||||
| VALUES | |||||
| (%s, %s, %d, %d)', | |||||
| $properties_table, | |||||
| $row['phid'], | |||||
| phutil_json_encode( | |||||
| array( | |||||
| 'mailKey' => $row['mailKey'], | |||||
| )), | |||||
| PhabricatorTime::getNow(), | |||||
| PhabricatorTime::getNow()); | |||||
| } | |||||