/** * removes deleted files that no longer exist in the filesystem from the database * * @return integer number of deleted files */ public function clearDeletedFilesFromDatabase() { if (Tinebase_Core::isLogLevel(Zend_Log::INFO)) { Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . ' Scanning database for deleted files ...'); } // get all file objects from db and check filesystem existance $filter = new Tinebase_Model_Tree_FileObjectFilter(); $start = 0; $limit = 500; $toDeleteIds = array(); do { $pagination = new Tinebase_Model_Pagination(array('start' => $start, 'limit' => $limit, 'sort' => 'id')); $fileObjects = $this->_fileObjectBackend->search($filter, $pagination); foreach ($fileObjects as $fileObject) { if ($fileObject->type == Tinebase_Model_Tree_FileObject::TYPE_FILE && $fileObject->hash && !file_exists($fileObject->getFilesystemPath())) { $toDeleteIds[] = $fileObject->getId(); } } $start += $limit; } while ($fileObjects->count() >= $limit); $nodeIdsToDelete = $this->_treeNodeBackend->search(new Tinebase_Model_Tree_Node_Filter(array(array('field' => 'object_id', 'operator' => 'in', 'value' => $toDeleteIds))), NULL, Tinebase_Backend_Sql_Abstract::IDCOL); $deleteCount = $this->_treeNodeBackend->delete($nodeIdsToDelete); if (Tinebase_Core::isLogLevel(Zend_Log::INFO)) { Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . ' Removed ' . $deleteCount . ' obsolete filenode(s) from the database.'); } return $deleteCount; }
/** * get tree node specified by parent node (or id) and name * * @param string|Tinebase_Model_Tree_Node $_parentId * @param string $_name * @throws Tinebase_Exception_InvalidArgument * @return Tinebase_Model_Tree_Node */ public function getTreeNode($_parentId, $_name) { $parentId = $_parentId instanceof Tinebase_Model_Tree_Node ? $_parentId->getId() : $_parentId; if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) { Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Getting tree node ' . $parentId . '/' . $_name); } $searchFilter = new Tinebase_Model_Tree_Node_Filter(array(array('field' => 'name', 'operator' => 'equals', 'value' => $_name), array('field' => 'parent_id', 'operator' => $parentId === null ? 'isnull' : 'equals', 'value' => $parentId))); $result = $this->_treeNodeBackend->search($searchFilter); if ($result->count() == 0) { throw new Tinebase_Exception_InvalidArgument('directory node not found'); } return $result->getFirstRecord(); }