20140521.projectslug.2.mig.php
No OneTemporary
Actions

Subscribers

None

File Metadata

	<?php

	$project_table = new PhabricatorProject();
	$table_name = $project_table->getTableName();
	$conn_w = $project_table->establishConnection('w');
	$slug_table_name = id(new PhabricatorProjectSlug())->getTableName();
	$time = PhabricatorTime::getNow();

	echo pht('Migrating projects to slugs...')."\n";
	foreach (new LiskMigrationIterator($project_table) as $project) {
	$id = $project->getID();

	echo pht('Migrating project %d...', $id)."\n";

	$slug_text = PhabricatorSlug::normalizeProjectSlug($project->getName());
	$slug = id(new PhabricatorProjectSlug())
	->loadOneWhere('slug = %s', $slug_text);

	if ($slug) {
	echo pht('Already migrated %d... Continuing.', $id)."\n";
	continue;
	}

	queryfx(
	$conn_w,
	'INSERT INTO %T (projectPHID, slug, dateCreated, dateModified) '.
	'VALUES (%s, %s, %d, %d)',
	$slug_table_name,
	$project->getPHID(),
	$slug_text,
	$time,
	$time);
	echo pht('Migrated %d.', $id)."\n";
	}

	echo pht('Done.')."\n";