@@ -160,6 +160,9 @@ |
||
160 | 160 | $this->fieldDeliRight = $right; |
161 | 161 | } |
162 | 162 | |
163 | + /** |
|
164 | + * @param string $sql |
|
165 | + */ |
|
163 | 166 | public static function createSafeSQL($sql, $list) |
164 | 167 | { |
165 | 168 | return str_replace(array_keys($list), array_values($list), $sql); |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | $campos .= ", "; |
80 | 80 | $valores .= ", "; |
81 | 81 | } |
82 | - $campos .= $this->fieldDeliLeft . $fieldname . $this->fieldDeliRight; |
|
82 | + $campos .= $this->fieldDeliLeft.$fieldname.$this->fieldDeliRight; |
|
83 | 83 | $valores .= $this->getValue($fieldname, $fieldvalue, $param, $decimalpoint); |
84 | 84 | } |
85 | 85 | $sql = "insert into $table ($campos) values ($valores)"; |
@@ -103,7 +103,7 @@ discard block |
||
103 | 103 | */ |
104 | 104 | protected function getValue($name, $valores, &$param, $decimalpoint) |
105 | 105 | { |
106 | - $paramName = "[[" . $name . "]]"; |
|
106 | + $paramName = "[[".$name."]]"; |
|
107 | 107 | if (!is_array($valores)) { |
108 | 108 | $valores = array(SQLFieldType::TEXT, $valores); |
109 | 109 | } |
@@ -151,7 +151,7 @@ discard block |
||
151 | 151 | if (strlen($sql) > 4) { |
152 | 152 | $sql .= ' and '; |
153 | 153 | } |
154 | - $sql = " $fieldName " . $relation . " " . $this->getValue($fieldName, $value, $param, '.'); |
|
154 | + $sql = " $fieldName ".$relation." ".$this->getValue($fieldName, $value, $param, '.'); |
|
155 | 155 | } |
156 | 156 | |
157 | 157 | public function setFieldDelimeters($left, $right) |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | |
95 | 95 | /** |
96 | 96 | * @param $idDocument |
97 | - * @param null $collection |
|
97 | + * @param string $collection |
|
98 | 98 | * @return \ByJG\AnyDataset\NoSqlDocument|null |
99 | 99 | */ |
100 | 100 | public function getDocumentById($idDocument, $collection = null) |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | |
113 | 113 | /** |
114 | 114 | * @param \ByJG\AnyDataset\Dataset\IteratorFilter $filter |
115 | - * @param null $collection |
|
115 | + * @param null|string $collection |
|
116 | 116 | * @return \ByJG\AnyDataset\NoSqlDocument[]|null |
117 | 117 | */ |
118 | 118 | public function getDocuments(IteratorFilter $filter, $collection = null) |
@@ -162,37 +162,37 @@ |
||
162 | 162 | } |
163 | 163 | |
164 | 164 | switch ($relation) { |
165 | - case Relation::EQUAL: |
|
166 | - $result[$name] = $value; |
|
167 | - break; |
|
165 | + case Relation::EQUAL: |
|
166 | + $result[$name] = $value; |
|
167 | + break; |
|
168 | 168 | |
169 | - case Relation::GREATER_THAN: |
|
170 | - $result[$name] = [ '$gt' => $value ]; |
|
171 | - break; |
|
169 | + case Relation::GREATER_THAN: |
|
170 | + $result[$name] = [ '$gt' => $value ]; |
|
171 | + break; |
|
172 | 172 | |
173 | - case Relation::LESS_THAN: |
|
174 | - $result[$name] = [ '$lt' => $value ]; |
|
175 | - break; |
|
173 | + case Relation::LESS_THAN: |
|
174 | + $result[$name] = [ '$lt' => $value ]; |
|
175 | + break; |
|
176 | 176 | |
177 | - case Relation::GREATER_OR_EQUAL_THAN: |
|
178 | - $result[$name] = [ '$gte' => $value ]; |
|
179 | - break; |
|
177 | + case Relation::GREATER_OR_EQUAL_THAN: |
|
178 | + $result[$name] = [ '$gte' => $value ]; |
|
179 | + break; |
|
180 | 180 | |
181 | - case Relation::LESS_OR_EQUAL_THAN: |
|
182 | - $result[$name] = [ '$lte' => $value ]; |
|
183 | - break; |
|
181 | + case Relation::LESS_OR_EQUAL_THAN: |
|
182 | + $result[$name] = [ '$lte' => $value ]; |
|
183 | + break; |
|
184 | 184 | |
185 | - case Relation::NOT_EQUAL: |
|
186 | - $result[$name] = [ '$ne' => $value ]; |
|
187 | - break; |
|
185 | + case Relation::NOT_EQUAL: |
|
186 | + $result[$name] = [ '$ne' => $value ]; |
|
187 | + break; |
|
188 | 188 | |
189 | - case Relation::STARTS_WITH: |
|
190 | - $result[$name] = [ '$regex' => "^$value" ]; |
|
191 | - break; |
|
189 | + case Relation::STARTS_WITH: |
|
190 | + $result[$name] = [ '$regex' => "^$value" ]; |
|
191 | + break; |
|
192 | 192 | |
193 | - case Relation::CONTAINS: |
|
194 | - $result[$name] = [ '$regex' => "$value" ]; |
|
195 | - break; |
|
193 | + case Relation::CONTAINS: |
|
194 | + $result[$name] = [ '$regex' => "$value" ]; |
|
195 | + break; |
|
196 | 196 | |
197 | 197 | } |
198 | 198 | } |
@@ -122,7 +122,7 @@ discard block |
||
122 | 122 | } |
123 | 123 | |
124 | 124 | $dataCursor = $this->mongoManager->executeQuery( |
125 | - $this->database . '.' . $collection, |
|
125 | + $this->database.'.'.$collection, |
|
126 | 126 | $this->getMongoFilterArray($filter) |
127 | 127 | ); |
128 | 128 | |
@@ -167,31 +167,31 @@ discard block |
||
167 | 167 | break; |
168 | 168 | |
169 | 169 | case Relation::GREATER_THAN: |
170 | - $result[$name] = [ '$gt' => $value ]; |
|
170 | + $result[$name] = ['$gt' => $value]; |
|
171 | 171 | break; |
172 | 172 | |
173 | 173 | case Relation::LESS_THAN: |
174 | - $result[$name] = [ '$lt' => $value ]; |
|
174 | + $result[$name] = ['$lt' => $value]; |
|
175 | 175 | break; |
176 | 176 | |
177 | 177 | case Relation::GREATER_OR_EQUAL_THAN: |
178 | - $result[$name] = [ '$gte' => $value ]; |
|
178 | + $result[$name] = ['$gte' => $value]; |
|
179 | 179 | break; |
180 | 180 | |
181 | 181 | case Relation::LESS_OR_EQUAL_THAN: |
182 | - $result[$name] = [ '$lte' => $value ]; |
|
182 | + $result[$name] = ['$lte' => $value]; |
|
183 | 183 | break; |
184 | 184 | |
185 | 185 | case Relation::NOT_EQUAL: |
186 | - $result[$name] = [ '$ne' => $value ]; |
|
186 | + $result[$name] = ['$ne' => $value]; |
|
187 | 187 | break; |
188 | 188 | |
189 | 189 | case Relation::STARTS_WITH: |
190 | - $result[$name] = [ '$regex' => "^$value" ]; |
|
190 | + $result[$name] = ['$regex' => "^$value"]; |
|
191 | 191 | break; |
192 | 192 | |
193 | 193 | case Relation::CONTAINS: |
194 | - $result[$name] = [ '$regex' => "$value" ]; |
|
194 | + $result[$name] = ['$regex' => "$value"]; |
|
195 | 195 | break; |
196 | 196 | |
197 | 197 | } |
@@ -219,7 +219,7 @@ discard block |
||
219 | 219 | |
220 | 220 | $bulkWrite->delete($this->getMongoFilterArray($filter)); |
221 | 221 | $this->mongoManager->executeBulkWrite( |
222 | - $this->database . '.' . $collection, |
|
222 | + $this->database.'.'.$collection, |
|
223 | 223 | $bulkWrite, |
224 | 224 | $writeConcern |
225 | 225 | ); |
@@ -241,10 +241,10 @@ discard block |
||
241 | 241 | $idDocument = isset($data['_id']) ? $data['_id'] : null; |
242 | 242 | } |
243 | 243 | |
244 | - $data['updated'] = new UTCDateTime((new \DateTime())->getTimestamp()*1000); |
|
244 | + $data['updated'] = new UTCDateTime((new \DateTime())->getTimestamp() * 1000); |
|
245 | 245 | if (empty($idDocument)) { |
246 | 246 | $data['_id'] = $idDocument = new ObjectID(); |
247 | - $data['created'] = new UTCDateTime((new \DateTime())->getTimestamp()*1000); |
|
247 | + $data['created'] = new UTCDateTime((new \DateTime())->getTimestamp() * 1000); |
|
248 | 248 | $bulkWrite->insert($data); |
249 | 249 | } else { |
250 | 250 | $data['_id'] = $idDocument; |
@@ -252,7 +252,7 @@ discard block |
||
252 | 252 | } |
253 | 253 | |
254 | 254 | $this->mongoManager->executeBulkWrite( |
255 | - $this->database . "." . $document->getCollection(), |
|
255 | + $this->database.".".$document->getCollection(), |
|
256 | 256 | $bulkWrite, |
257 | 257 | $writeConcern |
258 | 258 | ); |
@@ -100,7 +100,7 @@ |
||
100 | 100 | $documentToUpdate = new NoSqlDocument( |
101 | 101 | $document[0]->getIdDocument(), |
102 | 102 | self::TEST_COLLECTION, |
103 | - [ 'price' => 150000 ] |
|
103 | + ['price' => 150000] |
|
104 | 104 | ); |
105 | 105 | sleep(1); // Just to force a new Update DateTime |
106 | 106 | $documentSaved = $this->dbDriver->save($documentToUpdate); |
@@ -27,14 +27,14 @@ discard block |
||
27 | 27 | $connectionString, |
28 | 28 | array_merge( |
29 | 29 | [ |
30 | - "sqlrelay" => $prefix . "DbSqlRelayDriver", |
|
31 | - "oci8" => $prefix . "DbOci8Driver", |
|
32 | - "dblib" => $prefix . "PdoDblib", |
|
33 | - "mysql" => $prefix . "PdoMysql", |
|
34 | - "pgsql" => $prefix . "PdoPgsql", |
|
35 | - "oci" => $prefix . "PdoOci", |
|
36 | - "odbc" => $prefix . "PdoOdbc", |
|
37 | - "sqlite" => $prefix . "PdoSqlite", |
|
30 | + "sqlrelay" => $prefix."DbSqlRelayDriver", |
|
31 | + "oci8" => $prefix."DbOci8Driver", |
|
32 | + "dblib" => $prefix."PdoDblib", |
|
33 | + "mysql" => $prefix."PdoMysql", |
|
34 | + "pgsql" => $prefix."PdoPgsql", |
|
35 | + "oci" => $prefix."PdoOci", |
|
36 | + "odbc" => $prefix."PdoOdbc", |
|
37 | + "sqlite" => $prefix."PdoSqlite", |
|
38 | 38 | ], |
39 | 39 | (array)$schemesAlternative |
40 | 40 | ), |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | $connectionString, |
58 | 58 | array_merge( |
59 | 59 | [ |
60 | - "mongodb" => $prefix . "MongoDbDriver", |
|
60 | + "mongodb" => $prefix."MongoDbDriver", |
|
61 | 61 | ], |
62 | 62 | (array)$schemesAlternative |
63 | 63 | ), |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | $connectionString, |
76 | 76 | array_merge( |
77 | 77 | [ |
78 | - "s3" => $prefix . "AwsS3Driver", |
|
78 | + "s3" => $prefix."AwsS3Driver", |
|
79 | 79 | ], |
80 | 80 | (array)$schemesAlternative |
81 | 81 | ), |
@@ -57,8 +57,8 @@ |
||
57 | 57 | throw new DatasetException("Socket error: $errstr ($errno)"); |
58 | 58 | } |
59 | 59 | |
60 | - $out = "GET " . $this->path . " HTTP/1.1\r\n"; |
|
61 | - $out .= "Host: " . $this->server . "\r\n"; |
|
60 | + $out = "GET ".$this->path." HTTP/1.1\r\n"; |
|
61 | + $out .= "Host: ".$this->server."\r\n"; |
|
62 | 62 | $out .= "Connection: Close\r\n\r\n"; |
63 | 63 | |
64 | 64 | fwrite($handle, $out); |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | |
38 | 38 | if (!preg_match("~^https?://~", $source)) { |
39 | 39 | if (!file_exists($this->source)) { |
40 | - throw new NotFoundException("The specified file " . $this->source . " does not exists"); |
|
40 | + throw new NotFoundException("The specified file ".$this->source." does not exists"); |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | $this->sourceType = "FILE"; |
@@ -80,8 +80,8 @@ discard block |
||
80 | 80 | throw new DatasetException("TextFileDataset Socket error: $errstr ($errno)"); |
81 | 81 | } |
82 | 82 | |
83 | - $out = "GET " . $urlParts[4] . " HTTP/1.1\r\n"; |
|
84 | - $out .= "Host: " . $urlParts[2] . "\r\n"; |
|
83 | + $out = "GET ".$urlParts[4]." HTTP/1.1\r\n"; |
|
84 | + $out .= "Host: ".$urlParts[2]."\r\n"; |
|
85 | 85 | $out .= "Connection: Close\r\n\r\n"; |
86 | 86 | |
87 | 87 | fwrite($handle, $out); |
@@ -28,7 +28,7 @@ |
||
28 | 28 | } |
29 | 29 | |
30 | 30 | if (function_exists('dba_open')) { |
31 | - $cache = sys_get_temp_dir() . "/caps.db"; |
|
31 | + $cache = sys_get_temp_dir()."/caps.db"; |
|
32 | 32 | $this->connection->capabilityCache($cache); |
33 | 33 | } |
34 | 34 | } |
@@ -44,39 +44,39 @@ |
||
44 | 44 | $field = " $name "; |
45 | 45 | $valueparam = " [[" . $paramName . "]] "; |
46 | 46 | switch ($relation) { |
47 | - case Relation::EQUAL: |
|
48 | - $result = $field . "=" . $valueparam; |
|
49 | - break; |
|
50 | - |
|
51 | - case Relation::GREATER_THAN: |
|
52 | - $result = $field . ">" . $valueparam; |
|
53 | - break; |
|
54 | - |
|
55 | - case Relation::LESS_THAN: |
|
56 | - $result = $field . "<" . $valueparam; |
|
57 | - break; |
|
58 | - |
|
59 | - case Relation::GREATER_OR_EQUAL_THAN: |
|
60 | - $result = $field . ">=" . $valueparam; |
|
61 | - break; |
|
62 | - |
|
63 | - case Relation::LESS_OR_EQUAL_THAN: |
|
64 | - $result = $field . "<=" . $valueparam; |
|
65 | - break; |
|
66 | - |
|
67 | - case Relation::NOT_EQUAL: |
|
68 | - $result = $field . "!=" . $valueparam; |
|
69 | - break; |
|
70 | - |
|
71 | - case Relation::STARTS_WITH: |
|
72 | - $param[$paramName] = $value . "%"; |
|
73 | - $result = $field . " like " . $valueparam; |
|
74 | - break; |
|
75 | - |
|
76 | - case Relation::CONTAINS: |
|
77 | - $param[$paramName] = "%" . $value . "%"; |
|
78 | - $result = $field . " like " . $valueparam; |
|
79 | - break; |
|
47 | + case Relation::EQUAL: |
|
48 | + $result = $field . "=" . $valueparam; |
|
49 | + break; |
|
50 | + |
|
51 | + case Relation::GREATER_THAN: |
|
52 | + $result = $field . ">" . $valueparam; |
|
53 | + break; |
|
54 | + |
|
55 | + case Relation::LESS_THAN: |
|
56 | + $result = $field . "<" . $valueparam; |
|
57 | + break; |
|
58 | + |
|
59 | + case Relation::GREATER_OR_EQUAL_THAN: |
|
60 | + $result = $field . ">=" . $valueparam; |
|
61 | + break; |
|
62 | + |
|
63 | + case Relation::LESS_OR_EQUAL_THAN: |
|
64 | + $result = $field . "<=" . $valueparam; |
|
65 | + break; |
|
66 | + |
|
67 | + case Relation::NOT_EQUAL: |
|
68 | + $result = $field . "!=" . $valueparam; |
|
69 | + break; |
|
70 | + |
|
71 | + case Relation::STARTS_WITH: |
|
72 | + $param[$paramName] = $value . "%"; |
|
73 | + $result = $field . " like " . $valueparam; |
|
74 | + break; |
|
75 | + |
|
76 | + case Relation::CONTAINS: |
|
77 | + $param[$paramName] = "%" . $value . "%"; |
|
78 | + $result = $field . " like " . $valueparam; |
|
79 | + break; |
|
80 | 80 | |
81 | 81 | } |
82 | 82 |
@@ -35,47 +35,47 @@ |
||
35 | 35 | $paramName = $name; |
36 | 36 | $counter = 0; |
37 | 37 | while (array_key_exists($paramName, $param)) { |
38 | - $paramName = $name . ($counter++); |
|
38 | + $paramName = $name.($counter++); |
|
39 | 39 | } |
40 | 40 | |
41 | 41 | $param[$paramName] = $value; |
42 | 42 | |
43 | 43 | $result = ""; |
44 | 44 | $field = " $name "; |
45 | - $valueparam = " [[" . $paramName . "]] "; |
|
45 | + $valueparam = " [[".$paramName."]] "; |
|
46 | 46 | switch ($relation) { |
47 | 47 | case Relation::EQUAL: |
48 | - $result = $field . "=" . $valueparam; |
|
48 | + $result = $field."=".$valueparam; |
|
49 | 49 | break; |
50 | 50 | |
51 | 51 | case Relation::GREATER_THAN: |
52 | - $result = $field . ">" . $valueparam; |
|
52 | + $result = $field.">".$valueparam; |
|
53 | 53 | break; |
54 | 54 | |
55 | 55 | case Relation::LESS_THAN: |
56 | - $result = $field . "<" . $valueparam; |
|
56 | + $result = $field."<".$valueparam; |
|
57 | 57 | break; |
58 | 58 | |
59 | 59 | case Relation::GREATER_OR_EQUAL_THAN: |
60 | - $result = $field . ">=" . $valueparam; |
|
60 | + $result = $field.">=".$valueparam; |
|
61 | 61 | break; |
62 | 62 | |
63 | 63 | case Relation::LESS_OR_EQUAL_THAN: |
64 | - $result = $field . "<=" . $valueparam; |
|
64 | + $result = $field."<=".$valueparam; |
|
65 | 65 | break; |
66 | 66 | |
67 | 67 | case Relation::NOT_EQUAL: |
68 | - $result = $field . "!=" . $valueparam; |
|
68 | + $result = $field."!=".$valueparam; |
|
69 | 69 | break; |
70 | 70 | |
71 | 71 | case Relation::STARTS_WITH: |
72 | - $param[$paramName] = $value . "%"; |
|
73 | - $result = $field . " like " . $valueparam; |
|
72 | + $param[$paramName] = $value."%"; |
|
73 | + $result = $field." like ".$valueparam; |
|
74 | 74 | break; |
75 | 75 | |
76 | 76 | case Relation::CONTAINS: |
77 | - $param[$paramName] = "%" . $value . "%"; |
|
78 | - $result = $field . " like " . $valueparam; |
|
77 | + $param[$paramName] = "%".$value."%"; |
|
78 | + $result = $field." like ".$valueparam; |
|
79 | 79 | break; |
80 | 80 | |
81 | 81 | } |
@@ -40,7 +40,7 @@ |
||
40 | 40 | $this->source = $source; |
41 | 41 | |
42 | 42 | if (!file_exists($this->source)) { |
43 | - throw new NotFoundException("The specified file " . $this->source . " does not exists"); |
|
43 | + throw new NotFoundException("The specified file ".$this->source." does not exists"); |
|
44 | 44 | } |
45 | 45 | |
46 | 46 | $this->sourceType = "FILE"; |