PhpOffice\PhpSpreadsheetTests\Reader\XEEValidatorTest

Complexity

Total Complexity

12

Size/Duplication

Total Lines	107
Duplicated Lines	35.51 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes	2
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	loadXEETestFile()	0	12	2
A	testInvalidXML()	0	7	1
A	providerInvalidXML()	9	9	2
A	testInvalidSimpleXML()	0	5	1
A	providerInvalidSimpleXML()	9	9	2
A	testValidXML()	0	6	1
A	providerValidXML()	9	9	2
A	testReadHyperlinks()	11	11	1

<?php

namespace PhpOffice\PhpSpreadsheetTests\Reader;

use PhpOffice\PhpSpreadsheet\Cell\DataType;
use PhpOffice\PhpSpreadsheet\Reader\BaseReader;
use PhpOffice\PhpSpreadsheet\Reader\Xml;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PHPUnit_Framework_TestCase;

class XEEValidatorTest extends PHPUnit_Framework_TestCase
{
    /**
     * @var Spreadsheet
     */
    private $spreadsheetXEETest;

    /**
     * @return Spreadsheet
     */
    protected function loadXEETestFile()
    {
        if (!$this->spreadsheetXEETest) {
            $filename = '../samples/templates/Excel2003XMLTest.xml';

            // Load into this instance
            $reader = new Xml();
            $this->spreadsheetXEETest = $reader->load($filename);
        }

        return $this->spreadsheetXEETest;
    }

    /**
     * @dataProvider providerInvalidXML
     * @expectedException \PhpOffice\PhpSpreadsheet\Reader\Exception
     *
     * @param mixed $filename
     */
    public function testInvalidXML($filename)
    {
        $reader = $this->getMockForAbstractClass(BaseReader::class);
        $expectedResult = 'FAILURE: Should throw an Exception rather than return a value';
        $result = $reader->securityScanFile($filename);
        self::assertEquals($expectedResult, $result);
    }

    public function providerInvalidXML()

This method seems to be duplicated in your project.

    {
        $tests = [];
        foreach (glob(__DIR__ . '/../../data/Reader/XEE/XEETestInvalidUTF*.xml') as $file) {
            $tests[basename($file)] = [realpath($file)];
        }

        return $tests;
    }

    /**
     * @dataProvider providerInvalidSimpleXML
     * @expectedException \PhpOffice\PhpSpreadsheet\Reader\Exception
     *
     * @param $filename
     */
    public function testInvalidSimpleXML($filename)
    {
        $xmlReader = new Xml();
        $xmlReader->trySimpleXMLLoadString($filename);
    }

    public function providerInvalidSimpleXML()

This method seems to be duplicated in your project.

    {
        $tests = [];
        foreach (glob(__DIR__ . '/../../data/Reader/XEE/XEETestInvalidSimpleXML*.xml') as $file) {
            $tests[basename($file)] = [realpath($file)];
        }

        return $tests;
    }

    /**
     * @dataProvider providerValidXML
     *
     * @param mixed $filename
     * @param mixed $expectedResult
     */
    public function testValidXML($filename, $expectedResult)
    {
        $reader = $this->getMockForAbstractClass(BaseReader::class);
        $result = $reader->securityScanFile($filename);
        self::assertEquals($expectedResult, $result);
    }

    public function providerValidXML()

This method seems to be duplicated in your project.

    {
        $tests = [];
        foreach (glob(__DIR__ . '/../../data/Reader/XEE/XEETestValid*.xml') as $file) {
            $tests[basename($file)] = [realpath($file), file_get_contents($file)];
        }

        return $tests;
    }

    /**
     * Check if it can read XML Hyperlink correctly.
     */
    public function testReadHyperlinks()

This method seems to be duplicated in your project.

    {
        $spreadsheet = $this->loadXEETestFile();
        $firstSheet = $spreadsheet->getSheet(0);

        $hyperlink = $firstSheet->getCell('L1');

        self::assertEquals(DataType::TYPE_STRING, $hyperlink->getDataType());
        self::assertEquals('PhpSpreadsheet', $hyperlink->getValue());
        self::assertEquals('http://phpspreadsheet.readthedocs.io/', $hyperlink->getHyperlink()->getUrl());
    }
}