DBAL3516Test::testLastInsertIdRelatedToTheMainInsertStatement() - Code Metrics - Inspection of "add test for issue 3516 - invalid last inserted id..." - doctrine/dbal - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — 2.9 (#3517)

unknown

created 2019-04-15 20:50 UTC

testLastInsertIdRelatedToTheMainInsertStatement() A

↳ Parent: DBAL3516Test

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php

namespace Doctrine\Tests\DBAL\Functional\Ticket;

use Doctrine\Tests\DbalFunctionalTestCase;

/**
 * @group DBAL-3516
 */
class DBAL3516Test extends DbalFunctionalTestCase
{
    protected function setUp() : void
    {
        parent::setUp();

        $platform = $this->connection->getDatabasePlatform()->getName();

        if ($platform !== 'mssql') {
            $this->markTestSkipped('Currently restricted to MSSQL');
        }

        $this->connection->query('CREATE TABLE dbal3516(id INT IDENTITY, test int);');
        $this->connection->query('CREATE TABLE dbal3516help(id INT IDENTITY, test int);');
        $this->connection->query(<<<SQL
CREATE TRIGGER dbal3516_after_insert ON dbal3516 AFTER INSERT AS 
    DECLARE @i INT = 0;
    
    WHILE @i < 1000
    BEGIN
        INSERT INTO dbal3516help (test) VALUES (1);
        SET @i = @i + 1;
    END;
SQL
        );
    }

    public function testLastInsertIdRelatedToTheMainInsertStatement() : void
    {
        $this->connection->insert('dbal3516help', ['test' => 1]);
        $this->connection->lastInsertId();
        $this->connection->insert('dbal3516', ['test' => 1]);
        $this->assertEquals(1, $this->connection->lastInsertId());
    }
}


1			<?php
2
3			namespace Doctrine\Tests\DBAL\Functional\Ticket;
4
5			use Doctrine\Tests\DbalFunctionalTestCase;
6
7			/**
8			* @group DBAL-3516
9			*/
10			class DBAL3516Test extends DbalFunctionalTestCase
11			{
12			protected function setUp() : void
13			{
14			parent::setUp();
15
16			$platform = $this->connection->getDatabasePlatform()->getName();
17
18			if ($platform !== 'mssql') {
19			$this->markTestSkipped('Currently restricted to MSSQL');
20			}
21
22			$this->connection->query('CREATE TABLE dbal3516(id INT IDENTITY, test int);');
23			$this->connection->query('CREATE TABLE dbal3516help(id INT IDENTITY, test int);');
24			$this->connection->query(<<<SQL
25			CREATE TRIGGER dbal3516_after_insert ON dbal3516 AFTER INSERT AS
26			DECLARE @i INT = 0;
27
28			WHILE @i < 1000
29			BEGIN
30			INSERT INTO dbal3516help (test) VALUES (1);
31			SET @i = @i + 1;
32			END;
33			SQL
34			);
35			}
36
37			public function testLastInsertIdRelatedToTheMainInsertStatement() : void
38			{
39			$this->connection->insert('dbal3516help', ['test' => 1]);
40			$this->connection->lastInsertId();
41			$this->connection->insert('dbal3516', ['test' => 1]);
42			$this->assertEquals(1, $this->connection->lastInsertId());
43			}
44			}
45

doctrine / dbal

Pull Request — 2.9 (#3517)

testLastInsertIdRelatedToTheMainInsertStatement() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like