SqlProviderTest::quoteIdentifierCallback() - Code Metrics - florianajir/rabbitmq-sql-worker - Measure and Improve Code Quality continuously with Scrutinizer

SqlProviderTest::quoteIdentifierCallback() A
last analyzed 2016-05-03 21:46 UTC

↳ Parent: SqlProviderTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Metric	Value
dl	0
loc	6
rs	9.4285
cc	1
eloc	3
nc	1
nop	0

<?php
namespace Ajir\RabbitMqSqlBundle\Tests\Provider;

use Doctrine\DBAL\Logging\EchoSQLLogger;
use Ajir\RabbitMqSqlBundle\Provider\SqlProvider;

/**
 *
 * @author Florian Ajir <[email protected]>
 */
class SqlProviderTest extends \PHPUnit_Framework_TestCase
{
    /**
     *
     */
    public function testInstanciateWithDebugLogger()
    {
        $configMock = $this->getConfigurationMock();
        $configMock->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('setSQLLogger')
            ->with(new EchoSQLLogger())
        ;
        $conn = $this->getConnectionMock();
        $conn->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('getConfiguration')
            ->with()
            ->will($this->returnValue($configMock));
        new SqlProvider($conn, 'test');
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
    }

    /**
     *
     */
    public function testDelete()
    {
        $table = 'test';
        $conditions = array('id' => 1);
        $returned = 1;
        $conn = $this->getConnectionMock();
        $conn->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('delete')
            ->with($table, $conditions)
            ->will($this->returnValue($returned));
        $sqlProvider = new SqlProvider($conn, 'prod');
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
        $result = $sqlProvider->delete($table, $conditions);
        $this->assertEquals($returned, $result);
    }

    /**
     * @return \PHPUnit_Framework_MockObject_MockObject|\Doctrine\DBAL\Connection
     */
    private function getConnectionMock()
    {
        $conn = $this->getMockBuilder('\Doctrine\DBAL\Connection')
            ->disableOriginalConstructor()
            ->getMock();

        return $conn;
    }

    /**
     * @return \PHPUnit_Framework_MockObject_MockObject|\Doctrine\DBAL\Configuration
     */
    private function getConfigurationMock()
    {
        $config = $this->getMockBuilder('\Doctrine\DBAL\Configuration')
            ->disableOriginalConstructor()
            ->getMock();

        return $config;
    }

    /**
     *
     */
    public function testExists()
    {
        $exists = '1';
        $table = 'test';
        $identifier = 'id';
        $value = 1;
        $conn = $this->getConnectionMock();
        $sth = $this->getStatementMock();
        $sth->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('fetchColumn')
            ->will($this->returnValue($exists));
        $conn->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('executeQuery')
            ->with("SELECT count(*) FROM `{$table}` WHERE `{$identifier}` = '{$value}'")
            ->will($this->returnValue($sth));
        $sqlProvider = new SqlProvider($conn, 'prod');
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
        $result = $sqlProvider->exists($table, $identifier, $value);
        $this->assertEquals($exists, $result);
    }

    /**
     * @return \PHPUnit_Framework_MockObject_MockObject|\Doctrine\DBAL\Statement
     */
    private function getStatementMock()
    {
        $sth = $this->getMockBuilder('\Doctrine\DBAL\Statement')
            ->disableOriginalConstructor()
            ->getMock();

        return $sth;
    }

    /**
     *
     */
    public function testUpdate()
    {
        $data = array(
            'id'   => '1',
            'name' => 'test'
        );
        $table = 'test';
        $identifier = array('id' => 1);
        $conn = $this->getConnectionMock();
        $conn->expects($this->exactly(count($data)))
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('quoteIdentifier')
            ->with($this->anything())
            ->will(
                $this->returnCallback(
                    'Ajir\RabbitMqSqlBundle\Tests\Provider\SqlProviderTest::quoteIdentifierCallback'
                )
            );
        $conn->expects($this->once())
            ->method('lastInsertId')
            ->will($this->returnValue($data['id']));
        $sqlProvider = new SqlProvider($conn, 'prod');
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
        $result = $sqlProvider->update($table, $data, $identifier);
        $this->assertEquals($data['id'], $result);
    }

