20210316.almanac.15.intiative-mailkey.php
No OneTemporary
Actions

Size

703 B

Referenced Files

None

Subscribers

None

20210316.almanac.15.intiative-mailkey.php
View Options

	<?php

	$initiative_table = new FundInitiative();
	$initiative_conn = $initiative_table->establishConnection('w');

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

	$iterator = new LiskRawMigrationIterator(
	$initiative_conn,
	$initiative_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());
	}