Code Duplication - MewesK/TwigSpreadsheetBundle - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 13-14 lines in 9 locations

Tests/Twig/BasicTwigTest.php 9 locations


     *
     * @dataProvider formatProvider
     */
    public function testBlock($format)
    {
        $document = $this->getDocument('block', $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheetByName('Test');
        static::assertNotNull($sheet, 'Sheet does not exist');

        static::assertEquals('Hello', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('World', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
        static::assertEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
        static::assertEquals('Bar', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
    }

    /**
     * @param string $format

     *
     * @dataProvider formatProvider
     */
    public function testBlockOverrideCell($format)
    {
        $document = $this->getDocument('blockOverrideCell', $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheetByName('Test');
        static::assertNotNull($sheet, 'Sheet does not exist');

        static::assertEquals('Hello', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('World', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
        static::assertEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
        static::assertEquals('Bar2', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
    }

    /**
     * @param string $format

     *
     * @dataProvider formatProvider
     */
    public function testBlockOverrideContent($format)
    {
        $document = $this->getDocument('blockOverrideContent', $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheetByName('Test');
        static::assertNotNull($sheet, 'Sheet does not exist');

        static::assertEquals('Hello', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('World', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
        static::assertEquals('Foo2', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
        static::assertEquals('Bar', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
    }

    /**
     * @param string $format

     *
     * @dataProvider formatProvider
     */
    public function testBlockOverrideRow($format)
    {
        $document = $this->getDocument('blockOverrideRow', $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheetByName('Test');
        static::assertNotNull($sheet, 'Sheet does not exist');

        static::assertEquals('Hello2', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('World2', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
        static::assertEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
        static::assertEquals('Bar', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
    }

    /**
     * @param string $format

     *
     * @dataProvider formatProvider
     */
    public function testBlockOverrideSheet($format)
    {
        $document = $this->getDocument('blockOverrideSheet', $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheetByName('Test2');
        static::assertNotNull($sheet, 'Sheet does not exist');

        static::assertEquals('Hello3', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('World3', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
        static::assertNotEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
        static::assertNotEquals('Bar', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
    }

    /**
     * @param string $format

     *
     * @dataProvider formatProvider
     */
    public function testDocumentSimple($format)
    {
        $document = $this->getDocument('documentSimple', $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheetByName('Test');
        static::assertNotNull($sheet, 'Sheet does not exist');

        static::assertEquals('Foo', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('Bar', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
        static::assertEquals('Hello', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
        static::assertEquals('World', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
    }

    /**
     * @param string $format

     *
     * @dataProvider formatProvider
     */
    public function testDocumentTemplate($format)
    {
        $document = $this->getDocument('documentTemplate.'.$format, $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheet(0);
        static::assertNotNull($sheet, 'Sheet does not exist');

        static::assertEquals('Hello2', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('World', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
        static::assertEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
        static::assertEquals('Bar2', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
    }

    /**
     * @param string $format

     *
     * @dataProvider formatProvider
     */
    public function testDocumentWhitespace($format)
    {
        $document = $this->getDocument('documentWhitespace', $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheetByName('Test');
        static::assertNotNull($sheet, 'Sheet does not exist');

        static::assertEquals('Foo', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('Bar', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
        static::assertEquals('Hello', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
        static::assertEquals('World', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
    }

    /**
     * @param string $format

     *
     * @dataProvider formatProvider
     */
    public function testSheetComplex($format)
    {
        $document = $this->getDocument('sheetComplex', $format);
        static::assertNotNull($document, 'Document does not exist');

        $sheet = $document->getSheetByName('Test 1');
        static::assertNotNull($sheet, 'Sheet "Test 1" does not exist');
        static::assertEquals('Foo', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
        static::assertEquals('Bar', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');

        $sheet = $document->getSheetByName('Test 2');
        static::assertNotNull($sheet, 'Sheet "Test 2" does not exist');
        static::assertEquals('Hello World', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
    }

    /**
     * The following attributes are not supported by the readers and therefore cannot be tested:

		@@ 37-49 (lines=13) @@
34		*
35		* @dataProvider formatProvider
36		*/
37		public function testBlock($format)
38		{
39		$document = $this->getDocument('block', $format);
40		static::assertNotNull($document, 'Document does not exist');
41
42		$sheet = $document->getSheetByName('Test');
43		static::assertNotNull($sheet, 'Sheet does not exist');
44
45		static::assertEquals('Hello', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
46		static::assertEquals('World', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
47		static::assertEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
48		static::assertEquals('Bar', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
49		}
50
51		/**
52		* @param string $format
		@@ 58-70 (lines=13) @@
55		*
56		* @dataProvider formatProvider
57		*/
58		public function testBlockOverrideCell($format)
59		{
60		$document = $this->getDocument('blockOverrideCell', $format);
61		static::assertNotNull($document, 'Document does not exist');
62
63		$sheet = $document->getSheetByName('Test');
64		static::assertNotNull($sheet, 'Sheet does not exist');
65
66		static::assertEquals('Hello', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
67		static::assertEquals('World', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
68		static::assertEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
69		static::assertEquals('Bar2', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
70		}
71
72		/**
73		* @param string $format
		@@ 79-91 (lines=13) @@
76		*
77		* @dataProvider formatProvider
78		*/
79		public function testBlockOverrideContent($format)
80		{
81		$document = $this->getDocument('blockOverrideContent', $format);
82		static::assertNotNull($document, 'Document does not exist');
83
84		$sheet = $document->getSheetByName('Test');
85		static::assertNotNull($sheet, 'Sheet does not exist');
86
87		static::assertEquals('Hello', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
88		static::assertEquals('World', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
89		static::assertEquals('Foo2', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
90		static::assertEquals('Bar', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
91		}
92
93		/**
94		* @param string $format
		@@ 100-112 (lines=13) @@
97		*
98		* @dataProvider formatProvider
99		*/
100		public function testBlockOverrideRow($format)
101		{
102		$document = $this->getDocument('blockOverrideRow', $format);
103		static::assertNotNull($document, 'Document does not exist');
104
105		$sheet = $document->getSheetByName('Test');
106		static::assertNotNull($sheet, 'Sheet does not exist');
107
108		static::assertEquals('Hello2', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
109		static::assertEquals('World2', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
110		static::assertEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
111		static::assertEquals('Bar', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
112		}
113
114		/**
115		* @param string $format
		@@ 121-133 (lines=13) @@
118		*
119		* @dataProvider formatProvider
120		*/
121		public function testBlockOverrideSheet($format)
122		{
123		$document = $this->getDocument('blockOverrideSheet', $format);
124		static::assertNotNull($document, 'Document does not exist');
125
126		$sheet = $document->getSheetByName('Test2');
127		static::assertNotNull($sheet, 'Sheet does not exist');
128
129		static::assertEquals('Hello3', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
130		static::assertEquals('World3', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
131		static::assertNotEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
132		static::assertNotEquals('Bar', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
133		}
134
135		/**
136		* @param string $format
		@@ 330-342 (lines=13) @@
327		*
328		* @dataProvider formatProvider
329		*/
330		public function testDocumentSimple($format)
331		{
332		$document = $this->getDocument('documentSimple', $format);
333		static::assertNotNull($document, 'Document does not exist');
334
335		$sheet = $document->getSheetByName('Test');
336		static::assertNotNull($sheet, 'Sheet does not exist');
337
338		static::assertEquals('Foo', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
339		static::assertEquals('Bar', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
340		static::assertEquals('Hello', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
341		static::assertEquals('World', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
342		}
343
344		/**
345		* @param string $format
		@@ 351-363 (lines=13) @@
348		*
349		* @dataProvider formatProvider
350		*/
351		public function testDocumentTemplate($format)
352		{
353		$document = $this->getDocument('documentTemplate.'.$format, $format);
354		static::assertNotNull($document, 'Document does not exist');
355
356		$sheet = $document->getSheet(0);
357		static::assertNotNull($sheet, 'Sheet does not exist');
358
359		static::assertEquals('Hello2', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
360		static::assertEquals('World', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
361		static::assertEquals('Foo', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
362		static::assertEquals('Bar2', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
363		}
364
365		/**
366		* @param string $format
		@@ 372-384 (lines=13) @@
369		*
370		* @dataProvider formatProvider
371		*/
372		public function testDocumentWhitespace($format)
373		{
374		$document = $this->getDocument('documentWhitespace', $format);
375		static::assertNotNull($document, 'Document does not exist');
376
377		$sheet = $document->getSheetByName('Test');
378		static::assertNotNull($sheet, 'Sheet does not exist');
379
380		static::assertEquals('Foo', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
381		static::assertEquals('Bar', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
382		static::assertEquals('Hello', $sheet->getCell('A2')->getValue(), 'Unexpected value in A2');
383		static::assertEquals('World', $sheet->getCell('B2')->getValue(), 'Unexpected value in B2');
384		}
385
386		/**
387		* @param string $format
		@@ 482-495 (lines=14) @@
479		*
480		* @dataProvider formatProvider
481		*/
482		public function testSheetComplex($format)
483		{
484		$document = $this->getDocument('sheetComplex', $format);
485		static::assertNotNull($document, 'Document does not exist');
486
487		$sheet = $document->getSheetByName('Test 1');
488		static::assertNotNull($sheet, 'Sheet "Test 1" does not exist');
489		static::assertEquals('Foo', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
490		static::assertEquals('Bar', $sheet->getCell('B1')->getValue(), 'Unexpected value in B1');
491
492		$sheet = $document->getSheetByName('Test 2');
493		static::assertNotNull($sheet, 'Sheet "Test 2" does not exist');
494		static::assertEquals('Hello World', $sheet->getCell('A1')->getValue(), 'Unexpected value in A1');
495		}
496
497		/**
498		* The following attributes are not supported by the readers and therefore cannot be tested:

MewesK / TwigSpreadsheetBundle

GitHub Access Token became invalid

Code Duplication Length = 13-14 lines in 9 locations

Tests/Twig/BasicTwigTest.php 9 locations