    public static function quoteIdentifierCallback()
    {
        $args = func_get_args();

        return "`{$args[0]}`";
    }

    /**
     *
     */
    public function testInsert()
    {
        $lastInsertId = '1';
        $data = array(
            'name' => 'test'
        );
        $table = 'test';
        $conn = $this->getConnectionMock();
        $conn->expects($this->exactly(count($data)))
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('quoteIdentifier')
            ->with($this->anything())
            ->will(
                $this->returnCallback(
                    'Ajir\RabbitMqSqlBundle\Tests\Provider\SqlProviderTest::quoteIdentifierCallback'
                )
            );
        $conn->expects($this->once())
            ->method('lastInsertId')
            ->will($this->returnValue($lastInsertId));
        $sqlProvider = new SqlProvider($conn, 'prod');
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
        $result = $sqlProvider->insert($table, $data);
        $this->assertEquals($lastInsertId, $result);
    }

    /**
     *
     */
    public function testInsertOrUpdateWithoutIdentifier()
    {
        $data = array(
            'id'   => '1',
            'name' => 'test'
        );
        $table = 'test';
        $conn = $this->getConnectionMock();
        $conn->expects($this->exactly(count($data)))
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('quoteIdentifier')
            ->with($this->anything())
            ->will(
                $this->returnCallback(
                    'Ajir\RabbitMqSqlBundle\Tests\Provider\SqlProviderTest::quoteIdentifierCallback'
                )
            );
        $conn->expects($this->once())
            ->method('lastInsertId')
            ->will($this->returnValue($data['id']));
        $sqlProvider = new SqlProvider($conn, 'prod');
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
        $result = $sqlProvider->insertOrUpdateIfExists($table, $data);
        $this->assertEquals($data['id'], $result);
    }

    /**
     *
     */
    public function testInsertOrUpdateWithIdentifier()
    {
        $exists = '1';
        $data = array(
            'id'   => '1',
            'name' => 'test'
        );
        $table = 'test';
        $identifier = array('id' => 1);
        $conn = $this->getConnectionMock();
        $sth = $this->getStatementMock();
        $sth->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('fetchColumn')
            ->will($this->returnValue($exists));
        $conn->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('executeQuery')
            ->with("SELECT count(*) FROM `{$table}` WHERE `id` = '1'")
            ->will($this->returnValue($sth));
        $conn->expects($this->exactly(count($data)))
            ->method('quoteIdentifier')
            ->with($this->anything())
            ->will(
                $this->returnCallback(
                    'Ajir\RabbitMqSqlBundle\Tests\Provider\SqlProviderTest::quoteIdentifierCallback'
                )
            );
        $conn->expects($this->once())
            ->method('lastInsertId')
            ->will($this->returnValue($data['id']));
        $sqlProvider = new SqlProvider($conn, 'prod');
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
        $result = $sqlProvider->insertOrUpdateIfExists($table, $data, $identifier);
        $this->assertEquals($data['id'], $result);
    }

    /**
     *
     */
    public function testGetColumnValueWhere()
    {
        $column = 'name';
        $where = 'id';
        $value = '1';
        $table = 'test';
        $fetch = 'test';
        $conn = $this->getConnectionMock();
        $sth = $this->getStatementMock();
        $sth->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('fetchColumn')
            ->will($this->returnValue($fetch));
        $conn->expects($this->once())
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
            ->method('executeQuery')
            ->with("SELECT `{$column}` FROM `{$table}` WHERE `{$where}` = '{$value}'")
            ->will($this->returnValue($sth));
        $sqlProvider = new SqlProvider($conn, 'prod');
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
        $result = $sqlProvider->getColumnValueWhere($table, $column, $where, $value);
        $this->assertEquals($fetch, $result);
    }
}


