@@ -66,10 +66,10 @@ discard block |
||
66 | 66 | $workArray[] = $value; |
67 | 67 | } |
68 | 68 | |
69 | - $returnString = ''; # Initialize return string |
|
70 | - $arraySize = count($workArray); # Get size of array |
|
69 | + $returnString = ''; # Initialize return string |
|
70 | + $arraySize = count($workArray); # Get size of array |
|
71 | 71 | |
72 | - for ($i=0; $i<$arraySize; $i++) { |
|
72 | + for ($i = 0; $i < $arraySize; $i++) { |
|
73 | 73 | # Nested array, process nest item |
74 | 74 | if (is_array($workArray[$i])) { |
75 | 75 | $returnString .= $this->str_putcsv($workArray[$i], $delimiter, $enclosure, $terminator); |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | switch (gettype($workArray[$i])) { |
78 | 78 | # Manually set some strings |
79 | 79 | case "NULL": $_spFormat = ''; break; |
80 | - case "boolean": $_spFormat = (true == $workArray[$i]) ? 'true': 'false'; break; |
|
80 | + case "boolean": $_spFormat = (true == $workArray[$i]) ? 'true' : 'false'; break; |
|
81 | 81 | # Make sure sprintf has a good datatype to work with |
82 | 82 | case "integer": $_spFormat = '%i'; break; |
83 | 83 | case "double": $_spFormat = '%0.2f'; break; |
@@ -87,8 +87,8 @@ discard block |
||
87 | 87 | case "resource": |
88 | 88 | default: $_spFormat = ''; break; |
89 | 89 | } |
90 | - $returnString .= sprintf('%2$s'.$_spFormat.'%2$s', $workArray[$i], $enclosure); |
|
91 | - $returnString .= ($i < ($arraySize-1)) ? $delimiter : $terminator; |
|
90 | + $returnString .= sprintf('%2$s' . $_spFormat . '%2$s', $workArray[$i], $enclosure); |
|
91 | + $returnString .= ($i < ($arraySize - 1)) ? $delimiter : $terminator; |
|
92 | 92 | } |
93 | 93 | } |
94 | 94 | # Done the workload, return the output information |
@@ -56,17 +56,17 @@ |
||
56 | 56 | if (is_array($sval)) { |
57 | 57 | foreach ($sval as $_skey => $_sval) { |
58 | 58 | if (is_numeric($_skey)) { |
59 | - $data[] = $skey.'[] = '.(is_numeric($_sval) ? $_sval : (ctype_upper($_sval) ? $_sval : '"'.$_sval.'"')); |
|
59 | + $data[] = $skey . '[] = ' . (is_numeric($_sval) ? $_sval : (ctype_upper($_sval) ? $_sval : '"' . $_sval . '"')); |
|
60 | 60 | } else { |
61 | - $data[] = $skey.'['.$_skey.'] = '.(is_numeric($_sval) ? $_sval : (ctype_upper($_sval) ? $_sval : '"'.$_sval.'"')); |
|
61 | + $data[] = $skey . '[' . $_skey . '] = ' . (is_numeric($_sval) ? $_sval : (ctype_upper($_sval) ? $_sval : '"' . $_sval . '"')); |
|
62 | 62 | } |
63 | 63 | } |
64 | 64 | } else { |
65 | - $data[] = $skey.' = '.(is_numeric($sval) ? $sval : (ctype_upper($sval) ? $sval : '"'.$sval.'"')); |
|
65 | + $data[] = $skey . ' = ' . (is_numeric($sval) ? $sval : (ctype_upper($sval) ? $sval : '"' . $sval . '"')); |
|
66 | 66 | } |
67 | 67 | } |
68 | 68 | } else { |
69 | - $data[] = $key.' = '.(is_numeric($val) ? $val : (ctype_upper($val) ? $val : '"'.$val.'"')); |
|
69 | + $data[] = $key . ' = ' . (is_numeric($val) ? $val : (ctype_upper($val) ? $val : '"' . $val . '"')); |
|
70 | 70 | } |
71 | 71 | // empty line |
72 | 72 | $data[] = null; |
@@ -17,19 +17,19 @@ |
||
17 | 17 | const ORDER_ASC = 'ASC'; |
18 | 18 | const ORDER_DESC = 'DESC'; |
19 | 19 | |
20 | - const OPERATION_NULL = 'nul'; // is null |
|
21 | - const OPERATION_NNULL = 'nnul'; // is not null |
|
22 | - const OPERATION_EQ = 'eq'; // = |
|
23 | - const OPERATION_NEQ = 'neq'; // != |
|
24 | - const OPERATION_GT = 'gt'; // > |
|
25 | - const OPERATION_GTE = 'gte'; // >= |
|
26 | - const OPERATION_LT = 'lt'; // < |
|
27 | - const OPERATION_LTE = 'lte'; // <= |
|
28 | - const OPERATION_LIKE = 'like'; // like... |
|
20 | + const OPERATION_NULL = 'nul'; // is null |
|
21 | + const OPERATION_NNULL = 'nnul'; // is not null |
|
22 | + const OPERATION_EQ = 'eq'; // = |
|
23 | + const OPERATION_NEQ = 'neq'; // != |
|
24 | + const OPERATION_GT = 'gt'; // > |
|
25 | + const OPERATION_GTE = 'gte'; // >= |
|
26 | + const OPERATION_LT = 'lt'; // < |
|
27 | + const OPERATION_LTE = 'lte'; // <= |
|
28 | + const OPERATION_LIKE = 'like'; // like... |
|
29 | 29 | const OPERATION_NLIKE = 'nlike'; // not like |
30 | - const OPERATION_REXP = 'rexp'; // regex |
|
31 | - const OPERATION_IN = 'in'; // in () |
|
32 | - const OPERATION_NIN = 'nin'; // not in () |
|
30 | + const OPERATION_REXP = 'rexp'; // regex |
|
31 | + const OPERATION_IN = 'in'; // in () |
|
32 | + const OPERATION_NIN = 'nin'; // not in () |
|
33 | 33 | |
34 | 34 | const AGGREGATE_AVG = 'AVG'; |
35 | 35 | const AGGREGATE_COUNT = 'COUNT'; |
@@ -68,7 +68,7 @@ |
||
68 | 68 | ['15', '2', '15', ''], |
69 | 69 | ['18.8', '3', '18.8', ''], |
70 | 70 | ['lkjhgdf', '4', 'lkjhgdf', ''], |
71 | - ], $format->unpack($format->pack($data). PHP_EOL . PHP_EOL)); |
|
71 | + ], $format->unpack($format->pack($data) . PHP_EOL . PHP_EOL)); |
|
72 | 72 | } |
73 | 73 | |
74 | 74 | /** |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | $query->addProperty('foo', 'vrs', 'abh'); |
38 | 38 | $sql = new Dialects\SQLite(); |
39 | 39 | $this->assertEquals('INSERT INTO "foo" ("bar", "htf", "vrs") VALUES (:bar_0, :htf_1, :vrs_2);', $sql->insert($query)); |
40 | - $this->assertEquals([ ':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ], $query->getParams()); |
|
40 | + $this->assertEquals([':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ], $query->getParams()); |
|
41 | 41 | $query->resetCounter(); |
42 | 42 | } |
43 | 43 | |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | $query->setLimit(5); |
54 | 54 | $sql = new Dialects\SQLite(); |
55 | 55 | $this->assertEquals('DELETE FROM "foo" WHERE "dbt" = :dbt_0 AND "dfd" != :dfd_1;', $sql->delete($query)); |
56 | - $this->assertEquals([ ':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
56 | + $this->assertEquals([':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
57 | 57 | $query->resetCounter(); |
58 | 58 | } |
59 | 59 | |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | $query->addCondition('foo', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
72 | 72 | $sql = new Dialects\SQLite(); |
73 | 73 | $this->assertEquals('UPDATE "foo" SET "bar" = :bar_0, "htf" = :htf_1, "vrs" = :vrs_2 WHERE "dbt" = :dbt_3 AND "dfd" != :dfd_4;', $sql->update($query)); |
74 | - $this->assertEquals([ ':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ':dbt_3' => 'ggf', ':dfd_4' => 'yxn', ], $query->getParams()); |
|
74 | + $this->assertEquals([':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ':dbt_3' => 'ggf', ':dfd_4' => 'yxn', ], $query->getParams()); |
|
75 | 75 | $query->resetCounter(); |
76 | 76 | } |
77 | 77 | |
@@ -86,7 +86,7 @@ discard block |
||
86 | 86 | $query->addCondition('', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
87 | 87 | $query->addOrderBy('foo', 'yjd', IQueryBuilder::ORDER_DESC); |
88 | 88 | $query->addGroupBy('foo', 'gds'); |
89 | - $query->setLimits(5,3); |
|
89 | + $query->setLimits(5, 3); |
|
90 | 90 | $sql = new Dialects\SQLite(); |
91 | 91 | $this->assertEquals('SELECT * FROM "foo" WHERE "dbt" = :dbt_0 AND "dfd" != :dfd_1 GROUP BY "gds" ORDER BY "yjd" DESC LIMIT 3 OFFSET 5;', $sql->select($query)); |
92 | 92 | $query->setOffset(null); |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | $query->setLimit(null); |
95 | 95 | $query->addHavingCondition('', 'ksd', IQueryBuilder::OPERATION_GTE, 25); |
96 | 96 | $this->assertEquals('SELECT * FROM "foo" WHERE "dbt" = :dbt_0 AND "dfd" != :dfd_1 GROUP BY "gds" HAVING "ksd" >= :ksd_2 ORDER BY "yjd" DESC;', $sql->select($query)); |
97 | - $this->assertEquals([ ':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ':ksd_2' => 25, ], $query->getParams()); |
|
97 | + $this->assertEquals([':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ':ksd_2' => 25, ], $query->getParams()); |
|
98 | 98 | $query->resetCounter(); |
99 | 99 | } |
100 | 100 | |
@@ -111,14 +111,14 @@ discard block |
||
111 | 111 | $query->addCondition('foo', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
112 | 112 | $query->addOrderBy('foo', 'yjd', IQueryBuilder::ORDER_DESC); |
113 | 113 | $query->addGroupBy('foo', 'gds'); |
114 | - $query->setLimits(5,3); |
|
114 | + $query->setLimits(5, 3); |
|
115 | 115 | $sql = new Dialects\SQLite(); |
116 | 116 | $this->assertEquals('SELECT "bar" AS "baz", "htf" AS "yjd" FROM "foo" WHERE "dbt" = :dbt_0 AND "dfd" != :dfd_1 GROUP BY "gds" ORDER BY "yjd" DESC LIMIT 3 OFFSET 5;', $sql->select($query)); |
117 | 117 | $query->setOffset(null); |
118 | 118 | $this->assertEquals('SELECT "bar" AS "baz", "htf" AS "yjd" FROM "foo" WHERE "dbt" = :dbt_0 AND "dfd" != :dfd_1 GROUP BY "gds" ORDER BY "yjd" DESC LIMIT 3;', $sql->select($query)); |
119 | 119 | $query->setLimit(null); |
120 | 120 | $this->assertEquals('SELECT "bar" AS "baz", "htf" AS "yjd" FROM "foo" WHERE "dbt" = :dbt_0 AND "dfd" != :dfd_1 GROUP BY "gds" ORDER BY "yjd" DESC;', $sql->select($query)); |
121 | - $this->assertEquals([ ':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
121 | + $this->assertEquals([':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
122 | 122 | $query->resetCounter(); |
123 | 123 | } |
124 | 124 | |
@@ -137,14 +137,14 @@ discard block |
||
137 | 137 | $query->addCondition('foo', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
138 | 138 | $query->addOrderBy('dfg', 'vrs', IQueryBuilder::ORDER_ASC); |
139 | 139 | $query->addGroupBy('foo', 'gds'); |
140 | - $query->setLimits(5,3); |
|
140 | + $query->setLimits(5, 3); |
|
141 | 141 | $sql = new Dialects\SQLite(); |
142 | 142 | $this->assertEquals('SELECT "foo"."bar" AS "baz", "foo"."htf" AS "yjd", "dfg"."vrs" AS "abh" FROM "foo" LEFT JOIN "btr" AS "dfg" ON ("foo"."fds" = "dfg"."gda") WHERE "foo"."dbt" = :dbt_0 AND "foo"."dfd" != :dfd_1 GROUP BY "foo"."gds" ORDER BY "dfg"."vrs" ASC LIMIT 3 OFFSET 5;', $sql->select($query)); |
143 | 143 | $query->setOffset(null); |
144 | 144 | $this->assertEquals('SELECT "foo"."bar" AS "baz", "foo"."htf" AS "yjd", "dfg"."vrs" AS "abh" FROM "foo" LEFT JOIN "btr" AS "dfg" ON ("foo"."fds" = "dfg"."gda") WHERE "foo"."dbt" = :dbt_0 AND "foo"."dfd" != :dfd_1 GROUP BY "foo"."gds" ORDER BY "dfg"."vrs" ASC LIMIT 3;', $sql->select($query)); |
145 | 145 | $query->setLimit(null); |
146 | 146 | $this->assertEquals('SELECT "foo"."bar" AS "baz", "foo"."htf" AS "yjd", "dfg"."vrs" AS "abh" FROM "foo" LEFT JOIN "btr" AS "dfg" ON ("foo"."fds" = "dfg"."gda") WHERE "foo"."dbt" = :dbt_0 AND "foo"."dfd" != :dfd_1 GROUP BY "foo"."gds" ORDER BY "dfg"."vrs" ASC;', $sql->select($query)); |
147 | - $this->assertEquals([ ':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
147 | + $this->assertEquals([':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
148 | 148 | $query->resetCounter(); |
149 | 149 | } |
150 | 150 | } |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | $query->addProperty('foo', 'vrs', 'abh'); |
38 | 38 | $sql = new Dialects\Oracle(); |
39 | 39 | $this->assertEquals('INSERT INTO `foo` (`bar`, `htf`, `vrs`) VALUES (:bar_0, :htf_1, :vrs_2);', $sql->insert($query)); |
40 | - $this->assertEquals([ ':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ], $query->getParams()); |
|
40 | + $this->assertEquals([':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ], $query->getParams()); |
|
41 | 41 | $query->resetCounter(); |
42 | 42 | } |
43 | 43 | |
@@ -52,7 +52,7 @@ discard block |
||
52 | 52 | $query->addCondition('foo', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
53 | 53 | $sql = new Dialects\Oracle(); |
54 | 54 | $this->assertEquals('DELETE FROM `foo` WHERE `dbt` = :dbt_0 AND `dfd` != :dfd_1;', $sql->delete($query)); |
55 | - $this->assertEquals([ ':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
55 | + $this->assertEquals([':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
56 | 56 | $query->resetCounter(); |
57 | 57 | } |
58 | 58 | |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | $query->addCondition('foo', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
71 | 71 | $sql = new Dialects\Oracle(); |
72 | 72 | $this->assertEquals('UPDATE `foo` SET `bar` = :bar_0, `htf` = :htf_1, `vrs` = :vrs_2 WHERE `dbt` = :dbt_3 AND `dfd` != :dfd_4;', $sql->update($query)); |
73 | - $this->assertEquals([ ':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ':dbt_3' => 'ggf', ':dfd_4' => 'yxn', ], $query->getParams()); |
|
73 | + $this->assertEquals([':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ':dbt_3' => 'ggf', ':dfd_4' => 'yxn', ], $query->getParams()); |
|
74 | 74 | $query->resetCounter(); |
75 | 75 | } |
76 | 76 | |
@@ -89,10 +89,10 @@ discard block |
||
89 | 89 | $query->addCondition('foo', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
90 | 90 | $query->addOrderBy('dfg', 'vrs', IQueryBuilder::ORDER_ASC); |
91 | 91 | $query->addGroupBy('foo', 'gds'); |
92 | - $query->setLimits(5,3); |
|
92 | + $query->setLimits(5, 3); |
|
93 | 93 | $sql = new Dialects\Oracle(); |
94 | 94 | $this->assertEquals('SELECT `foo`.`bar` AS `baz`, `foo`.`htf` AS `yjd`, `dfg`.`vrs` AS `abh` FROM `foo` LEFT JOIN `btr` AS `dfg` ON (`foo`.`fds` = `dfg`.`gda`) WHERE `foo`.`dbt` = :dbt_0 AND `foo`.`dfd` != :dfd_1 GROUP BY `foo`.`gds` ORDER BY `dfg`.`vrs` ASC OFFSET 5 ROWS FETCH NEXT 3 ROWS ONLY;', $sql->select($query)); |
95 | - $this->assertEquals([ ':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
95 | + $this->assertEquals([':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
96 | 96 | $query->setLimit(null); |
97 | 97 | $this->assertEquals('SELECT `foo`.`bar` AS `baz`, `foo`.`htf` AS `yjd`, `dfg`.`vrs` AS `abh` FROM `foo` LEFT JOIN `btr` AS `dfg` ON (`foo`.`fds` = `dfg`.`gda`) WHERE `foo`.`dbt` = :dbt_0 AND `foo`.`dfd` != :dfd_1 GROUP BY `foo`.`gds` ORDER BY `dfg`.`vrs` ASC;', $sql->select($query)); |
98 | 98 | $query->resetCounter(); |
@@ -41,7 +41,7 @@ |
||
41 | 41 | $query->addProperty('foo', 'htf', 'yjd'); |
42 | 42 | $query->addProperty('foo', 'vrs', 'abh'); |
43 | 43 | $sql = new LdapQueries(); |
44 | - $this->assertEquals([ 'bar' => 'baz', 'htf' => 'yjd', 'vrs' => 'abh', ], $sql->changed($query)); |
|
44 | + $this->assertEquals(['bar' => 'baz', 'htf' => 'yjd', 'vrs' => 'abh', ], $sql->changed($query)); |
|
45 | 45 | $query->resetCounter(); |
46 | 46 | } |
47 | 47 |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | $query->addProperty('foo', 'vrs', 'abh'); |
38 | 38 | $sql = new Dialects\PostgreSQL(); |
39 | 39 | $this->assertEquals('INSERT INTO "foo" ("bar", "htf", "vrs") VALUES (:bar_0, :htf_1, :vrs_2);', $sql->insert($query)); |
40 | - $this->assertEquals([ ':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ], $query->getParams()); |
|
40 | + $this->assertEquals([':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ], $query->getParams()); |
|
41 | 41 | $query->resetCounter(); |
42 | 42 | } |
43 | 43 | |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | $query->setLimit(5); |
54 | 54 | $sql = new Dialects\PostgreSQL(); |
55 | 55 | $this->assertEquals('DELETE FROM "foo" WHERE "dbt" = :dbt_0 AND "dfd" != :dfd_1;', $sql->delete($query)); |
56 | - $this->assertEquals([ ':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
56 | + $this->assertEquals([':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
57 | 57 | $query->resetCounter(); |
58 | 58 | } |
59 | 59 | |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | $query->addCondition('foo', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
72 | 72 | $sql = new Dialects\PostgreSQL(); |
73 | 73 | $this->assertEquals('UPDATE "foo" SET "bar" = :bar_0, "htf" = :htf_1, "vrs" = :vrs_2 WHERE "dbt" = :dbt_3 AND "dfd" != :dfd_4;', $sql->update($query)); |
74 | - $this->assertEquals([ ':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ':dbt_3' => 'ggf', ':dfd_4' => 'yxn', ], $query->getParams()); |
|
74 | + $this->assertEquals([':bar_0' => 'baz', ':htf_1' => 'yjd', ':vrs_2' => 'abh', ':dbt_3' => 'ggf', ':dfd_4' => 'yxn', ], $query->getParams()); |
|
75 | 75 | $query->resetCounter(); |
76 | 76 | } |
77 | 77 | |
@@ -90,14 +90,14 @@ discard block |
||
90 | 90 | $query->addCondition('foo', 'dfd', IQueryBuilder::OPERATION_NEQ, 'yxn'); |
91 | 91 | $query->addOrderBy('dfg', 'vrs', IQueryBuilder::ORDER_ASC); |
92 | 92 | $query->addGroupBy('foo', 'gds'); |
93 | - $query->setLimits(5,3); |
|
93 | + $query->setLimits(5, 3); |
|
94 | 94 | $sql = new Dialects\PostgreSQL(); |
95 | 95 | $this->assertEquals('SELECT "foo"."bar" AS "baz", "foo"."htf" AS "yjd", "dfg"."vrs" AS "abh" FROM "foo" LEFT JOIN "btr" AS "dfg" ON ("foo"."fds" = "dfg"."gda") WHERE "foo"."dbt" = :dbt_0 AND "foo"."dfd" != :dfd_1 GROUP BY "foo"."gds" ORDER BY "dfg"."vrs" ASC LIMIT 3 OFFSET 5;', $sql->select($query)); |
96 | 96 | $query->setOffset(null); |
97 | 97 | $this->assertEquals('SELECT "foo"."bar" AS "baz", "foo"."htf" AS "yjd", "dfg"."vrs" AS "abh" FROM "foo" LEFT JOIN "btr" AS "dfg" ON ("foo"."fds" = "dfg"."gda") WHERE "foo"."dbt" = :dbt_0 AND "foo"."dfd" != :dfd_1 GROUP BY "foo"."gds" ORDER BY "dfg"."vrs" ASC LIMIT 3;', $sql->select($query)); |
98 | 98 | $query->setLimit(null); |
99 | 99 | $this->assertEquals('SELECT "foo"."bar" AS "baz", "foo"."htf" AS "yjd", "dfg"."vrs" AS "abh" FROM "foo" LEFT JOIN "btr" AS "dfg" ON ("foo"."fds" = "dfg"."gda") WHERE "foo"."dbt" = :dbt_0 AND "foo"."dfd" != :dfd_1 GROUP BY "foo"."gds" ORDER BY "dfg"."vrs" ASC;', $sql->select($query)); |
100 | - $this->assertEquals([ ':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
100 | + $this->assertEquals([':dbt_0' => 'ggf', ':dfd_1' => 'yxn', ], $query->getParams()); |
|
101 | 101 | $query->resetCounter(); |
102 | 102 | } |
103 | 103 | } |
@@ -53,7 +53,7 @@ |
||
53 | 53 | [IQueryBuilder::OPERATION_LIKE, 'mno', 'LIKE', 'mno'], |
54 | 54 | [IQueryBuilder::OPERATION_NLIKE, 'pqr', 'NOT LIKE', 'pqr'], |
55 | 55 | [IQueryBuilder::OPERATION_REXP, 'stu', 'REGEX', 'stu'], |
56 | - [IQueryBuilder::OPERATION_IN, [], 'IN', '(0)'], |
|
56 | + [IQueryBuilder::OPERATION_IN, [], 'IN', '(0)'], |
|
57 | 57 | [IQueryBuilder::OPERATION_NIN, ['okm', 'ijn'], 'NOT IN', '(okm,ijn)'], |
58 | 58 | ]; |
59 | 59 | } |