DateIntervalTest::testNegativeDateIntervalConvertsToDatabaseValue() - Code Metrics - Inspection of "DateIntervalType (negative support) resolves doctr..." - doctrine/dbal - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#2579)

by Luís

created 2017-07-23 02:25 UTC

testNegativeDateIntervalConvertsToDatabaseValue() A

↳ Parent: DateIntervalTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	10
Code Lines	6

Duplication

Lines	10
Ratio	100 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
dl	10
loc	10
rs	9.4285
c	1
b	0
f	0
cc	1
eloc	6
nc	1
nop	0

<?php

namespace Doctrine\Tests\DBAL\Types;

use Doctrine\DBAL\Types\Type;
use Doctrine\Tests\DBAL\Mocks\MockPlatform;

class DateIntervalTest  extends \Doctrine\Tests\DbalTestCase

{
    /**
     * @var MockPlatform
     */
    private $platform;

    /**
     * @var \Doctrine\DBAL\Types\DateIntervalType
     */
    private $type;

    /**
     * {@inheritDoc}
     */
    protected function setUp()
    {
        $this->platform = new MockPlatform();
        $this->type     = Type::getType('dateinterval');

        $this->assertInstanceOf('Doctrine\DBAL\Types\DateIntervalType', $this->type);
    }

    public function testDateIntervalConvertsToDatabaseValue()

    {
        $interval = new \DateInterval('P2Y1DT1H2M3S');

        $expected = '+P02Y00M01DT01H02M03S';
        $actual = $this->type->convertToDatabaseValue($interval, $this->platform);

        $this->assertEquals($expected, $actual);
    }

    public function testDateIntervalConvertsToPHPValue()
    {
        $interval = $this->type->convertToPHPValue('+P02Y00M01DT01H02M03S', $this->platform);
        $this->assertInstanceOf('DateInterval', $interval);
        $this->assertEquals('+P02Y00M01DT01H02M03S', $interval->format('%RP%YY%MM%DDT%HH%IM%SS'));
    }

    public function testNegativeDateIntervalConvertsToDatabaseValue()

    {
        $interval = new \DateInterval('P2Y1DT1H2M3S');
        $interval->invert = 1;

        $expected = '-P02Y00M01DT01H02M03S';
        $actual = $this->type->convertToDatabaseValue($interval, $this->platform);

        $this->assertEquals($expected, $actual);
    }

    public function testNegativeDateIntervalConvertsToPHPValue()
    {
        $interval = $this->type->convertToPHPValue('-P02Y00M01DT01H02M03S', $this->platform);
        $this->assertInstanceOf('DateInterval', $interval);
        $this->assertEquals('-P02Y00M01DT01H02M03S', $interval->format('%RP%YY%MM%DDT%HH%IM%SS'));
    }

    public function testInvalidDateIntervalFormatConversion()
    {
        $this->setExpectedException('Doctrine\DBAL\Types\ConversionException');

        $this->type->convertToPHPValue('abcdefg', $this->platform);
    }

    public function testDateIntervalNullConversion()
    {
        $this->assertNull($this->type->convertToPHPValue(null, $this->platform));
    }

    /**
     * @group DBAL-1288
     */
    public function testRequiresSQLCommentHint()
    {
        $this->assertTrue($this->type->requiresSQLCommentHint($this->platform));
    }

    /**
     * @dataProvider invalidPHPValuesProvider
     *
     * @param mixed $value
     */
    public function testInvalidTypeConversionToDatabaseValue($value)
    {
        $this->setExpectedException('Doctrine\DBAL\Types\ConversionException');


        $this->type->convertToDatabaseValue($value, $this->platform);
    }

    /**
     * @return mixed[][]
     */
    public function invalidPHPValuesProvider()

    {
        return [
            [0],
            [''],
            ['foo'],
            ['10:11:12'],
            ['2015-01-31'],
            ['2015-01-31 10:11:12'],
            [new \stdClass()],
            [$this],
            [27],
            [-1],
            [1.2],
            [[]],
            [['an array']],
            [new \DateTime()],
        ];
    }
}


1		<?php
2
3		namespace Doctrine\Tests\DBAL\Types;
4
5		use Doctrine\DBAL\Types\Type;
6		use Doctrine\Tests\DBAL\Mocks\MockPlatform;
7
8		class DateIntervalTest extends \Doctrine\Tests\DbalTestCase
		0 ignored issues – show Coding Style introduced 2017-06-29 19:35 UTC by Report Bug Copy Issue Report Expected 1 space after class name; 2 found Loading history... Coding Style introduced 2017-06-29 19:35 UTC by Report Bug Copy Issue Report Expected 1 space before extends keyword; 2 found Loading history...
