ezsystems / ezpublish-kernel

     *

     * @param string $spiBinaryFileId

     */

    public function delete($spiBinaryFileId)

    {

        $path = $this->addPrefix($spiBinaryFileId);

        // Unlike the legacy cluster, the file is directly deleted. It was inherited from the DB cluster anyway

        $stmt = $this->db->prepare('DELETE FROM ezdfsfile WHERE name_hash LIKE :name_hash');

        $stmt->bindValue('name_hash', md5($path));

        $stmt->execute();

        if ($stmt->rowCount() != 1) {

            // Is this really necessary ?

            throw new BinaryFileNotFoundException($path);

        }

    }

    /**

     * Loads and returns metadata for $spiBinaryFileId.

     *

     * @return bool

     */

    public function exists($spiBinaryFileId)

    {

        $path = $this->addPrefix($spiBinaryFileId);

        $stmt = $this->db->prepare('SELECT name FROM ezdfsfile WHERE name_hash LIKE ? and mtime > 0 and expired != 1');

        $stmt->bindValue(1, md5($path));

        $stmt->execute();

        return ($stmt->rowCount() == 1);

    }

    /**

     * @param SPIBinaryFileCreateStruct $binaryFileCreateStruct

        return isset($this->urlDecorator) ? $this->urlDecorator->undecorate($prefixedId) : $prefixedId;

    }

    public function getMimeType($spiBinaryFileId)

    {

        $stmt = $this->db->prepare('SELECT * FROM ezdfsfile WHERE name_hash LIKE ? AND expired != 1 AND mtime > 0');

        $stmt->bindValue(1, md5($this->addPrefix($spiBinaryFileId)));

        $stmt->execute();

        if ($stmt->rowCount() == 0) {

            throw new BinaryFileNotFoundException($spiBinaryFileId);

        }

        $row = $stmt->fetch(\PDO::FETCH_ASSOC);

        return $row['datatype'];

    }

    public function deleteDirectory($spiPath)

    {

     * @param string $scope The file scope, one of 'binaryfile', 'image', 'mediafile'

     * @return int

     */

    public function count($scope)

    {

        $stmt = $this->db->prepare('SELECT count(name_hash) as count FROM ezdfsfile WHERE scope LIKE ? AND expired != 1 AND mtime > 0');

        $stmt->bindValue(1, $scope);

        $stmt->execute();

        $row = $stmt->fetch(\PDO::FETCH_ASSOC);

        return (int)$row['count'];

    }

}