ResetAutoincrementTest::testAutoincrementResetsOnTruncate()

Complexity

Conditions	1
Paths	1

Size

Total Lines	24
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function testAutoincrementResetsOnTruncate()
    {
        $table = new \Doctrine\DBAL\Schema\Table('autoincremented_table');
        $table->addColumn('id', 'integer', ['autoincrement' => true]);
        $table->addColumn('test_int', 'integer');
        $table->setPrimaryKey(['id']);

        /* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
        $sm = $this->_conn->getSchemaManager();
        $sm->createTable($table);

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

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

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

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

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