@@ 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 |