User::__construct() - Code Metrics - Inspection of "Add unit tests for EntityAdapter (ORM Tool) and so..." - Pleets/dronephp - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( 84ef81...00604e )

by Darío
created 2019-03-21 23:19 UTC
User::__construct() A

↳ Parent: User
Complexity

Conditions	1
Paths	1
Size

Total Lines	4
Code Lines	2
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	1
eloc	2
nc	1
nop	1
dl	0
loc	4
rs	10
c	0
b	0
f	0
<?php
/**
 * DronePHP (http://www.dronephp.com)
 *
 * @link      http://github.com/Pleets/DronePHP
 * @copyright Copyright (c) 2016-2018 Pleets. (http://www.pleets.org)
 * @license   http://www.dronephp.com/license
 * @author    Darío Rivera <[email protected]>
 */

namespace DroneTest\Util;

use Drone\Db\Entity;
use Drone\Db\Driver\MySQL;
use Drone\Db\TableGateway\EntityAdapter;
use Drone\Db\TableGateway\TableGateway;
use Drone\Db\TableGateway\AbstractTableGateway;
use Drone\Db\Driver\Exception\ConnectionException;
use Drone\Db\Driver\Exception\InvalidQueryException;
use PHPUnit\Framework\TestCase;

class EntityAdapterTest extends TestCase
{
    /**
     * Database parameters
     */
    private $options = [
        "dbhost"       => "localhost",
        "dbuser"       => "root",
        "dbpass"       => "",
        "dbname"       => "test",
        "dbchar"       => "utf8",
        "dbport"       => "3306",
        "auto_connect" => false,
        "driver"       => 'Mysqli'  # needed for the DriverFactory
    ];

    /*
    |--------------------------------------------------------------------------
    | Stablishing connections
    |--------------------------------------------------------------------------
    |
    | The following tests are related to the connection mechanisms and its
    | exceptions and returned values.
    |
    */

    /**
     * Tests if we can connect to the database server through a EntityAdapter
     *
     * @return null
     */
    public function testCompositionWithTableGateway()
    {
        $entity = new User();
        $gateway = new TableGateway($entity, ["eadapter" => $this->options]);
        $entityAdapter = new EntityAdapter($gateway);

        $mysqliObject = $entityAdapter->getTableGateway()->getDb()->connect();

        $this->assertInstanceOf('\mysqli', $mysqliObject);
        $this->assertTrue($entityAdapter->getTableGateway()->getDb()->isConnected());
    }

    /**
     * Tests if we can execute DDL statements through the TableGateway accesor
     *
     * @return null
     */
    public function testCanExecuteStatementThroughTableGateway()
    {
        $options = $this->options;
        $options["auto_connect"] = true;

        $entity = new User();
        $gateway = new UserGateway($entity, "eadapter");
        $entityAdapter = new EntityAdapter($gateway);

        $result = $entityAdapter->getTableGateway()->create();
        $result = $entityAdapter->getTableGateway()->/** @scrutinizer ignore-call */ create();

        # mysqli
        $this->assertTrue(is_object($result));

        # properties modified by execute() method
        $this->assertEquals(0, $gateway->getDb()->getNumRows());
        $this->assertEquals(0, $gateway->getDb()->getNumFields());
        $this->assertEquals(0, $gateway->getDb()->getRowsAffected());
    }

    /*
    |--------------------------------------------------------------------------
    | ORM TOOL (Data mapper)
    |--------------------------------------------------------------------------
    |
    | The following tests are related to the object relational mapping.
    |
    */

    /**
     * Tests if we can execute INSERT statements through the EntityAdapter
     *
     * @return null
     */
    public function testINSERTING()
    {
        $options = $this->options;
        $options["auto_connect"] = true;

        $entity = new User();
        $gateway = new TableGateway($entity, "eadapter");
        $entityAdapter = new EntityAdapter($gateway);

        $firstEntity = new User();
        $firstEntity->exchangeArray([
            "ID" => 1, "USERNAME" => "Dennis.Ritchie"
        ]);

        $secondEntity = new User();
        $secondEntity->exchangeArray([
            "ID" => 2, "USERNAME" => "Bjarne.Stroustrup"
        ]);

        $result = $entityAdapter->insert($firstEntity);

        $result = $entityAdapter->insert($secondEntity);

        $this->assertTrue(is_object($result));

        # properties modified by execute() method
        $this->assertEquals(0, $entityAdapter->getTableGateway()->getDb()->getNumRows());
        $this->assertEquals(0, $entityAdapter->getTableGateway()->getDb()->getNumFields());

        # here 1 is the latest affected row, could be 2 if auto_commit were false
        $this->assertEquals(1, $entityAdapter->getTableGateway()->getDb()->getRowsAffected());
    }

