Differential D19427 Diff 46474 resources/sql/autopatches/20180504.owners.01.mailkey.php

Changeset View

Standalone View

				<?php

				$packages_table = new PhabricatorOwnersPackage();
				$packages_conn = $packages_table->establishConnection('w');
				$packages_name = $packages_table->getTableName();

				$properties_table = new PhabricatorMetaMTAMailProperties();
				$conn = $properties_table->establishConnection('w');

				$iterator = new LiskRawMigrationIterator($packages_conn, $packages_name);
				foreach ($iterator as $package) {
				queryfx(
				$conn,
				'INSERT IGNORE INTO %T
				(objectPHID, mailProperties, dateCreated, dateModified)
				VALUES
				(%s, %s, %d, %d)',
				$properties_table->getTableName(),
				$package['phid'],
				phutil_json_encode(
				array(
				'mailKey' => $package['mailKey'],
				)),
				PhabricatorTime::getNow(),
				PhabricatorTime::getNow());
				}