SqlProviderTest::quoteIdentifierCallback() A
last analyzed 2016-05-03 21:46 UTC

Complexity

Size

Duplication

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

1			<?php
2			namespace Ajir\RabbitMqSqlBundle\Tests\Provider;
3
4			use Doctrine\DBAL\Logging\EchoSQLLogger;
5			use Ajir\RabbitMqSqlBundle\Provider\SqlProvider;
6
7			/**
8			*
9			* @author Florian Ajir <[email protected]>
10			*/
11			class SqlProviderTest extends \PHPUnit_Framework_TestCase
12			{
13			/**
14			*
15			*/
16			public function testInstanciateWithDebugLogger()
17			{
18			$configMock = $this->getConfigurationMock();
19			$configMock->expects($this->once())
			0 ignored issues – show Bug introduced 2016-05-03 20:38 UTC by Report Bug Copy Issue Report The method `expects` does only exist in `PHPUnit_Framework_MockObject_MockObject`, but not in `Doctrine\DBAL\Configuration`. It seems like the method you are trying to call exists only in some of the possible types. Let’s take a look at an example: class A { public function foo() { } } class B extends A { public function bar() { } } /** * @param A\|B $x / function someFunction($x) { $x->foo(); // This call is fine as the method exists in A and B. $x->bar(); // This method only exists in B and might cause an error. } Available Fixes Add an additional type-check: /* * @param A\|B $x / function someFunction($x) { $x->foo(); if ($x instanceof B) { $x->bar(); } } Only allow a single type to be passed if the variable comes from a parameter: function someFunction(B $x) { /* ... */ } Loading history...
20			->method('setSQLLogger')
21			->with(new EchoSQLLogger())
22			;
23			$conn = $this->getConnectionMock();
24			$conn->expects($this->once())
			0 ignored issues – show Bug introduced 2016-05-03 20:38 UTC by Report Bug Copy Issue Report The method `expects` does only exist in `PHPUnit_Framework_MockObject_MockObject`, but not in `Doctrine\DBAL\Connection`. It seems like the method you are trying to call exists only in some of the possible types. Let’s take a look at an example: class A { public function foo() { } } class B extends A { public function bar() { } } /** * @param A\|B $x / function someFunction($x) { $x->foo(); // This call is fine as the method exists in A and B. $x->bar(); // This method only exists in B and might cause an error. } Available Fixes Add an additional type-check: /* * @param A\|B $x / function someFunction($x) { $x->foo(); if ($x instanceof B) { $x->bar(); } } Only allow a single type to be passed if the variable comes from a parameter: function someFunction(B $x) { /* ... */ } Loading history...
25			->method('getConfiguration')
26			->with()
27			->will($this->returnValue($configMock));
28			new SqlProvider($conn, 'test');
			0 ignored issues – show Bug introduced 2016-05-03 20:38 UTC by Report Bug Copy Issue Report It seems like `$conn` defined by `$this->getConnectionMock()` on line `23` can also be of type `object<PHPUnit_Framework_MockObject_MockObject>`; however, `Ajir\RabbitMqSqlBundle\P...Provider::__construct()` does only seem to accept `object<Doctrine\DBAL\Connection>`, maybe add an additional type check? If a method or function can return multiple different values and unless you are sure that you only can receive a single value in this context, we recommend to add an additional type check: /** * @return array\|string */ function returnsDifferentValues($x) { if ($x) { return 'foo'; } return array(); } $x = returnsDifferentValues($y); if (is_array($x)) { // $x is an array. } If this a common case that PHP Analyzer should handle natively, please let us know by opening an issue. Loading history...
29			}
30
31			/**
32			*
33			*/
34			public function testDelete()
35			{
36			$table = 'test';
37			$conditions = array('id' => 1);

florianajir / rabbitmq-sql-worker

SqlProviderTest::quoteIdentifierCallback() A last analyzed 2016-05-03 21:46 UTC

Complexity

Size

Duplication

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like

SqlProviderTest::quoteIdentifierCallback() A
last analyzed 2016-05-03 21:46 UTC