TransactionTest.php 950 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
<?php

namespace Doctrine\Tests\DBAL\Functional;

use Doctrine\DBAL\Platforms\MySqlPlatform;
use Doctrine\Tests\DbalFunctionalTestCase;
use function sleep;

class TransactionTest extends DbalFunctionalTestCase
{
    protected function setUp() : void
    {
        parent::setUp();

        if ($this->connection->getDatabasePlatform() instanceof MySqlPlatform) {
            return;
        }

        $this->markTestSkipped('Restricted to MySQL.');
    }

    protected function tearDown() : void
    {
        $this->resetSharedConn();

        parent::tearDown();
    }

    public function testCommitFalse() : void
    {
        $this->connection->query('SET SESSION wait_timeout=1');

        $this->assertTrue($this->connection->beginTransaction());

        sleep(2); // during the sleep mysql will close the connection

        $this->assertFalse(@$this->connection->commit()); // we will ignore `MySQL server has gone away` warnings
    }
}