D21017.id50080.diff
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

D21017.id50080.diff
View Options

	diff --git a/resources/sql/autopatches/20200222.xident.01.migrate.php b/resources/sql/autopatches/20200222.xident.01.migrate.php
	new file mode 100644
	--- /dev/null
	+++ b/resources/sql/autopatches/20200222.xident.01.migrate.php
	@@ -0,0 +1,40 @@
	+<?php
	+
	+$account_table = new PhabricatorExternalAccount();
	+$identifier_table = new PhabricatorExternalAccountIdentifier();
	+
	+$conn = $account_table->establishConnection('w');
	+$table_name = $account_table->getTableName();
	+
	+$iterator = new LiskRawMigrationIterator($conn, $table_name);
	+foreach ($iterator as $account_row) {
	+ // We don't need to migrate "accountID" values for "password" accounts,
	+ // since these were dummy values in the first place and are no longer
	+ // read or written after D21014. (There would be no harm in writing these
	+ // rows, but it's easy to skip them.)
	+
	+ if ($account_row['accountType'] === 'password') {
	+ continue;
	+ }
	+
	+ $account_id = $account_row['accountID'];
	+ if (!strlen($account_id)) {
	+ continue;
	+ }
	+
	+ queryfx(
	+ $conn,
	+ 'INSERT IGNORE INTO %R (
	+ phid, externalAccountPHID, providerConfigPHID,
	+ identifierHash, identifierRaw,
	+ dateCreated, dateModified)
	+ VALUES (%s, %s, %s, %s, %s, %d, %d)',
	+ $identifier_table,
	+ $identifier_table->generatePHID(),
	+ $account_row['phid'],
	+ $account_row['providerConfigPHID'],
	+ PhabricatorHash::digestForIndex($account_id),
	+ $account_id,
	+ $account_row['dateCreated'],
	+ $account_row['dateModified']);
	+}