Issues in ModelTest.php - New Issues - Inspection of "Merge branch 'develop' of https://github.com/andel..." - andela-joyebanji/PotatoORM - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 1cc4f3...6a89b9 )

by Oyebanji Jacob

created 2016-03-17 15:28 UTC

test/ModelTest.php (1 issue)

Labels

Duplication 1

Severity

Informational 1

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

<?php


use \Mockery as m;
use Pyjac\ORM\Model;

class ModelTest extends PHPUnit_Framework_TestCase
{
    /**
     * Instance of DatabaseConnection used in test.
     */
    protected $databaseConnection;

    /**
     * Instance of Model used in test.
     */
    protected $model;

    /**
     * Instance of SqlStatement used in test.
     */
    protected $sqlStatement;

    public function setUp()
    {
        $databaseConnectionStringFactory =
                        m::mock('Pyjac\ORM\DatabaseConnectionStringFactoryInterface');

        $databaseConnectionStringFactory->shouldReceive('createDatabaseSourceString')
                                             ->with(['DRIVER' => 'sqlite', 'HOSTNAME' => '127.0.0.1', 'USERNAME' => '', 'PASSWORD' => '', 'DBNAME' => 'potatoORM', 'PORT' => '54320'])->once()->andReturn('sqlite::memory:');

        $this->databaseConnection = m::mock('Pyjac\ORM\DatabaseConnection');

        $this->sqlStatement = m::mock('\PDOStatement');

        $this->model = $this->getMockForAbstractClass('Pyjac\ORM\Model', [$this->databaseConnection]);
    }

    public function testGetTableNameReturnsCorrectTableName()
    {
        $this->databaseConnection->shouldReceive('createConnection')->with('sqlite::memory:')->once()->andReturn('');
        $this->model->expects($this->any())
             ->method('getTableName')
             ->will($this->returnValue(strtolower(get_class($this->model).'s')));

        $this->assertEquals($this->model->getTableName(), strtolower(get_class($this->model).'s'));
    }

    public function testGetReturnsAnObjectWhenIdIsFoundInDatabase()
    {
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('setFetchMode');
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
        $this->sqlStatement->shouldReceive('fetch')->once()->andReturn(new stdClass());

        $this->assertInstanceOf('stdClass', $this->model->get(1));
    }

    /**
     * @expectedException Pyjac\ORM\Exception\ModelNotFoundException
     */
    public function testGetThrowsModelNotFoundExceptionWhenIdNotFoundInDatabase()
    {
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('setFetchMode');
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(0);

        $this->assertInstanceOf('stdClass', $this->model->get(1));
    }

    public function testAllReturnsAnArrayOfObjectsWhenValuesAreInDatabase()
    {
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('fetchAll')->once()->andReturn([new stdClass(), new stdClass()]);
        $this->assertContainsOnlyInstancesOf('stdClass', $this->model->all());
    }

    public function testUpdateChangesTheValueOfObjectInDatabase()
    {
        $this->model->setProperties(['id' => 2, 'name' => 'pyjac', 'age' => '419']);
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);

        $this->assertEquals(1, $this->model->update());
    }

    public function testCreateObjectInDatabase()

    {
        $this->model->setProperties(['name' => 'pyjac', 'age' => '419']);
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);

        $this->assertEquals(1, $this->model->create());
    }

    public function testSaveShouldCreateNewModelInDatabaseWhenIdNotPresent()
    {
        $this->model->setProperties(['name' => 'pyjac', 'age' => '419']);
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
        $this->assertEquals(1, $this->model->save());
    }

    public function testSaveShouldUpdateModelInDatabaseIfIdIsPresent()
    {
        $this->model->setProperties(['id' => 2, 'name' => 'pyjac', 'age' => '419']);
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
        $this->assertEquals(1, $this->model->save());
    }

    public function testGetPropertiesReturnsExpectedArrayValues()
    {
        $values = ['id' => 2, 'name' => 'pyjac', 'age' => '419'];
        $this->model->setProperties($values);

        $this->assertEquals($values, $this->model->getProperties());
    }

    public function testDeleteReturnsTrueWhenModelIsSuccessfullyRemovedFromDatabase()
    {
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);

        $this->assertEquals(true, $this->model->delete(1));
    }

    public function testDeleteReturnsFalseWhenModelWasNotDeletedFromDatabase()
    {
        $this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
        $this->sqlStatement->shouldReceive('execute');
        $this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(0);

        $this->assertEquals(false, $this->model->delete(1));
    }

    public function testMagicMethodsReturnCorrectResult()
    {
        $this->model->id = '10';
        $this->model->name = 'Pyjac';
        $this->model->age = '60';

        $this->assertEquals($this->model->name, 'Pyjac');
        $this->assertEquals($this->model->id, '10');
        $this->assertEquals($this->model->age, '60');
    }

    public function testCreateModelWithNoParameter()
    {
        $model = $this->getMockForAbstractClass('Pyjac\ORM\Model');
        $this->assertInstanceOf(\Pyjac\ORM\Model::class, $model);
    }
}


