delete-old-enterprise-staging-backups.php

<?php

require_once 'abstract.php';

class Shell_Delete_Old_Enterprise_Staging_Backups extends Mage_Shell_Abstract
{
    public function run()
    {
        $actions = Mage::getModel("enterprise_staging/staging_action")->getCollection()
            ->addFieldToFilter("type", "backup")
            ->addFieldToFilter("status", "completed")
            ->addFieldToFilter("updated_at", array("lt"=>date("Y-m-d H:i:s", strtotime("-7days"))))
            ->setOrder("updated_at", "ASC");
        foreach ($actions as $action) {
            echo "Removed staging backup {$action->getId()} {$action->getUpdatedAt()} {$action->getStagingTablePrefix()}\n";
            $action->setIsDeleteTables(true);
            $action->delete();
        }
    }
}

$shell = new Shell_Delete_Old_Enterprise_Staging_Backups();
$shell->run();