SetBased\Stratum\MySql\Test\NoneTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	42
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

<?php
class NoneTest extends DataLayerTestCase
{
  //--------------------------------------------------------------------------------------------------------------------
  /**
   * Stored routine with designation type none must return the number of rows affected.
   */
  public function test1()
  {
    $ret = $this->dataLayer->tstTestNone(0);
    self::assertEquals(0, $ret);
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * Stored routine with designation type none must return the number of rows affected.
   */
  public function test2()
  {
    // MariaDB 10.3 and above returns the total number of rows affected in the stored routine (not the affected rows
    // of the last statement).
    $expected = ($this->isMariaDB103plus()) ? 2 : 1;

    $ret = $this->dataLayer->tstTestNone(1);
    self::assertEquals($expected, $ret);
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * Stored routine with designation type none must return the number of rows affected.
   */
  public function test3()
  {
    // MariaDB 10.3 and above returns the total number of rows affected in the stored routine (not the affected rows
    // of the last statement).
    $expected = ($this->isMariaDB103plus()) ? 40 : 20;

    $ret = $this->dataLayer->tstTestNone(20);
    self::assertEquals($expected, $ret);
  }

  //--------------------------------------------------------------------------------------------------------------------
}