1		<?php
2
3
4		use \Mockery as m;
5		use Pyjac\ORM\Model;
6
7		class ModelTest extends PHPUnit_Framework_TestCase
8		{
9		/**
10		* Instance of DatabaseConnection used in test.
11		*/
12		protected $databaseConnection;
13
14		/**
15		* Instance of Model used in test.
16		*/
17		protected $model;
18
19		/**
20		* Instance of SqlStatement used in test.
21		*/
22		protected $sqlStatement;
23
24		public function setUp()
25		{
26		$databaseConnectionStringFactory =
27		m::mock('Pyjac\ORM\DatabaseConnectionStringFactoryInterface');
28
29		$databaseConnectionStringFactory->shouldReceive('createDatabaseSourceString')
30		->with(['DRIVER' => 'sqlite', 'HOSTNAME' => '127.0.0.1', 'USERNAME' => '', 'PASSWORD' => '', 'DBNAME' => 'potatoORM', 'PORT' => '54320'])->once()->andReturn('sqlite::memory:');
31
32		$this->databaseConnection = m::mock('Pyjac\ORM\DatabaseConnection');
33
34		$this->sqlStatement = m::mock('\PDOStatement');
35
36		$this->model = $this->getMockForAbstractClass('Pyjac\ORM\Model', [$this->databaseConnection]);
37		}
38
39		public function testGetTableNameReturnsCorrectTableName()
40		{
41		$this->databaseConnection->shouldReceive('createConnection')->with('sqlite::memory:')->once()->andReturn('');
42		$this->model->expects($this->any())
43		->method('getTableName')
44		->will($this->returnValue(strtolower(get_class($this->model).'s')));
45
46		$this->assertEquals($this->model->getTableName(), strtolower(get_class($this->model).'s'));
47		}
48
49		public function testGetReturnsAnObjectWhenIdIsFoundInDatabase()
50		{
51		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
52		$this->sqlStatement->shouldReceive('setFetchMode');
53		$this->sqlStatement->shouldReceive('execute');
54		$this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
55		$this->sqlStatement->shouldReceive('fetch')->once()->andReturn(new stdClass());
56
57		$this->assertInstanceOf('stdClass', $this->model->get(1));
58		}
59
60		/**
61		* @expectedException Pyjac\ORM\Exception\ModelNotFoundException
62		*/
63	View Code Duplication	public function testGetThrowsModelNotFoundExceptionWhenIdNotFoundInDatabase()
64		{
65		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
66		$this->sqlStatement->shouldReceive('setFetchMode');
67		$this->sqlStatement->shouldReceive('execute');
68		$this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(0);
69
70		$this->assertInstanceOf('stdClass', $this->model->get(1));
71		}
72
73		public function testAllReturnsAnArrayOfObjectsWhenValuesAreInDatabase()
74		{
75		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
76		$this->sqlStatement->shouldReceive('execute');
77		$this->sqlStatement->shouldReceive('fetchAll')->once()->andReturn([new stdClass(), new stdClass()]);
78		$this->assertContainsOnlyInstancesOf('stdClass', $this->model->all());
79		}
80
81		public function testUpdateChangesTheValueOfObjectInDatabase()
82		{
83		$this->model->setProperties(['id' => 2, 'name' => 'pyjac', 'age' => '419']);
84		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
85		$this->sqlStatement->shouldReceive('execute');
86		$this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
87
88		$this->assertEquals(1, $this->model->update());
89		}
90
91	View Code Duplication	public function testCreateObjectInDatabase()
		0 ignored issues – show Duplication introduced 2016-03-05 12:41 UTC by Report Bug Copy Issue Report Show Similar Issues like this 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...
92		{
93		$this->model->setProperties(['name' => 'pyjac', 'age' => '419']);
94		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
95		$this->sqlStatement->shouldReceive('execute');
96		$this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
97
98		$this->assertEquals(1, $this->model->create());
99		}
100
101		public function testSaveShouldCreateNewModelInDatabaseWhenIdNotPresent()
102		{
103		$this->model->setProperties(['name' => 'pyjac', 'age' => '419']);
104		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
105		$this->sqlStatement->shouldReceive('execute');
106		$this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
107		$this->assertEquals(1, $this->model->save());
108		}
109
110		public function testSaveShouldUpdateModelInDatabaseIfIdIsPresent()
111		{
112		$this->model->setProperties(['id' => 2, 'name' => 'pyjac', 'age' => '419']);
113		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
114		$this->sqlStatement->shouldReceive('execute');
115		$this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
116		$this->assertEquals(1, $this->model->save());
117		}
118
119		public function testGetPropertiesReturnsExpectedArrayValues()
120		{
121		$values = ['id' => 2, 'name' => 'pyjac', 'age' => '419'];
122		$this->model->setProperties($values);
123
124		$this->assertEquals($values, $this->model->getProperties());
125		}
126
127	View Code Duplication	public function testDeleteReturnsTrueWhenModelIsSuccessfullyRemovedFromDatabase()
128		{
129		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
130		$this->sqlStatement->shouldReceive('execute');
131		$this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(1);
132
133		$this->assertEquals(true, $this->model->delete(1));
134		}
135
136	View Code Duplication	public function testDeleteReturnsFalseWhenModelWasNotDeletedFromDatabase()
137		{
138		$this->databaseConnection->shouldReceive('prepare')->once()->andReturn($this->sqlStatement);
139		$this->sqlStatement->shouldReceive('execute');
140		$this->sqlStatement->shouldReceive('rowCount')->once()->andReturn(0);
141
142		$this->assertEquals(false, $this->model->delete(1));
143		}
144
145		public function testMagicMethodsReturnCorrectResult()
146		{
147		$this->model->id = '10';
148		$this->model->name = 'Pyjac';
149		$this->model->age = '60';
150
151		$this->assertEquals($this->model->name, 'Pyjac');
152		$this->assertEquals($this->model->id, '10');
153		$this->assertEquals($this->model->age, '60');
154		}
155
156		public function testCreateModelWithNoParameter()
157		{
158		$model = $this->getMockForAbstractClass('Pyjac\ORM\Model');
159		$this->assertInstanceOf(\Pyjac\ORM\Model::class, $model);
160		}
161		}
162

andela-joyebanji / PotatoORM

Push — develop ( 1cc4f3...6a89b9 )

test/ModelTest.php (1 issue)

Labels

Severity

Introduced By

Upgrade to new PHP Analysis Engine

Duplication Side-by-Side

Filter issues like