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:

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