Differential D12797 Diff 31275 resources/sql/patches/081.filekeys.php

Changeset View

Standalone View

	<?php			<?php

	echo "Generating file keys...\n";			echo pht('Generating file keys...')."\n";
	$table = new PhabricatorFile();			$table = new PhabricatorFile();
	$table->openTransaction();			$table->openTransaction();
	$table->beginReadLocking();			$table->beginReadLocking();

	$files = $table->loadAllWhere('secretKey IS NULL');			$files = $table->loadAllWhere('secretKey IS NULL');
	echo count($files).' files to generate keys for';			echo pht('%d files to generate keys for', count($files));
	foreach ($files as $file) {			foreach ($files as $file) {
	queryfx(			queryfx(
	$file->establishConnection('w'),			$file->establishConnection('w'),
	'UPDATE %T SET secretKey = %s WHERE id = %d',			'UPDATE %T SET secretKey = %s WHERE id = %d',
	$file->getTableName(),			$file->getTableName(),
	$file->generateSecretKey(),			$file->generateSecretKey(),
	$file->getID());			$file->getID());
	echo '.';			echo '.';
	}			}

	$table->endReadLocking();			$table->endReadLocking();
	$table->saveTransaction();			$table->saveTransaction();
	echo "\nDone.\n";			echo "\n".pht('Done.')."\n";