    /**
     * Tests if we can execute UPDATE statements through the EntityAdapter
     *
     * @return null
     */
    public function testUPDATING()
    {
        $options = $this->options;
        $options["auto_connect"] = true;

        $entity = new User();
        $gateway = new TableGateway($entity, "eadapter");
        $entityAdapter = new EntityAdapter($gateway);

        $firstEntity = new User(["ID" => 1]);

        # tell to entity what changed
        $firstEntity->exchangeArray([
            "USERNAME" => "Rasmus.Lerdorf"
        ]);

        $result = $entityAdapter->update($firstEntity, ["ID" => 1]);

        $this->assertTrue(is_object($result));

        # properties modified by execute() method
        $this->assertEquals(0, $entityAdapter->getTableGateway()->getDb()->getNumRows());
        $this->assertEquals(0, $entityAdapter->getTableGateway()->getDb()->getNumFields());
        $this->assertEquals(1, $entityAdapter->getTableGateway()->getDb()->getRowsAffected());
    }


    /**
     * Tests if we can execute DELETE statements through the EntityAdapter
     *
     * @return null
     */
    public function testDELETING()
    {
        $options = $this->options;
        $options["auto_connect"] = true;

        $entity = new User();
        $gateway = new TableGateway($entity, "eadapter");
        $entityAdapter = new EntityAdapter($gateway);

        # same behaviour to tablegateway
        $result = $entityAdapter->delete(["ID" => 2]);

        $this->assertTrue(is_object($result));

        # properties modified by execute() method
        $this->assertEquals(0, $entityAdapter->getTableGateway()->getDb()->getNumRows());
        $this->assertEquals(0, $entityAdapter->getTableGateway()->getDb()->getNumFields());
        $this->assertEquals(1, $entityAdapter->getTableGateway()->getDb()->getRowsAffected());
    }

    /**
     * Tests if we can execute SELECT statements through the EntityAdapter
     *
     * @return null
     */
    public function testSELECTING()
    {
        $options = $this->options;
        $options["auto_connect"] = true;

        $entity = new User();
        $gateway = new TableGateway($entity, "eadapter");
        $entityAdapter = new EntityAdapter($gateway);

        $rows = $entityAdapter->select([
            "ID" => 1
        ]);

        $this->assertTrue(is_array($rows));

        # get only the first
        $user = array_shift($rows);

        $this->assertInstanceOf('DroneTest\Util\User', $user);

        $this->assertObjectHasAttribute("ID", $user);
        $this->assertObjectHasAttribute("USERNAME", $user);

        # properties modified by execute() method
        $this->assertEquals(1, $entityAdapter->getTableGateway()->getDb()->getNumRows());
        $this->assertEquals(2, $entityAdapter->getTableGateway()->getDb()->getNumFields());
        $this->assertEquals(0, $entityAdapter->getTableGateway()->getDb()->getRowsAffected());
        $this->endTests();
    }

    /**
     * Function to leave all in order, you can execute tests again without problems.
     *
     * @return null
     */
    private function endTests()
    {
        $options = $this->options;
        $options["auto_connect"] = true;

        $entity = new User();
        $gateway = new UserGateway($entity, "eadapter");

        # remove all work
        $gateway->drop();
    }
}

class User extends Entity
{
    public $ID;
    public $USERNAME;

    public function __construct($data = [])
    {
        parent::__construct($data);
        $this->setTableName("USER");
   }
}

class UserGateway extends TableGateway
{
    public function create()
    {
        $sql = "CREATE TABLE USER (ID INTEGER(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, USERNAME VARCHAR(30))";
        return $this->getDb()->execute($sql);
    }

    public function drop()
    {
        $sql = "DROP TABLE USER";
        return $this->getDb()->execute($sql);
    }
}
Pleets / dronephp

Push — master ( 84ef81...00604e )

User::__construct() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
