nilportugues /
cache
| @@ 115-137 (lines=23) @@ | ||
| 112 | * |
|
| 113 | * @return array |
|
| 114 | */ |
|
| 115 | protected function getFromDatabase($key) |
|
| 116 | { |
|
| 117 | try { |
|
| 118 | $stmt = $this->connection->prepare( |
|
| 119 | \sprintf( |
|
| 120 | 'SELECT id, %s, %s FROM %s WHERE %s = %s', |
|
| 121 | self::TABLE_CACHE_VALUE, |
|
| 122 | self::TABLE_CACHE_TTL, |
|
| 123 | $this->cacheTableName, |
|
| 124 | self::TABLE_CACHE_ID, |
|
| 125 | self::QUERY_ID_PLACEHOLDER |
|
| 126 | ) |
|
| 127 | ); |
|
| 128 | ||
| 129 | $stmt->bindParam(self::QUERY_ID_PLACEHOLDER, $key, PDO::PARAM_STR); |
|
| 130 | $stmt->execute(); |
|
| 131 | ||
| 132 | $result = $stmt->fetch(PDO::FETCH_ASSOC); |
|
| 133 | return (\is_bool($result)) ? [] : $result; |
|
| 134 | } catch (PDOException $e) { |
|
| 135 | return []; |
|
| 136 | } |
|
| 137 | } |
|
| 138 | } |
|
| 139 | ||
| @@ 158-180 (lines=23) @@ | ||
| 155 | * |
|
| 156 | * @return array |
|
| 157 | */ |
|
| 158 | protected function getFromDatabase($key) |
|
| 159 | { |
|
| 160 | try { |
|
| 161 | $stmt = $this->connection->prepare( |
|
| 162 | \sprintf( |
|
| 163 | 'SELECT %s, %s FROM %s WHERE %s = %s', |
|
| 164 | self::TABLE_CACHE_VALUE, |
|
| 165 | self::TABLE_CACHE_TTL, |
|
| 166 | $this->cacheTableName, |
|
| 167 | self::TABLE_CACHE_ID, |
|
| 168 | self::QUERY_ID_PLACEHOLDER |
|
| 169 | ) |
|
| 170 | ); |
|
| 171 | ||
| 172 | $stmt->bindParam(self::QUERY_ID_PLACEHOLDER, $key, PDO::PARAM_STR); |
|
| 173 | $stmt->execute(); |
|
| 174 | ||
| 175 | $result = $stmt->fetch(PDO::FETCH_ASSOC); |
|
| 176 | return (\is_bool($result)) ? [] : $result; |
|
| 177 | } catch (PDOException $e) { |
|
| 178 | return []; |
|
| 179 | } |
|
| 180 | } |
|
| 181 | ||
| 182 | /** |
|
| 183 | * Delete a value identified by $key. |
|
