hgraca /
php-micro-dbal
| @@ 16-30 (lines=15) @@ | ||
| 13 | * |
|
| 14 | * @small |
|
| 15 | */ |
|
| 16 | public function toString_WithOneLevelAndFiltering() |
|
| 17 | { |
|
| 18 | $whereToken = [ |
|
| 19 | 'id' => 1, |
|
| 20 | 'dummy_column_1' => 'some text', |
|
| 21 | 'dummy_column_2' => null, |
|
| 22 | ]; |
|
| 23 | ||
| 24 | $whereTokenCollection = new WhereTokenCollection($whereToken); |
|
| 25 | ||
| 26 | self::assertEquals( |
|
| 27 | '`id`=' . WhereToken::BINDING_PREFIX . '0 AND `dummy_column_1`=' . WhereToken::BINDING_PREFIX . '1 AND `dummy_column_2` IS ' . WhereToken::BINDING_PREFIX . '2', |
|
| 28 | $whereTokenCollection->toString() |
|
| 29 | ); |
|
| 30 | } |
|
| 31 | ||
| 32 | /** |
|
| 33 | * @test |
|
| @@ 37-51 (lines=15) @@ | ||
| 34 | * |
|
| 35 | * @small |
|
| 36 | */ |
|
| 37 | public function toString_WithOneLevelOrFiltering() |
|
| 38 | { |
|
| 39 | $whereToken = [ |
|
| 40 | 'id' => 1, |
|
| 41 | 'dummy_column_1' => 'some text', |
|
| 42 | 'dummy_column_2' => null, |
|
| 43 | ]; |
|
| 44 | ||
| 45 | $whereTokenCollection = new WhereTokenCollection($whereToken, WhereTokenCollection::OPERATION_OR); |
|
| 46 | ||
| 47 | self::assertEquals( |
|
| 48 | '`id`=' . WhereToken::BINDING_PREFIX . '0 OR `dummy_column_1`=' . WhereToken::BINDING_PREFIX . '1 OR `dummy_column_2` IS ' . WhereToken::BINDING_PREFIX . '2', |
|
| 49 | $whereTokenCollection->toString() |
|
| 50 | ); |
|
| 51 | } |
|
| 52 | ||
| 53 | /** |
|
| 54 | * @test |
|
