DbDiffTest - Code Metrics - fwolf/fwlib - Measure and Improve Code Quality continuously with Scrutinizer

DbDiffTest A
last analyzed 2019-05-09 15:53 UTC

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	562
Duplicated Lines	30.25 %

Coupling/Cohesion

Components	1
Dependencies	7

Importance

Changes

Metric	Value
dl	170
loc	562
rs	10
c	0
b	0
f	0
wmc	21
lcom	1
cbo	7

21 Methods

Rating	Name	Duplication	Size	Complexity
A	buildMock()	0	6	1
A	buildMockWithFakeDb()	29	29	1
A	setUpBeforeClass()	10	10	1
A	testCommitAgain()	21	21	1
A	testCommitWithDbFail()	0	35	1
A	testCommitWithInvalidMode()	21	21	1
A	testCommitWithoutDiffData()	0	5	1
A	testCompareWithDeleteMode()	0	25	1
A	testCompareWithNullPkInBothDataNewAndOld()	0	11	1
A	testCompareWithUpdateModeWithSameDataNewAndOld()	0	17	1
B	testExecute()	0	95	1
A	testExecuteAgain()	21	21	1
A	testExecuteInsertThenRollback()	0	32	1
A	testExecuteWithEmptyDataNew()	0	5	1
A	testExecuteWithNotEnoughPkInDataNew()	13	13	1
A	testExecuteWithTableHaveNoPk()	13	13	1
A	testImportInvalidJson()	0	6	1
A	testRollbackAgain()	21	21	1
A	testRollbackWithDbFail()	0	35	1
A	testRollbackWithInvalidMode()	21	21	1
A	testRollbackWithoutDiffData()	0	5	1

How to fix Duplicated Code

<?php
namespace FwlibTest\Db;

use Fwlib\Bridge\Adodb;
use Fwlib\Db\DbDiff;
use Fwlib\Test\AbstractDbRelateTest;
use Fwlib\Util\UtilContainer;
use Fwlib\Util\UtilContainerAwareTrait;

/**
 * @copyright   Copyright 2012-2015 Fwolf
 * @license     http://www.gnu.org/licenses/lgpl.html LGPL-3.0+
 */
class DbDiffTest extends AbstractDbRelateTest
{
    use UtilContainerAwareTrait;


    protected static $dbUsing = 'default';

    protected static $uuid1;
    protected static $uuid2;
    protected static $uuid3;

    public static $getErrorCode;
    public static $getErrorMessage;


    protected function buildMock()
    {
        $dbDiff = new DbDiff(self::$db);


        return $dbDiff;
    }


    /**
     * @return DbDiff
     */
    protected function buildMockWithFakeDb()

    {
        $db = $this->getMockBuilder(Adodb::class)
            ->disableOriginalConstructor()
            ->getMock(
                Adodb::class,

                [
                    'BeginTrans', 'CommitTrans', 'RollbackTrans',
                    'getErrorCode', 'getErrorMessage',
                    'execute'
                ]
            );

        $db->expects($this->any())
            ->method('getErrorCode')
            ->will($this->returnCallback(function () {
                return DbDiffTest::$getErrorCode;
            }));

        $db->expects($this->any())
            ->method('getErrorMessage')
            ->will($this->returnCallback(function () {
                return DbDiffTest::$getErrorMessage;
            }));

        $dbDiff = new DbDiff($db);


        return $dbDiff;
    }


    public static function setUpBeforeClass()

