root/branches/1.0/batch/orphan_tags.php

<?php
error_reporting(E_ALL);
$app = 'main';
$sf_root = dirname(__FILE__).'/..';
include($sf_root.'/test/bootstrap/functional.php');
include($sf_root.'/lib/symfony/vendor/pake/pakeFunction.php');

// initialize database manager
$databaseManager = new sfDatabaseManager();
$databaseManager->initialize();
$con = Propel::getConnection();

$tags = TagPeer::doSelect(new Criteria);

foreach ($tags as $tag)
{
  $is_orphan = false;
  $c = new Criteria;
  $c->add(TaggingPeer::TAG_ID, $tag->getId());
  $taggings = TaggingPeer::doSelect($c);
  if (count($taggings) == 0)
  {
    $is_orphan = true;
  }
  foreach ($taggings as $tagging)
  {
    $peer = $tagging->getTaggableModel().'Peer';
    if (!class_exists($peer))
    {
      pake_echo_action('unexistant model', $tagging->getTaggableModel());
      $is_orphan = true;
    }
    $object = call_user_func(array($tagging->getTaggableModel().'Peer', 
                                   'retrieveByPK'), 
                             $tagging->getTaggableId());
    if (!$object)
    {
      pake_echo_action('delete orphan tagging', $tag->getName().' for '.$tagging->getTaggableModel().'/'.$tagging->getTaggableId());
      $tagging->delete();
    }
  }
  if ($is_orphan)
  {
    pake_echo_action('delete orphan tag', $tag->getName());
    $tag->delete();
  }
}