Delete Authority records not referenced by an Information Object

delete_unreferenced_actors.php

<?php
// VERSION: 0.10
// Delete actors that are not users or repos and:
// - are not a name access point for any descriptons
// - are not linked via the events table - e.g. not a creator
//
// This script can be used to DELETE authority records.
//
// It will output a list of slugs that the script
// will delete. This is great for testing! The slug can be
// appended to your base URL to look at the Actor in question. e.g.
// http://10.10.10.10/rjpx-mzwk-pwls where the slug is rjpx-mzwk-pwls
//
// *WARNING - SCRIPT WILL DELETE DATA FROM ATOM* *MAKE BACKUPS FIRST!*
//
// Command: php symfony tools:run <full_path_to_this_file>

$verbose = True;
$actors = QubitActor::getOnlyActors();

foreach ($actors as $actor)
{
  if ($actor->id == QubitActor::ROOT_ID)
  {
    continue;
  }

  $eventRelations = $actor->getResourceRelations();
  $relations = getActorRelations($actor->id);

  if (count($eventRelations) == 0 && count($relations) == 0)
  {
    print("--------------\n");
    print("CAN DELETE: " . $actor->slug."\n");
    print("Events linked: " . count($eventRelations)."\n");
    print("Name acess points: " . count($relations)."\n");
    //$actor->delete();
  }

  if ((count($eventRelations) > 0 || count($relations) > 0) && $verbose)
  {
    print("--------------\n");
    print("KEEP: " . $actor->slug."\n");
    print("Events linked: " . count($eventRelations)."\n");
    print("Name acess points: " . count($relations)."\n");
  }
}

function getActorRelations($actorId)
{
  $criteria = new Criteria;
  $criteria->addJoin(QubitRelation::TYPE_ID, QubitTerm::ID);
  $criteria->add($criteria->getNewCriterion(QubitRelation::OBJECT_ID, $actorId)
    ->addAnd($criteria->getNewCriterion(QubitTerm::TAXONOMY_ID, QubitTaxonomy::RELATION_TYPE_ID))
    ->addAnd($criteria->getNewCriterion(QubitTerm::ID, QubitTerm::NAME_ACCESS_POINT_ID)));
  $criteria->addAscendingOrderByColumn(QubitRelation::TYPE_ID);
  $criteria->addDescendingOrderByColumn(QubitRelation::START_DATE);

  return QubitRelation::get($criteria);
}