|
@@ 58-72 (lines=15) @@
|
| 55 |
|
* |
| 56 |
|
* @small |
| 57 |
|
*/ |
| 58 |
|
public function toString_WithTwoLevelAndFiltering() |
| 59 |
|
{ |
| 60 |
|
$whereToken = [ |
| 61 |
|
'id' => [1, 2, 3], |
| 62 |
|
'dummy_column_1' => 'some text', |
| 63 |
|
'dummy_column_2' => null, |
| 64 |
|
]; |
| 65 |
|
|
| 66 |
|
$whereTokenCollection = new WhereTokenCollection($whereToken); |
| 67 |
|
|
| 68 |
|
self::assertEquals( |
| 69 |
|
'(`id`=' . WhereToken::BINDING_PREFIX . '0 OR `id`=' . WhereToken::BINDING_PREFIX . '1 OR `id`=' . WhereToken::BINDING_PREFIX . '2) AND `dummy_column_1`=' . WhereToken::BINDING_PREFIX . '3 AND `dummy_column_2` IS ' . WhereToken::BINDING_PREFIX . '4', |
| 70 |
|
$whereTokenCollection->toString() |
| 71 |
|
); |
| 72 |
|
} |
| 73 |
|
|
| 74 |
|
/** |
| 75 |
|
* @test |
|
@@ 79-93 (lines=15) @@
|
| 76 |
|
* |
| 77 |
|
* @small |
| 78 |
|
*/ |
| 79 |
|
public function toString_WithTwoLevelOrFiltering() |
| 80 |
|
{ |
| 81 |
|
$whereToken = [ |
| 82 |
|
'id' => [1, 2, 3], |
| 83 |
|
'dummy_column_1' => 'some text', |
| 84 |
|
'dummy_column_2' => null, |
| 85 |
|
]; |
| 86 |
|
|
| 87 |
|
$whereTokenCollection = new WhereTokenCollection($whereToken, WhereTokenCollection::OPERATION_OR); |
| 88 |
|
|
| 89 |
|
self::assertEquals( |
| 90 |
|
'(`id`=' . WhereToken::BINDING_PREFIX . '0 AND `id`=' . WhereToken::BINDING_PREFIX . '1 AND `id`=' . WhereToken::BINDING_PREFIX . '2) OR `dummy_column_1`=' . WhereToken::BINDING_PREFIX . '3 OR `dummy_column_2` IS ' . WhereToken::BINDING_PREFIX . '4', |
| 91 |
|
$whereTokenCollection->toString() |
| 92 |
|
); |
| 93 |
|
} |
| 94 |
|
|
| 95 |
|
/** |
| 96 |
|
* @test |
|
@@ 100-114 (lines=15) @@
|
| 97 |
|
* |
| 98 |
|
* @small |
| 99 |
|
*/ |
| 100 |
|
public function toString_WithTwoLevelAndNestedNull() |
| 101 |
|
{ |
| 102 |
|
$whereToken = [ |
| 103 |
|
'id' => [1, null, 3], |
| 104 |
|
'dummy_column_1' => 'some text', |
| 105 |
|
'dummy_column_2' => null, |
| 106 |
|
]; |
| 107 |
|
|
| 108 |
|
$whereTokenCollection = new WhereTokenCollection($whereToken); |
| 109 |
|
|
| 110 |
|
self::assertEquals( |
| 111 |
|
'(`id`=' . WhereToken::BINDING_PREFIX . '0 OR `id` IS ' . WhereToken::BINDING_PREFIX . '1 OR `id`=' . WhereToken::BINDING_PREFIX . '2) AND `dummy_column_1`=' . WhereToken::BINDING_PREFIX . '3 AND `dummy_column_2` IS ' . WhereToken::BINDING_PREFIX . '4', |
| 112 |
|
$whereTokenCollection->toString() |
| 113 |
|
); |
| 114 |
|
} |
| 115 |
|
|
| 116 |
|
/** |
| 117 |
|
* @test |