Order of execution of unit tests

Question

Is there any way to define the order of execution of the test methods ?

When I put the function code testSelectDaInsercao inside testInsercaoDeDados the tests are executed successfully, but this way the test fails. I believe it is due to the execution order.

I looked in the documentation and saw only something about dependsand made it clear that this would not change the order. I already reversed the order of the methods, but the test also failed !

use Application\Conn;
use Application\operacao;
use PHPUnit\Framework\TestCase;

class PHPTest extends TestCase 
{
    private $conn;

    public function setUp()
    {
        $this->conn = new Conn();
        $this->conn = $this->conn->retornaConexao();
    }

    public function testInsercaoDeDados()
    {      
        $stmt = $this->conn->prepare("INSERT INTO usuario values (?, ?)");

        $stmt->bindValue(1, 'teste', \PDO::PARAM_STR);
        $stmt->bindValue(2, '123456', \PDO::PARAM_STR);

        $resul = $stmt->execute();
        $this->assertTrue($resul);  
    }

    public function testSelectDaInsercao()
    {
        $resul = $this->conn->query("SELECT count(usuario.nome) as id 
                                    FROM usuario WHERE nome = 'teste' 
                                    AND senha = '123456'");

        $resul = $resul->fetch(\PDO::FETCH_ASSOC);

        $resul = (int) $resul['id'];

        $this->assertEquals(1, $resul, 'erro ao comparar insercao'); 
    }

    public function tearDown()
    {           
        $this->conn->query("truncate table usuario");
    }

}

using depends /** * @depends testInsercaoDeDados **/

Answer 1

The problem is in the method tearDown:

public function tearDown()
{           
    $this->conn->query("truncate table usuario");
}

This method is always executed after each test, whether valid or failed. That is, when the test testInsercaoDeDados is executed, information is recorded, but when the test is completed, the method tearDown is executed by clearing the records. When the test testSelectDaInsercao is executed, there will be no records.

To get around this problem, you can do the truncate of the table in the method tearDownAfterClass, as this will be performed only when ALL tests are run, thus ensuring that records are persisted while tests are running.

Answer 2

Your problem is not in the order of execution, it is in the method tearDown.

Phpunit will execute the methods setUp and tearDown after each execution class method.

As his tearDown is giving a truncate in the whole table (which is correct), when running the next test of this class it will start with the table reset again.

To solve this, two approaches can be taken:

Unify both tests into one:

use Application\Conn;
use Application\operacao;
use PHPUnit\Framework\TestCase;

class PHPTest extends TestCase 
{
    private $conn;

    public function setUp()
    {
        $this->conn = new Conn();
        $this->conn = $this->conn->retornaConexao();
    }

    public function testInsertAndRecoverFromDatabase()
    {      
        $stmt = $this->conn->prepare("INSERT INTO usuario values (?, ?)");

        $stmt->bindValue(1, 'teste', \PDO::PARAM_STR);
        $stmt->bindValue(2, '123456', \PDO::PARAM_STR);

        $result = $stmt->execute();
        $this->assertTrue($result);

        $selectResult = $this->conn->query("SELECT count(usuario.nome) as id 
                                    FROM usuario WHERE nome = 'teste' 
                                    AND senha = '123456'");

        $selectResult = $selectResult->fetch(\PDO::FETCH_ASSOC);

        $insertedId = (int) $resul['id'];

        $this->assertEquals(1, $insertedId , 'erro ao comparar insercao'); 
    }    

    public function tearDown()
    {           
        $this->conn->query("truncate table usuario");
    }    
}

In place of setUp and tearDown, use setUpBeforeClass and tearDownAfterClass. These are two static methods that run only in the construction of the entire test class. Combined with the @depends you can ensure that both tests are run.

use Application\Conn;
use Application\operacao;
use PHPUnit\Framework\TestCase;

class PHPTest extends TestCase 
{
    private static $conn;

    public static function setUpBeforeClass()
    {
        static::$conn = (new Conn())->retornaConexao();
    }

    public function testInsertIntoDatabase()
    {      
        $stmt = static::$conn->prepare("INSERT INTO usuario values (?, ?)");

        $stmt->bindValue(1, 'teste', \PDO::PARAM_STR);
        $stmt->bindValue(2, '123456', \PDO::PARAM_STR);

        $result = $stmt->execute();
        $this->assertTrue($result);

        $selectResult = static::$conn->query("SELECT count(usuario.nome) as id 
                                    FROM usuario WHERE nome = 'teste' 
                                    AND senha = '123456'");

        $selectResult = $selectResult->fetch(\PDO::FETCH_ASSOC);

        $insertedId = (int) $resul['id'];

        $this->assertEquals(1, $insertedId , 'erro ao comparar insercao'); 
    }    

    /** @depends testInsertIntoDatabase */
    public function testSelectPreviousInsertedRegister()
    {
        $resul = $this->conn->query("SELECT count(usuario.nome) as id 
                                    FROM usuario WHERE nome = 'teste' 
                                    AND senha = '123456'");

        $resul = $resul->fetch(\PDO::FETCH_ASSOC);

        $resul = (int) $resul['id'];

        $this->assertEquals(1, $resul, 'erro ao comparar insercao'); 
    }

    public static function tearDownAfterClass()
    {           
        static::$conn->query("truncate table usuario");
    }    
}