@@ -11,7 +11,7 @@ |
||
| 11 | 11 | public function __construct(Uri $connUri) |
| 12 | 12 | { |
| 13 | 13 | $this->connectionUri = $connUri; |
| 14 | - $strconn = $connUri->getScheme(). ":dbname=" . DbOci8Driver::getTnsString($connUri); |
|
| 14 | + $strconn = $connUri->getScheme().":dbname=".DbOci8Driver::getTnsString($connUri); |
|
| 15 | 15 | |
| 16 | 16 | // Create Connection |
| 17 | 17 | $this->instance = new PDO( |
@@ -53,7 +53,7 @@ discard block |
||
| 53 | 53 | $iterator = $this->dbDriver->getIterator($sql, $params); |
| 54 | 54 | |
| 55 | 55 | $cacheItem->set($iterator->toArray()); |
| 56 | - $cacheItem->expiresAfter(DateInterval::createFromDateString($this->timeToCache . " seconds")); |
|
| 56 | + $cacheItem->expiresAfter(DateInterval::createFromDateString($this->timeToCache." seconds")); |
|
| 57 | 57 | |
| 58 | 58 | $this->cacheEngine->save($cacheItem); |
| 59 | 59 | } |
@@ -78,12 +78,12 @@ discard block |
||
| 78 | 78 | |
| 79 | 79 | // Define the query key |
| 80 | 80 | if (is_array($arKey2) && count($arKey2) > 0) { |
| 81 | - $key2 = ":" . md5(json_encode($arKey2)); |
|
| 81 | + $key2 = ":".md5(json_encode($arKey2)); |
|
| 82 | 82 | } else { |
| 83 | 83 | $key2 = ""; |
| 84 | 84 | } |
| 85 | 85 | |
| 86 | - return "qry:" . $key1 . $key2; |
|
| 86 | + return "qry:".$key1.$key2; |
|
| 87 | 87 | } |
| 88 | 88 | |
| 89 | 89 | public function getScalar($sql, $array = null) |
@@ -78,8 +78,8 @@ |
||
| 78 | 78 | "/:$paramName([^\\w\\d]|$)/", |
| 79 | 79 | ], |
| 80 | 80 | [ |
| 81 | - $dbArg . '', |
|
| 82 | - $dbArg . '$1', |
|
| 81 | + $dbArg.'', |
|
| 82 | + $dbArg.'$1', |
|
| 83 | 83 | ], |
| 84 | 84 | $sql, |
| 85 | 85 | -1, |
@@ -32,12 +32,12 @@ |
||
| 32 | 32 | } |
| 33 | 33 | |
| 34 | 34 | if (stripos($sql, ' LIMIT ') === false) { |
| 35 | - $sql = $sql . " LIMIT x, y"; |
|
| 35 | + $sql = $sql." LIMIT x, y"; |
|
| 36 | 36 | } |
| 37 | 37 | |
| 38 | 38 | return preg_replace( |
| 39 | 39 | '~(\s[Ll][Ii][Mm][Ii][Tt])\s.*?,\s*.*~', |
| 40 | - '$1 ' . $start .', ' .$qty, |
|
| 40 | + '$1 '.$start.', '.$qty, |
|
| 41 | 41 | $sql |
| 42 | 42 | ); |
| 43 | 43 | } |
@@ -9,7 +9,7 @@ discard block |
||
| 9 | 9 | |
| 10 | 10 | public function concat($str1, $str2 = null) |
| 11 | 11 | { |
| 12 | - return "concat(" . implode(func_get_args(), ', ') . ")"; |
|
| 12 | + return "concat(".implode(func_get_args(), ', ').")"; |
|
| 13 | 13 | } |
| 14 | 14 | |
| 15 | 15 | /** |
@@ -26,12 +26,12 @@ discard block |
||
| 26 | 26 | } |
| 27 | 27 | |
| 28 | 28 | if (stripos($sql, ' LIMIT ') === false) { |
| 29 | - $sql = $sql . " LIMIT x, y"; |
|
| 29 | + $sql = $sql." LIMIT x, y"; |
|
| 30 | 30 | } |
| 31 | 31 | |
| 32 | 32 | return preg_replace( |
| 33 | 33 | '~(\s[Ll][Ii][Mm][Ii][Tt])\s.*?,\s*.*~', |
| 34 | - '$1 ' . $start .', ' .$qty, |
|
| 34 | + '$1 '.$start.', '.$qty, |
|
| 35 | 35 | $sql |
| 36 | 36 | ); |
| 37 | 37 | } |
@@ -65,8 +65,7 @@ |
||
| 65 | 65 | |
| 66 | 66 | /** |
| 67 | 67 | * Format date column in sql string given an input format that understands Y M D |
| 68 | - |
|
| 69 | -* |
|
| 68 | + * |
|
| 70 | 69 | *@param string $format |
| 71 | 70 | * @param bool|string $column |
| 72 | 71 | * @return string |
@@ -40,7 +40,7 @@ |
||
| 40 | 40 | |
| 41 | 41 | return preg_replace( |
| 42 | 42 | '~(\s[Tt][Oo][Pp])\s.*?\d+\s~', |
| 43 | - '$1 ' . $qty . ' ', |
|
| 43 | + '$1 '.$qty.' ', |
|
| 44 | 44 | $sql |
| 45 | 45 | ); |
| 46 | 46 | } |
@@ -26,12 +26,12 @@ |
||
| 26 | 26 | } |
| 27 | 27 | |
| 28 | 28 | if (stripos($sql, ' LIMIT ') === false) { |
| 29 | - $sql = $sql . " LIMIT x OFFSET y"; |
|
| 29 | + $sql = $sql." LIMIT x OFFSET y"; |
|
| 30 | 30 | } |
| 31 | 31 | |
| 32 | 32 | return preg_replace( |
| 33 | 33 | '~(\s[Ll][Ii][Mm][Ii][Tt])\s.*?\s([Oo][Ff][Ff][Ss][Ee][Tt])\s.*~', |
| 34 | - '$1 ' . $qty .' $2 ' .$start, |
|
| 34 | + '$1 '.$qty.' $2 '.$start, |
|
| 35 | 35 | $sql |
| 36 | 36 | ); |
| 37 | 37 | } |
@@ -129,7 +129,7 @@ |
||
| 129 | 129 | return; |
| 130 | 130 | } |
| 131 | 131 | |
| 132 | - $sql = "INSERT INTO Dogs (Breed, Name, Age) VALUES ('Cat', 'Doris', 7); " . |
|
| 132 | + $sql = "INSERT INTO Dogs (Breed, Name, Age) VALUES ('Cat', 'Doris', 7); ". |
|
| 133 | 133 | "INSERT INTO Dogs (Breed, Name, Age) VALUES ('Dog', 'Lolla', 1); "; |
| 134 | 134 | |
| 135 | 135 | $idInserted = $this->dbDriver->executeAndGetId($sql); |
@@ -13,7 +13,6 @@ discard block |
||
| 13 | 13 | * Anydataset files have extension ".anydata.xml" and have many classes to put and get data into anydataset xml file. |
| 14 | 14 | * Anydataset class just read and write files. To search elements you need use AnyIterator |
| 15 | 15 | * and IteratorFilter. Each row have a class Row. |
| 16 | - |
|
| 17 | 16 | * XML Structure |
| 18 | 17 | * <code> |
| 19 | 18 | * <anydataset> |
@@ -28,17 +27,14 @@ discard block |
||
| 28 | 27 | * </row> |
| 29 | 28 | * </anydataset> |
| 30 | 29 | * </code> |
| 31 | - |
|
| 32 | 30 | * How to use: |
| 33 | 31 | * <code> |
| 34 | 32 | * $any = new AnyDataset(); |
| 35 | 33 | * </code> |
| 36 | - |
|
| 37 | 34 | * |
| 38 | 35 | *@see Row |
| 39 | 36 | * @see AnyIterator |
| 40 | 37 | * @see IteratorFilter |
| 41 | - |
|
| 42 | 38 | */ |
| 43 | 39 | class AnyDataset |
| 44 | 40 | { |
@@ -105,7 +105,7 @@ discard block |
||
| 105 | 105 | foreach ($fields as $field) { |
| 106 | 106 | $attr = $field->attributes->getNamedItem("name"); |
| 107 | 107 | if (is_null($attr)) { |
| 108 | - throw new \InvalidArgumentException('Malformed anydataset file ' . basename($filepath)); |
|
| 108 | + throw new \InvalidArgumentException('Malformed anydataset file '.basename($filepath)); |
|
| 109 | 109 | } |
| 110 | 110 | |
| 111 | 111 | $sr->addField($attr->nodeValue, $field->nodeValue); |
@@ -326,7 +326,7 @@ discard block |
||
| 326 | 326 | $left = $right = array(); |
| 327 | 327 | |
| 328 | 328 | $cntSeq = count($seq); |
| 329 | - for ($i = 1; $i < $cntSeq; $i ++) { |
|
| 329 | + for ($i = 1; $i < $cntSeq; $i++) { |
|
| 330 | 330 | if ($seq[$i]->get($field) <= $key->get($field)) { |
| 331 | 331 | $left[] = $seq[$i]; |
| 332 | 332 | } else { |
@@ -336,7 +336,7 @@ discard block |
||
| 336 | 336 | |
| 337 | 337 | return array_merge( |
| 338 | 338 | $this->quickSortExec($left, $field), |
| 339 | - [ $key ], |
|
| 339 | + [$key], |
|
| 340 | 340 | $this->quickSortExec($right, $field) |
| 341 | 341 | ); |
| 342 | 342 | } |