| 1 | <?php |
||
| 9 | class RowsWithLobTest extends DataLayerTestCase |
||
| 10 | { |
||
| 11 | //-------------------------------------------------------------------------------------------------------------------- |
||
| 12 | /** |
||
| 13 | * Stored routine with designation type rows must return an array with 1 row when only 1 row is selected. |
||
| 14 | */ |
||
| 15 | public function test1() |
||
| 16 | { |
||
| 17 | $ret = $this->dataLayer->tstTestRows1WithLob(1, 'blob'); |
||
| 18 | self::assertIsArray($ret); |
||
| 19 | self::assertCount(1, $ret); |
||
| 20 | } |
||
| 21 | |||
| 22 | //-------------------------------------------------------------------------------------------------------------------- |
||
| 23 | /** |
||
| 24 | * Stored routine with designation type rows must return an array with 3 rows when 3 rows are selected. |
||
| 25 | */ |
||
| 26 | public function test2() |
||
| 27 | { |
||
| 28 | $ret = $this->dataLayer->tstTestRows1WithLob(3, 'blob'); |
||
| 29 | self::assertIsArray($ret); |
||
| 30 | self::assertCount(3, $ret); |
||
| 31 | } |
||
| 32 | |||
| 33 | //-------------------------------------------------------------------------------------------------------------------- |
||
| 34 | /** |
||
| 35 | * Stored routine with designation type rows must return an empty array when no rows are selected. |
||
| 36 | */ |
||
| 37 | public function testSelect0Rows() |
||
| 38 | { |
||
| 39 | $ret = $this->dataLayer->tstTestRows1WithLob(0, 'blob'); |
||
| 40 | self::assertIsArray($ret); |
||
| 41 | self::assertCount(0, $ret); |
||
| 42 | } |
||
| 43 | |||
| 44 | //-------------------------------------------------------------------------------------------------------------------- |
||
| 45 | } |
||
| 46 | |||
| 49 |