Doctrine\Tests\DBAL\Functional\ResetAutoincrementTest

Complexity

Total Complexity

2

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	testAutoincrementResetsOnTruncate()	0	24	1
A	getIdByTestInt()	0	6	1

<?php

namespace Doctrine\Tests\DBAL\Functional;

use Doctrine\DBAL\Schema\AbstractSchemaManager;
use Doctrine\DBAL\Schema\Table;

class ResetAutoincrementTest extends \Doctrine\Tests\DbalFunctionalTestCase
{
    public function testAutoincrementResetsOnTruncate()
    {
        $table = new Table('autoincremented_table');
        $table->addColumn('id', 'integer', ['autoincrement' => true]);
        $table->addColumn('test_int', 'integer');
        $table->setPrimaryKey(['id']);

        /* @var $sm AbstractSchemaManager */
        $sm = $this->connection->getSchemaManager();
        $sm->createTable($table);

        $this->connection->insert('autoincremented_table', ['test_int' => 1]);
        $this->connection->insert('autoincremented_table', ['test_int' => 2]);
        $this->connection->insert('autoincremented_table', ['test_int' => 3]);

        $lastId = $this->getIdByTestInt(3);

        $this->assertEquals(3, $lastId);

        $this->connection->exec($this->connection->getDatabasePlatform()->getTruncateTableSQL('autoincremented_table'));

        $this->connection->insert('autoincremented_table', ['test_int' => 4]);
        $lastId = $this->getIdByTestInt(4);
        $this->assertEquals(1, $lastId);
    }

    protected function getIdByTestInt(int $whereTestInt)
    {
        $row = $this->connection->fetchAssoc('SELECT id FROM autoincremented_table WHERE test_int = ?', [$whereTestInt]);
        $row = array_change_key_case($row, \CASE_LOWER);

It seems like $row can also be of type false; however, parameter $input of array_change_key_case() does only seem to accept array, maybe add an additional type check?

        return $row['id'];
    }
}