    {
        parent::setUpBeforeClass();

        $uuidGenerator = UtilContainer::getInstance()->getUuidBase36();

        self::$uuid1 = $uuidGenerator->generate();
        self::$uuid2 = $uuidGenerator->generate();
        self::$uuid3 = $uuidGenerator->generate();
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage can't commit again
     */
    public function testCommitAgain()

    {
        $dbDiff = $this->buildMock();

        $json = '{
            "rowCount": 0,
            "executeStatus": 100,
            "diff": {
                "' . self::$tableUser .  '": [
                    {
                        "mode": "Whatever",
                        "pk": [],
                        "column": []
                    }
                ]
            }
        }';

        $dbDiff->import($json);
        $dbDiff->commit();
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage Db execute fail
     */
    public function testCommitWithDbFail()
    {
        $dbDiff = $this->buildMockWithFakeDb();

        $dataNew = [
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
            self::$tableUser => [
                'uuid'  => self::$uuid1,
            ],
        ];

        self::$getErrorCode = -1;
        self::$getErrorMessage = 'Db execute fail';

        $json = '{
            "rowCount": 0,
            "executeStatus": 0,
            "diff": {
                "' . self::$tableUser .  '": [
                    {
                        "mode": "INSERT",
                        "pk": {
                            "uuid": {
                                "new": "' . self::$uuid1 . '",
                                "old": null
                            }
                        },
                        "column": []
                    }
                ]
            }
        }';
        $dbDiff->import($json);

        $dbDiff->commit();
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage Invalid mode
     */
    public function testCommitWithInvalidMode()

    {
        $dbDiff = $this->buildMock();

        $json = '{
            "rowCount": 0,
            "executeStatus": 0,
            "diff": {
                "' . self::$tableUser .  '": [
                    {
                        "mode": "InvalidMode",
                        "pk": [],
                        "column": []
                    }
                ]
            }
        }';

        $dbDiff->import($json);
        $dbDiff->commit();
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage No diff data
     */
    public function testCommitWithoutDiffData()
    {
        $dbDiff = $this->buildMock();
        $dbDiff->commit();
    }


    public function testCompareWithDeleteMode()
    {
        $dbDiff = $this->buildMock();
        $dataNew = [
            self::$tableUser => [
                'uuid'  => null,
            ],
        ];
        $dataOld = [
            self::$tableUser => [
                'uuid'  => self::$uuid1,
                'title' => 'User Title The Third',
                'age'   => 4200,
                'credit'    => '42',
                'joindate'  => '2012-01-02',
            ],
        ];

        $dbDiff->compare($dataNew, $dataOld);
        $diff = $dbDiff->getDiff();
        $diff = $diff[self::$tableUser][0];

        $this->assertEquals('DELETE', $diff['mode']);
        $this->assertEquals(4, count($diff['column']));
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage all null
     */
    public function testCompareWithNullPkInBothDataNewAndOld()
    {
        $dbDiff = $this->buildMock();
        $dataNew = [
            self::$tableUser => [
                'uuid'  => null,
            ],
        ];

        $dbDiff->compare($dataNew);
    }


    public function testCompareWithUpdateModeWithSameDataNewAndOld()
    {
        $dbDiff = $this->buildMock();
        $dataNew = [
            self::$tableUser => [
                'uuid'  => self::$uuid1,
                'title' => 'User Title The Third',
                'age'   => 4200,
                'credit'    => '42',
                'joindate'  => '2012-01-02',
            ],
        ];

        $dbDiff->compare($dataNew, $dataNew);

        $this->assertEmpty($dbDiff->getDiff());
    }


    public function testExecute()
    {
        $dbDiff = $this->buildMock();

        // Normal insert
        $dataNew1 = [
            self::$tableUser => [
                'uuid'  => self::$uuid1,
                'title' => 'User Title',
                'age'   => 42,
                'credit'    => '0.42',
                'joindate'  => '2014-01-02',
            ],
        ];

        $dbDiff->execute($dataNew1);
        $this->assertEquals(1, $dbDiff->getRowCount());

        $diff = $dbDiff->getDiff();
        $this->assertEquals('INSERT', $diff[self::$tableUser][0]['mode']);
        $this->assertEquals(1, count($diff[self::$tableUser][0]['pk']));
        $this->assertEquals(4, count($diff[self::$tableUser][0]['column']));

        $this->assertTrue($dbDiff->isCommitted());
        $this->assertTrue($dbDiff->isExecuted());


        // Insert with PK column only
        $dataNew2 = [
            self::$tableUser => [
                'uuid'  => self::$uuid2,
            ],
        ];

        $dbDiff->execute($dataNew2);
        $this->assertEquals(1, $dbDiff->getRowCount());
        $diff = $dbDiff->getDiff();
        $this->assertEquals(0, count($diff[self::$tableUser][0]['column']));

        $this->assertEquals(2, self::$db->getRowCount(self::$tableUser));


        // Update row with $uuid1, and delete row with $uuid2
        $dataNewChanged = [
            self::$tableUser => [
                // Modify from $dataNew1
                [
                    'uuid'  => self::$uuid1,
                    'title' => 'User Title Changed',
                    'age'   => 420,
                    'credit'    => '4.2',
                    'joindate'  => '2013-01-02',
                ],
                [
                    'uuid'  => null,
                ]
            ],
        ];
        $dataOld = [
            self::$tableUser => [
                $dataNew1[self::$tableUser],
                $dataNew2[self::$tableUser],
            ],
        ];
        $dbDiff->execute($dataNewChanged, $dataOld);

        $this->assertEquals(2, $dbDiff->getRowCount());
        $this->assertEquals(
            420,
            self::$db->getByKey(self::$tableUser, self::$uuid1, 'age', 'uuid')
        );
        $this->assertEquals(1, self::$db->getRowCount(self::$tableUser));


        // Rollback last update and delete
        $dbDiff->rollback();

        $this->assertTrue($dbDiff->isRollbacked());
        $this->assertEquals(
            42,
            self::$db->getByKey(self::$tableUser, self::$uuid1, 'age', 'uuid')
        );
        $this->assertEquals(2, self::$db->getRowCount(self::$tableUser));


        // Then commit again
        $dbDiff->commit();

        $this->assertTrue($dbDiff->isCommitted());
        $this->assertEquals(
            420,
            self::$db->getByKey(self::$tableUser, self::$uuid1, 'age', 'uuid')
        );
        $this->assertEquals(1, self::$db->getRowCount(self::$tableUser));
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage can't execute again
     */
    public function testExecuteAgain()

    {
        $dbDiff = $this->buildMock();

        $json = '{
            "rowCount": 0,
            "executeStatus": 100,
            "diff": {
                "' . self::$tableUser .  '": [
                    {
                        "mode": "Whatever",
                        "pk": [],
                        "column": []
                    }
                ]
            }
        }';

        $dbDiff->import($json);
        $dbDiff->execute();
    }


    public function testExecuteInsertThenRollback()
    {
        $dbDiff = $this->buildMock();

        $dataNew = [
            self::$tableUser => [
                'uuid'  => self::$uuid3,
            ],
        ];

        $condition = "WHERE uuid = '" . self::$uuid3 . "'";


        // Insert
        $dbDiff->execute($dataNew);
        $this->assertEquals(
            1,
            self::$db->getRowCount(self::$tableUser, $condition)
        );


        // Export to json and import back
        $dbDiff->import($dbDiff->export());


        // Rollback
        $dbDiff->rollback();
        $this->assertEquals(
            0,
            self::$db->getRowCount(self::$tableUser, $condition)
        );
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage empty
     */
    public function testExecuteWithEmptyDataNew()
    {
        $dbDiff = $this->buildMock();
        $dbDiff->execute([], null);
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage PK not all assigned
     */
    public function testExecuteWithNotEnoughPkInDataNew()

    {
        $dbDiff = $this->buildMock();

        // No PK column uuid
        $dataNew = [
            self::$tableUser => [
                'title' => 'User Title',
            ],
        ];

        $dbDiff->execute($dataNew);
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage must have PK
     */
    public function testExecuteWithTableHaveNoPk()

    {
        $dbDiff = $this->buildMock();

        // No PK column uuid
        $dataNew = [
            'table_not_exist' => [
                'title' => 'User Title',
            ],
        ];

        $dbDiff->execute($dataNew);
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage Invalid json
     */
    public function testImportInvalidJson()
    {
        $dbDiff = $this->buildMock();

        $dbDiff->import('{}');
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage can't rollback again
     */
    public function testRollbackAgain()

    {
        $dbDiff = $this->buildMock();

        $json = '{
            "rowCount": 0,
            "executeStatus": -100,
            "diff": {
                "' . self::$tableUser .  '": [
                    {
                        "mode": "Whatever",
                        "pk": [],
                        "column": []
                    }
                ]
            }
        }';

        $dbDiff->import($json);
        $dbDiff->rollback();
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage Db execute fail
     */
    public function testRollbackWithDbFail()
    {
        $dbDiff = $this->buildMockWithFakeDb();

        $dataNew = [
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
            self::$tableUser => [
                'uuid'  => self::$uuid1,
            ],
        ];

        self::$getErrorCode = -1;
        self::$getErrorMessage = 'Db execute fail';

        $json = '{
            "rowCount": 0,
            "executeStatus": 100,
            "diff": {
                "' . self::$tableUser .  '": [
                    {
                        "mode": "INSERT",
                        "pk": {
                            "uuid": {
                                "new": "' . self::$uuid1 . '",
                                "old": null
                            }
                        },
                        "column": []
                    }
                ]
            }
        }';
        $dbDiff->import($json);

        $dbDiff->rollback();
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage Invalid mode
     */
    public function testRollbackWithInvalidMode()

    {
        $dbDiff = $this->buildMock();

        $json = '{
            "rowCount": 0,
            "executeStatus": 0,
            "diff": {
                "' . self::$tableUser .  '": [
                    {
                        "mode": "InvalidMode",
                        "pk": [],
                        "column": []
                    }
                ]
            }
        }';

        $dbDiff->import($json);
        $dbDiff->rollback();
    }


    /**
     * @expectedException \Exception
     * @expectedExceptionMessage No diff data
     */
    public function testRollbackWithoutDiffData()
    {
        $dbDiff = $this->buildMock();
        $dbDiff->rollback();
    }
}


1		<?php
2		namespace FwlibTest\Db;
3
4		use Fwlib\Bridge\Adodb;
5		use Fwlib\Db\DbDiff;
6		use Fwlib\Test\AbstractDbRelateTest;
7		use Fwlib\Util\UtilContainer;
8		use Fwlib\Util\UtilContainerAwareTrait;
9
10		/**
11		* @copyright Copyright 2012-2015 Fwolf
12		* @license http://www.gnu.org/licenses/lgpl.html LGPL-3.0+
13		*/
14		class DbDiffTest extends AbstractDbRelateTest
15		{
16		use UtilContainerAwareTrait;
17
18
19		protected static $dbUsing = 'default';
20
21		protected static $uuid1;
22		protected static $uuid2;
23		protected static $uuid3;
24
25		public static $getErrorCode;
26		public static $getErrorMessage;
27
28
29		protected function buildMock()
30		{
31		$dbDiff = new DbDiff(self::$db);
		0 ignored issues – show Deprecated Code introduced 2016-06-01 06:17 UTC by Report Bug Copy Issue Report The class `Fwlib\Db\DbDiff` has been deprecated. This class, trait or interface has been deprecated. Loading history...
32
33		return $dbDiff;
34		}
35
36
37		/**
38		* @return DbDiff
39		*/
40	View Code Duplication	protected function buildMockWithFakeDb()
		0 ignored issues – show Duplication introduced 2018-01-24 08:29 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...
41		{
42		$db = $this->getMockBuilder(Adodb::class)
43		->disableOriginalConstructor()
44		->getMock(
45		Adodb::class,
		0 ignored issues – show Unused Code introduced 2016-06-01 06:17 UTC by Report Bug Copy Issue Report The call to `PHPUnit_Framework_MockOb..._MockBuilder::getMock()` has too many arguments starting with `\Fwlib\Bridge\Adodb::class`. This check compares calls to functions or methods with their respective definitions. If the call has more arguments than are defined, it raises an issue. If a function is defined several times with a different number of parameters, the check may pick up the wrong definition and report false positives. One codebase where this has been known to happen is Wordpress. In this case you can add the `@ignore` PhpDoc annotation to the duplicate definition and it will be ignored. Loading history...
46		[
47		'BeginTrans', 'CommitTrans', 'RollbackTrans',
48		'getErrorCode', 'getErrorMessage',
49		'execute'
50		]
51		);
52
53		$db->expects($this->any())
54		->method('getErrorCode')
55		->will($this->returnCallback(function () {
56		return DbDiffTest::$getErrorCode;
57		}));
58
59		$db->expects($this->any())
60		->method('getErrorMessage')
61		->will($this->returnCallback(function () {
62		return DbDiffTest::$getErrorMessage;
63		}));
64
65		$dbDiff = new DbDiff($db);
		0 ignored issues – show Deprecated Code introduced 2016-06-01 06:17 UTC by Report Bug Copy Issue Report The class `Fwlib\Db\DbDiff` has been deprecated. This class, trait or interface has been deprecated. Loading history...
66
67		return $dbDiff;
68		}
69
70
71	View Code Duplication	public static function setUpBeforeClass()
		0 ignored issues – show Duplication introduced 2016-06-01 06:17 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...
72		{
73		parent::setUpBeforeClass();
74
75		$uuidGenerator = UtilContainer::getInstance()->getUuidBase36();
76
77		self::$uuid1 = $uuidGenerator->generate();
78		self::$uuid2 = $uuidGenerator->generate();
79		self::$uuid3 = $uuidGenerator->generate();
80		}
81
82
83		/**
84		* @expectedException \Exception
85		* @expectedExceptionMessage can't commit again
86		*/
87	View Code Duplication	public function testCommitAgain()
		0 ignored issues – show Duplication introduced 2018-01-24 08:29 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...
88		{
89		$dbDiff = $this->buildMock();
90
91		$json = '{
92		"rowCount": 0,
93		"executeStatus": 100,
94		"diff": {
95		"' . self::$tableUser . '": [
96		{
97		"mode": "Whatever",
98		"pk": [],
99		"column": []
100		}
101		]
102		}
103		}';
104
105		$dbDiff->import($json);
106		$dbDiff->commit();
107		}
108
109
110		/**
111		* @expectedException \Exception
112		* @expectedExceptionMessage Db execute fail
113		*/
114		public function testCommitWithDbFail()
115		{
116		$dbDiff = $this->buildMockWithFakeDb();
117
118		$dataNew = [
		0 ignored issues – show Unused Code introduced 2016-06-01 06:17 UTC by Report Bug Copy Issue Report `$dataNew` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
119		self::$tableUser => [
120		'uuid' => self::$uuid1,
121		],
122		];
123
124		self::$getErrorCode = -1;
125		self::$getErrorMessage = 'Db execute fail';
126
127		$json = '{
128		"rowCount": 0,
129		"executeStatus": 0,
130		"diff": {
131		"' . self::$tableUser . '": [
132		{
133		"mode": "INSERT",
134		"pk": {
135		"uuid": {
136		"new": "' . self::$uuid1 . '",
137		"old": null
138		}
139		},
140		"column": []
141		}
142		]
143		}
144		}';
145		$dbDiff->import($json);
146
147		$dbDiff->commit();
148		}
149
150
151		/**
152		* @expectedException \Exception
153		* @expectedExceptionMessage Invalid mode
154		*/
155	View Code Duplication	public function testCommitWithInvalidMode()
		0 ignored issues – show Duplication introduced 2018-01-24 08:29 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...
156		{
157		$dbDiff = $this->buildMock();
158
159		$json = '{
160		"rowCount": 0,
161		"executeStatus": 0,
162		"diff": {
163		"' . self::$tableUser . '": [
164		{
165		"mode": "InvalidMode",
166		"pk": [],
167		"column": []
168		}
169		]
170		}
171		}';
172
173		$dbDiff->import($json);
174		$dbDiff->commit();
175		}
176
177
178		/**
179		* @expectedException \Exception
180		* @expectedExceptionMessage No diff data
181		*/
182		public function testCommitWithoutDiffData()
183		{
184		$dbDiff = $this->buildMock();
185		$dbDiff->commit();
186		}
187
188
189		public function testCompareWithDeleteMode()
190		{
191		$dbDiff = $this->buildMock();
192		$dataNew = [
193		self::$tableUser => [
194		'uuid' => null,
195		],
196		];
197		$dataOld = [
198		self::$tableUser => [
199		'uuid' => self::$uuid1,
200		'title' => 'User Title The Third',
201		'age' => 4200,
202		'credit' => '42',
203		'joindate' => '2012-01-02',
204		],
205		];
206
207		$dbDiff->compare($dataNew, $dataOld);
208		$diff = $dbDiff->getDiff();
209		$diff = $diff[self::$tableUser][0];
210
211		$this->assertEquals('DELETE', $diff['mode']);
212		$this->assertEquals(4, count($diff['column']));
213		}
214
215
216		/**
217		* @expectedException \Exception
218		* @expectedExceptionMessage all null
219		*/
220		public function testCompareWithNullPkInBothDataNewAndOld()
221		{
222		$dbDiff = $this->buildMock();
223		$dataNew = [
224		self::$tableUser => [
225		'uuid' => null,
226		],
227		];
228
229		$dbDiff->compare($dataNew);
230		}
231
232
233		public function testCompareWithUpdateModeWithSameDataNewAndOld()
234		{
235		$dbDiff = $this->buildMock();
236		$dataNew = [
237		self::$tableUser => [
238		'uuid' => self::$uuid1,
239		'title' => 'User Title The Third',
240		'age' => 4200,
241		'credit' => '42',
242		'joindate' => '2012-01-02',
243		],
244		];
245
246		$dbDiff->compare($dataNew, $dataNew);
247
248		$this->assertEmpty($dbDiff->getDiff());
249		}
250
251
252		public function testExecute()
253		{
254		$dbDiff = $this->buildMock();
255
256		// Normal insert
257		$dataNew1 = [
258		self::$tableUser => [
259		'uuid' => self::$uuid1,
260		'title' => 'User Title',
261		'age' => 42,
262		'credit' => '0.42',
263		'joindate' => '2014-01-02',
264		],
265		];
266
267		$dbDiff->execute($dataNew1);
268		$this->assertEquals(1, $dbDiff->getRowCount());
269
270		$diff = $dbDiff->getDiff();
271		$this->assertEquals('INSERT', $diff[self::$tableUser][0]['mode']);
272		$this->assertEquals(1, count($diff[self::$tableUser][0]['pk']));
273		$this->assertEquals(4, count($diff[self::$tableUser][0]['column']));
274
275		$this->assertTrue($dbDiff->isCommitted());
276		$this->assertTrue($dbDiff->isExecuted());
277
278
279		// Insert with PK column only
280		$dataNew2 = [
281		self::$tableUser => [
282		'uuid' => self::$uuid2,
283		],
284		];
285
286		$dbDiff->execute($dataNew2);
287		$this->assertEquals(1, $dbDiff->getRowCount());
288		$diff = $dbDiff->getDiff();
289		$this->assertEquals(0, count($diff[self::$tableUser][0]['column']));
290
291		$this->assertEquals(2, self::$db->getRowCount(self::$tableUser));
292
293
294		// Update row with $uuid1, and delete row with $uuid2
295		$dataNewChanged = [
296		self::$tableUser => [
297		// Modify from $dataNew1
298		[
299		'uuid' => self::$uuid1,
300		'title' => 'User Title Changed',
301		'age' => 420,
302		'credit' => '4.2',
303		'joindate' => '2013-01-02',
304		],
305		[
306		'uuid' => null,
307		]
308		],
309		];
310		$dataOld = [
311		self::$tableUser => [
312		$dataNew1[self::$tableUser],
313		$dataNew2[self::$tableUser],
314		],
315		];
316		$dbDiff->execute($dataNewChanged, $dataOld);
317
318		$this->assertEquals(2, $dbDiff->getRowCount());
319		$this->assertEquals(
320		420,
321		self::$db->getByKey(self::$tableUser, self::$uuid1, 'age', 'uuid')
322		);
323		$this->assertEquals(1, self::$db->getRowCount(self::$tableUser));
324
325
326		// Rollback last update and delete
327		$dbDiff->rollback();
328
329		$this->assertTrue($dbDiff->isRollbacked());
330		$this->assertEquals(
331		42,
332		self::$db->getByKey(self::$tableUser, self::$uuid1, 'age', 'uuid')
333		);
334		$this->assertEquals(2, self::$db->getRowCount(self::$tableUser));
335
336
337		// Then commit again
338		$dbDiff->commit();
339
340		$this->assertTrue($dbDiff->isCommitted());
341		$this->assertEquals(
342		420,
343		self::$db->getByKey(self::$tableUser, self::$uuid1, 'age', 'uuid')
344		);
345		$this->assertEquals(1, self::$db->getRowCount(self::$tableUser));
346		}
347
348
349		/**
350		* @expectedException \Exception
351		* @expectedExceptionMessage can't execute again
352		*/
353	View Code Duplication	public function testExecuteAgain()
		0 ignored issues – show Duplication introduced 2018-01-24 08:29 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...
354		{
355		$dbDiff = $this->buildMock();
356
357		$json = '{
358		"rowCount": 0,
359		"executeStatus": 100,
360		"diff": {
361		"' . self::$tableUser . '": [
362		{
363		"mode": "Whatever",
364		"pk": [],
365		"column": []
366		}
367		]
368		}
369		}';
370
371		$dbDiff->import($json);
372		$dbDiff->execute();
373		}
374
375
376		public function testExecuteInsertThenRollback()
377		{
378		$dbDiff = $this->buildMock();
379
380		$dataNew = [
381		self::$tableUser => [
382		'uuid' => self::$uuid3,
383		],
384		];
385
386		$condition = "WHERE uuid = '" . self::$uuid3 . "'";
387
388
389		// Insert
390		$dbDiff->execute($dataNew);
391		$this->assertEquals(
392		1,
393		self::$db->getRowCount(self::$tableUser, $condition)
394		);
395
396
397		// Export to json and import back
398		$dbDiff->import($dbDiff->export());
399
400
401		// Rollback
402		$dbDiff->rollback();
403		$this->assertEquals(
404		0,
405		self::$db->getRowCount(self::$tableUser, $condition)
406		);
407		}
408
409
410		/**
411		* @expectedException \Exception
412		* @expectedExceptionMessage empty
413		*/
414		public function testExecuteWithEmptyDataNew()
415		{
416		$dbDiff = $this->buildMock();
417		$dbDiff->execute([], null);
418		}
419
420
421		/**
422		* @expectedException \Exception
423		* @expectedExceptionMessage PK not all assigned
424		*/
425	View Code Duplication	public function testExecuteWithNotEnoughPkInDataNew()
		0 ignored issues – show Duplication introduced 2018-01-24 08:29 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...
426		{
427		$dbDiff = $this->buildMock();
428
429		// No PK column uuid
430		$dataNew = [
431		self::$tableUser => [
432		'title' => 'User Title',
433		],
434		];
435
436		$dbDiff->execute($dataNew);
437		}
438
439
440		/**
441		* @expectedException \Exception
442		* @expectedExceptionMessage must have PK
443		*/
444	View Code Duplication	public function testExecuteWithTableHaveNoPk()
		0 ignored issues – show Duplication introduced 2018-01-24 08:29 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...
445		{
446		$dbDiff = $this->buildMock();
447
448		// No PK column uuid
449		$dataNew = [
450		'table_not_exist' => [
451		'title' => 'User Title',
452		],
453		];
454
455		$dbDiff->execute($dataNew);
456		}
457
458
459		/**
460		* @expectedException \Exception
461		* @expectedExceptionMessage Invalid json
462		*/
463		public function testImportInvalidJson()
464		{
465		$dbDiff = $this->buildMock();
466
467		$dbDiff->import('{}');
468		}
469
470
471		/**
472		* @expectedException \Exception
473		* @expectedExceptionMessage can't rollback again
474		*/
475	View Code Duplication	public function testRollbackAgain()
		0 ignored issues – show Duplication introduced 2018-01-24 08:29 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...
476		{
477		$dbDiff = $this->buildMock();
478
479		$json = '{
480		"rowCount": 0,
481		"executeStatus": -100,
482		"diff": {
483		"' . self::$tableUser . '": [
484		{
485		"mode": "Whatever",
486		"pk": [],
487		"column": []
488		}
489		]
490		}
491		}';
492
493		$dbDiff->import($json);
494		$dbDiff->rollback();
495		}
496
497
498		/**
499		* @expectedException \Exception
500		* @expectedExceptionMessage Db execute fail
501		*/
502		public function testRollbackWithDbFail()
503		{
504		$dbDiff = $this->buildMockWithFakeDb();
505
506		$dataNew = [
		0 ignored issues – show Unused Code introduced 2016-06-01 06:17 UTC by Report Bug Copy Issue Report `$dataNew` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
507		self::$tableUser => [
508		'uuid' => self::$uuid1,
509		],
510		];
511
512		self::$getErrorCode = -1;
513		self::$getErrorMessage = 'Db execute fail';
514
515		$json = '{
516		"rowCount": 0,
517		"executeStatus": 100,
518		"diff": {
519		"' . self::$tableUser . '": [
520		{
521		"mode": "INSERT",
522		"pk": {
523		"uuid": {
524		"new": "' . self::$uuid1 . '",
525		"old": null
526		}
527		},
528		"column": []
529		}
530		]
531		}
532		}';
533		$dbDiff->import($json);
534
535		$dbDiff->rollback();
536		}
537
538
539		/**
540		* @expectedException \Exception
541		* @expectedExceptionMessage Invalid mode
542		*/
543	View Code Duplication	public function testRollbackWithInvalidMode()
		0 ignored issues – show Duplication introduced 2018-01-24 08:29 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...
544		{
545		$dbDiff = $this->buildMock();
546
547		$json = '{
548		"rowCount": 0,
549		"executeStatus": 0,
550		"diff": {
551		"' . self::$tableUser . '": [
552		{
553		"mode": "InvalidMode",
554		"pk": [],
555		"column": []
556		}
557		]
558		}
559		}';
560
561		$dbDiff->import($json);
562		$dbDiff->rollback();
563		}
564
565
566		/**
567		* @expectedException \Exception
568		* @expectedExceptionMessage No diff data
569		*/
570		public function testRollbackWithoutDiffData()
571		{
572		$dbDiff = $this->buildMock();
573		$dbDiff->rollback();
574		}
575		}
576

fwolf / fwlib

DbDiffTest A last analyzed 2019-05-09 15:53 UTC

Complexity

Size/Duplication

Coupling/Cohesion

Importance

21 Methods

How to fix Duplicated Code

Duplicated Code

Duplication Side-by-Side

Filter issues like

DbDiffTest A
last analyzed 2019-05-09 15:53 UTC