clear_project_symbols.php

#!/usr/bin/env php
<?php

$root = dirname(dirname(dirname(__FILE__)));
require_once $root.'/scripts/__init_script__.php';

$project = id(new PhabricatorRepositoryArcanistProject())->loadOneWhere(
  'name = %s', $argv[1]);
if (!$project) {
  throw new Exception('No such arcanist project.');
}

$input = file_get_contents('php://stdin');
$normalized = array();
foreach (explode("\n", trim($input)) as $path) {
  // emulate the behavior of the symbol generation scripts
  $normalized[] = '/'.ltrim($path, './');
}
$paths = PhabricatorRepositoryCommitChangeParserWorker::lookupOrCreatePaths(
  $normalized);

$symbol = new PhabricatorRepositorySymbol();
$conn_w = $symbol->establishConnection('w');

foreach (array_chunk(array_values($paths), 128) as $chunk) {
  queryfx(
    $conn_w,
    'DELETE FROM %T WHERE arcanistProjectID = %d AND pathID IN (%Ld)',
    $symbol->getTableName(),
    $project->getID(),
    $chunk);
}