9		{
10		/**
11		* @var MockPlatform
12		*/
13		private $platform;
14
15		/**
16		* @var \Doctrine\DBAL\Types\DateIntervalType
17		*/
18		private $type;
19
20		/**
21		* {@inheritDoc}
22		*/
23		protected function setUp()
24		{
25		$this->platform = new MockPlatform();
26		$this->type = Type::getType('dateinterval');
27
28		$this->assertInstanceOf('Doctrine\DBAL\Types\DateIntervalType', $this->type);
29		}
30
31	View Code Duplication	public function testDateIntervalConvertsToDatabaseValue()
		0 ignored issues – show Duplication introduced 2017-06-29 19:35 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
32		{
33		$interval = new \DateInterval('P2Y1DT1H2M3S');
34
35		$expected = '+P02Y00M01DT01H02M03S';
36		$actual = $this->type->convertToDatabaseValue($interval, $this->platform);
37
38		$this->assertEquals($expected, $actual);
39		}
40
41		public function testDateIntervalConvertsToPHPValue()
42		{
43		$interval = $this->type->convertToPHPValue('+P02Y00M01DT01H02M03S', $this->platform);
44		$this->assertInstanceOf('DateInterval', $interval);
45		$this->assertEquals('+P02Y00M01DT01H02M03S', $interval->format('%RP%YY%MM%DDT%HH%IM%SS'));
46		}
47
48	View Code Duplication	public function testNegativeDateIntervalConvertsToDatabaseValue()
		0 ignored issues – show Duplication introduced 2017-06-30 12:09 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
49		{
50		$interval = new \DateInterval('P2Y1DT1H2M3S');
51		$interval->invert = 1;
52
53		$expected = '-P02Y00M01DT01H02M03S';
54		$actual = $this->type->convertToDatabaseValue($interval, $this->platform);
55
56		$this->assertEquals($expected, $actual);
57		}
58
59		public function testNegativeDateIntervalConvertsToPHPValue()
60		{
61		$interval = $this->type->convertToPHPValue('-P02Y00M01DT01H02M03S', $this->platform);
62		$this->assertInstanceOf('DateInterval', $interval);
63		$this->assertEquals('-P02Y00M01DT01H02M03S', $interval->format('%RP%YY%MM%DDT%HH%IM%SS'));
64		}
65
66		public function testInvalidDateIntervalFormatConversion()
67		{
68		$this->setExpectedException('Doctrine\DBAL\Types\ConversionException');
		0 ignored issues – show Deprecated Code introduced 2017-06-29 19:35 UTC by Report Bug Copy Issue Report The method `PHPUnit_Framework_TestCase::setExpectedException()` has been deprecated with message: Method deprecated since Release 5.2.0; use expectException() instead This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
69		$this->type->convertToPHPValue('abcdefg', $this->platform);
70		}
71
72		public function testDateIntervalNullConversion()
73		{
74		$this->assertNull($this->type->convertToPHPValue(null, $this->platform));
75		}
76
77		/**
78		* @group DBAL-1288
79		*/
80		public function testRequiresSQLCommentHint()
81		{
82		$this->assertTrue($this->type->requiresSQLCommentHint($this->platform));
83		}
84
85		/**
86		* @dataProvider invalidPHPValuesProvider
87		*
88		* @param mixed $value
89		*/
90		public function testInvalidTypeConversionToDatabaseValue($value)
91		{
92		$this->setExpectedException('Doctrine\DBAL\Types\ConversionException');
		0 ignored issues – show Deprecated Code introduced 2017-06-29 19:35 UTC by Report Bug Copy Issue Report The method `PHPUnit_Framework_TestCase::setExpectedException()` has been deprecated with message: Method deprecated since Release 5.2.0; use expectException() instead This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
93
94		$this->type->convertToDatabaseValue($value, $this->platform);
95		}
96
97		/**
98		* @return mixed[][]
99		*/
100	View Code Duplication	public function invalidPHPValuesProvider()
		0 ignored issues – show Duplication introduced 2017-06-29 19:35 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
101		{
102		return [
103		[0],
104		[''],
105		['foo'],
106		['10:11:12'],
107		['2015-01-31'],
108		['2015-01-31 10:11:12'],
109		[new \stdClass()],
110		[$this],
111		[27],
112		[-1],
113		[1.2],
114		[[]],
115		[['an array']],
116		[new \DateTime()],
117		];
118		}
119		}
120

doctrine / dbal

Pull Request — master (#2579)

testNegativeDateIntervalConvertsToDatabaseValue() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like