20140521.projectslug.2.mig.php
51cb7a3db9e8master

20140521.projectslug.2.mig.php
View Options

			<?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";