doctrine / dbal

        $this->assertLastInsertIdAfterTruncate($this->createQueryInsertExecutor());

    }

    private function assertLastInsertIdAfterTruncate(callable $insertExecutor)

    {

        if (! $this->_conn->getDatabasePlatform()->supportsIdentityColumns()) {

            $this->markTestSkipped('Test only works on platforms with identity columns.');

        }

        $insertExecutor();

        $truncateTableSql = $this->testConnection->getDatabasePlatform()->getTruncateTableSQL('last_insert_id_table');

        $this->testConnection->exec($truncateTableSql);

        $this->assertSame('1', $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdAfterDropTableExec()

    {

        $this->assertLastInsertIdAfterDropTable($this->createQueryInsertExecutor());

    }

    private function assertLastInsertIdAfterDropTable(callable $insertExecutor)

    {

        if (! $this->_conn->getDatabasePlatform()->supportsIdentityColumns()) {

            $this->markTestSkipped('Test only works on platforms with identity columns.');

        }

        $this->createTable('last_insert_id_table_tmp');

        $insertExecutor();

        $this->testConnection->getSchemaManager()->dropTable('last_insert_id_table_tmp');

        $this->assertSame('1', $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdAfterSelectExec()

    {

        $this->assertLastInsertIdInTransaction($this->createQueryInsertExecutor());

    }

    public function assertLastInsertIdInTransaction(callable $insertExecutor)

    {

        if (! $this->_conn->getDatabasePlatform()->supportsIdentityColumns()) {

            $this->markTestSkipped('Test only works on platforms with identity columns.');

        }

        $this->testConnection->beginTransaction();

        $insertExecutor();

        $this->assertSame('1', $this->testConnection->lastInsertId());

        $this->testConnection->rollBack();

    }

    public function testLastInsertIdAfterTransactionCommitExec()

    {

        $this->assertLastInsertIdAfterTransactionCommit($this->createQueryInsertExecutor());

    }

    private function assertLastInsertIdAfterTransactionCommit(callable $insertExecutor)

    {

        if (! $this->_conn->getDatabasePlatform()->supportsIdentityColumns()) {

            $this->markTestSkipped('Test only works on platforms with identity columns.');

        }

        $this->testConnection->beginTransaction();

        $insertExecutor();

        $this->testConnection->commit();

        $this->assertSame('1', $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdAfterTransactionRollbackExec()

    {

        $this->assertLastInsertIdAfterTransactionRollback($this->createQueryInsertExecutor());

    }

    private function assertLastInsertIdAfterTransactionRollback(callable $insertExecutor)

    {

        if (! $this->_conn->getDatabasePlatform()->supportsIdentityColumns()) {

            $this->markTestSkipped('Test only works on platforms with identity columns.');

        }

        $this->testConnection->beginTransaction();

        $insertExecutor();

        $this->testConnection->rollBack();

        $this->assertSame('1', $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdInsertAfterTransactionRollbackExec()

    {

        $this->assertLastInsertIdInsertAfterTransactionRollback($this->createQueryInsertExecutor());

    }

    private function assertLastInsertIdInsertAfterTransactionRollback(callable $insertExecutor)

    {

        if (! $this->_conn->getDatabasePlatform()->supportsIdentityColumns()) {

            $this->markTestSkipped('Test only works on platforms with identity columns.');

        }

        $this->testConnection->beginTransaction();

        $insertExecutor();

        $this->testConnection->rollBack();

        $insertExecutor();

        $expected = $this->testConnection->getDatabasePlatform()->getName() === 'sqlite'

            // SQLite has a different transaction concept, that reuses rolled back IDs

            // See: http://sqlite.1065341.n5.nabble.com/Autoincrement-with-rollback-td79154.html

            ? '1'

            : '2';

        $this->assertSame($expected, $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdReusePreparedStatementPrepare()

    {

        $this->assertSame($expected, $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdReusePreparedStatementPrepare()

    {

        if (! $this->_conn->getDatabasePlatform()->supportsIdentityColumns()) {

            $this->markTestSkipped('Test only works on platforms with identity columns.');

        }

        $statement = $this->testConnection->prepare('INSERT INTO last_insert_id_table (foo) VALUES (1)');

        $statement->execute();

        $statement->execute();

        $this->assertSame('2', $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdReusePreparedStatementQuery()

    {

        $this->assertSame('2', $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdReusePreparedStatementQuery()

    {

        if (! $this->_conn->getDatabasePlatform()->supportsIdentityColumns()) {

            $this->markTestSkipped('Test only works on platforms with identity columns.');

        }

        $statement = $this->testConnection->query('INSERT INTO last_insert_id_table (foo) VALUES (1)');

        $statement->execute();

        $this->assertSame('2', $this->testConnection->lastInsertId());

    }

    public function testLastInsertIdConnectionScope()

    {