Lines
97.27%
214 / 220
Methods
93.93%
31 / 33
Classes
0.00%
0 / 1
| Name | Lines | Methods | CRAP | ||||
|---|---|---|---|---|---|---|---|
| readEntity | 100.00% | 26 / 26 | 100.00% | 1 / 1 | 6 | ||
| isSlotDeleteRunning | 85.71% | 6 / 7 | 0.00% | 0 / 1 | 4.05 | ||
| getTotalActiveSessions | 100.00% | 5 / 5 | 100.00% | 1 / 1 | 1 | ||
| getActiveSessionsByBehoerdenWithScopes | 100.00% | 20 / 20 | 100.00% | 1 / 1 | 3 | ||
| getConfigProblems | 100.00% | 6 / 6 | 100.00% | 1 / 1 | 3 | ||
| readDdldUpdateStats | 100.00% | 4 / 4 | 100.00% | 1 / 1 | 1 | ||
| readOutdatedSlots | 100.00% | 5 / 5 | 100.00% | 1 / 1 | 1 | ||
| readFreeSlots | 100.00% | 4 / 4 | 100.00% | 1 / 1 | 1 | ||
| readLastCalculateSlots | 100.00% | 4 / 4 | 100.00% | 1 / 1 | 1 | ||
| readMailStats | 100.00% | 5 / 5 | 100.00% | 1 / 1 | 1 | ||
| readProcessStats | 100.00% | 10 / 10 | 100.00% | 1 / 1 | 1 | ||
| readConfirmedWithMultipleServices | 100.00% | 5 / 5 | 100.00% | 1 / 1 | 1 | ||
| readConfigVariables | 100.00% | 1 / 1 | 100.00% | 1 / 1 | 1 | ||
| readStatusVariables | 100.00% | 1 / 1 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] __construct | 100.00% | 2 / 2 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] init | 100.00% | 2 / 2 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] getWriter | 100.00% | 4 / 4 | 100.00% | 1 / 1 | 2 | ||
| [BO\Zmsbackend\Base] getReader | 100.00% | 5 / 5 | 100.00% | 1 / 1 | 3 | ||
| [BO\Zmsbackend\Base] fetchPreparedStatement | 100.00% | 9 / 9 | 100.00% | 1 / 1 | 3 | ||
| [BO\Zmsbackend\Base] startExecute | 100.00% | 5 / 5 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] pdoExceptionHandler | 100.00% | 13 / 13 | 100.00% | 1 / 1 | 4 | ||
| [BO\Zmsbackend\Base] fetchStatement | 100.00% | 3 / 3 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] fetchOne | 100.00% | 7 / 7 | 100.00% | 1 / 1 | 2 | ||
| [BO\Zmsbackend\Base] fetchRow | 100.00% | 7 / 7 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] fetchValue | 100.00% | 7 / 7 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] fetchAll | 100.00% | 7 / 7 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] fetchHandle | 100.00% | 5 / 5 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] fetchList | 100.00% | 8 / 8 | 100.00% | 1 / 1 | 2 | ||
| [BO\Zmsbackend\Base] writeItem | 100.00% | 7 / 7 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] deleteItem | 100.00% | 1 / 1 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] perform | 100.00% | 7 / 7 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] fetchAffected | 100.00% | 8 / 8 | 100.00% | 1 / 1 | 1 | ||
| [BO\Zmsbackend\Base] readResolvedReferences | n/a | 0 / 0 | n/a | 0 / 0 | 1 | ||
| [BO\Zmsbackend\Base] hashStringValue | 50.00% | 5 / 10 | 0.00% | 0 / 1 | 8.12 | ||
| 7 | class Status extends \BO\Zmsbackend\Base | |
| 8 | { | |
| 9 | /** | |
| 10 | * Fetch status from db | |
| 11 | * | |
| 12 | * @return \BO\Zmsentities\Status | |
| 13 | */ | |
| 14 | public function readEntity(\DateTimeImmutable $now, bool $includeProcessStats = true) | |
| 15 | { | |
| 16 | $entity = new Entity(); | |
| 17 | $configVariables = $this->readConfigVariables(); | |
| 18 | $statusVariables = $this->readStatusVariables(); | |
| 19 | $nodeConnections = round($statusVariables['Threads_connected'] / $configVariables['max_connections'], 2); | |
| 20 | ||
| 21 | $entity['database']['problems'] = $this->getConfigProblems($configVariables); | |
| 22 | $entity['database']['locks'] = $statusVariables['Innodb_row_lock_current_waits']; | |
| 23 | $entity['database']['threads'] = $statusVariables['Threads_connected']; | |
| 24 | $entity['database']['nodeConnections'] = $nodeConnections; | |
| 25 | $entity['database']['clusterStatus'] = | |
| 26 | array_key_exists('wsrep_ready', $statusVariables) ? $statusVariables['wsrep_ready'] : 'OFF'; | |
| 27 | $entity['database']['logbin'] = | |
| 28 | array_key_exists('log_bin', $configVariables) ? $configVariables['log_bin'] : 'OFF'; | |
| 29 | $entity['processes'] = $includeProcessStats ? $this->readProcessStats($now) : []; | |
| 30 | ||
| 31 | if ($includeProcessStats && ! $this->isSlotDeleteRunning($now)) { | |
| 32 | $entity['processes'] = $this->readProcessStats($now); | |
| 33 | $outdated = $this->readOutdatedSlots(); | |
| 34 | $entity['processes']['outdated'] = $outdated['cnt']; | |
| 35 | $entity['processes']['outdatedOldest'] = $outdated['oldest']; | |
| 36 | $freeSlots = $this->readFreeSlots(); | |
| 37 | $entity['processes']['freeSlots'] = $freeSlots['cnt']; | |
| 38 | } | |
| 39 | ||
| 40 | $entity['mail'] = $this->readMailStats(); | |
| 41 | $entity['sources']['dldb']['last'] = $this->readDdldUpdateStats(); | |
| 42 | $entity['processes']['lastCalculate'] = $this->readLastCalculateSlots(); | |
| 43 | $entity['useraccounts']['activeSessions'] = $this->getTotalActiveSessions(); | |
| 44 | $entity['useraccounts']['departments'] = $this->getActiveSessionsByBehoerdenWithScopes(); | |
| 45 | ||
| 46 | return $entity; | |
| 47 | } | |
| 48 | ||
| 49 | /** | |
| 50 | * Set only by calculateSlots --delete. Newer than the last finished run, and less than 15 minutes old. | |
| 51 | * | |
| 52 | * @return bool | |
| 53 | */ | |
| 54 | protected function isSlotDeleteRunning(\DateTimeImmutable $now): bool | |
| 55 | { | |
| 56 | $config = new \BO\Zmsbackend\Config\Service\Config(); | |
| 57 | $started = $config->readProperty('status__calculateSlotsWithDeleteStart'); | |
| 58 | $finished = $config->readProperty('status__calculateSlotsLastRun'); | |
| 59 | $startedAt = is_string($started) ? strtotime($started) : false; | |
| 60 | if ($startedAt === false) { | |
| 61 | return false; | |
| 62 | } | |
| 63 | ||
| 64 | return $started > $finished && ($startedAt + (15 * 60)) > $now->getTimestamp(); | |
| 65 | } | |
| 66 | ||
| 67 | /** | |
| 68 | * Get total active sessions where SessionID is not null or empty and sessionExpiry is in the future | |
| 69 | * | |
| 70 | * @return int | |
| 71 | */ | |
| 72 | protected function getTotalActiveSessions() | |
| 73 | { | |
| 74 | $result = $this->getReader()->fetchOne( | |
| 75 | 'SELECT COUNT(n.SessionID) as totalActiveSessions | |
| 76 | FROM nutzer n | |
| 77 | WHERE n.SessionID IS NOT NULL | |
| 78 | AND n.SessionID != "" | |
| 79 | AND n.sessionExpiry > UNIX_TIMESTAMP()' | |
| 80 | ); | |
| 81 | ||
| 82 | return (int) $result['totalActiveSessions']; | |
| 83 | } | |
| 84 | ||
| 85 | /** | |
| 86 | * Get active sessions grouped by BehoerdenID with scopes, excluding expired sessions | |
| 87 | * | |
| 88 | * @return array | |
| 89 | */ | |
| 90 | protected function getActiveSessionsByBehoerdenWithScopes() | |
| 91 | { | |
| 92 | $result = $this->getReader()->fetchAll( | |
| 93 | 'SELECT b.BehoerdenID, b.Name as BehoerdeName, | |
| 94 | s.StandortID, s.Bezeichnung as StandortName, | |
| 95 | COALESCE(SUM(CASE | |
| 96 | WHEN n.sessionExpiry > UNIX_TIMESTAMP() | |
| 97 | THEN 1 ELSE 0 END), 0) as activeSessions | |
| 98 | FROM behoerde b | |
| 99 | LEFT JOIN standort s ON b.BehoerdenID = s.BehoerdenID | |
| 100 | LEFT JOIN nutzer n ON s.StandortID = n.StandortID | |
| 101 | GROUP BY b.BehoerdenID, b.Name, s.StandortID, s.Bezeichnung' | |
| 102 | ); | |
| 103 | ||
| 104 | $activeSessionsByBehoerden = []; | |
| 105 | ||
| 106 | foreach ($result as $row) { | |
| 107 | $behoerdenID = $row['BehoerdenID']; | |
| 108 | $standortID = $row['StandortID']; | |
| 109 | ||
| 110 | if (!isset($activeSessionsByBehoerden[$behoerdenID])) { | |
| 111 | $activeSessionsByBehoerden[$behoerdenID] = [ | |
| 112 | 'activeSessions' => 0, | |
| 113 | 'name' => $row['BehoerdeName'], | |
| 114 | 'scopes' => [] | |
| 115 | ]; | |
| 116 | } | |
| 117 | ||
| 118 | $activeSessionsByBehoerden[$behoerdenID]['scopes'][$standortID] = [ | |
| 119 | 'activeSessions' => (int) $row['activeSessions'], | |
| 120 | 'name' => $row['StandortName'] | |
| 121 | ]; | |
| 122 | ||
| 123 | $activeSessionsByBehoerden[$behoerdenID]['activeSessions'] += (int) $row['activeSessions']; | |
| 124 | } | |
| 125 | ||
| 126 | return $activeSessionsByBehoerden; | |
| 127 | } | |
| 128 | ||
| 129 | /** | |
| 130 | * Get the configuration problems | |
| 131 | * | |
| 132 | * @return string | |
| 133 | */ | |
| 134 | public function getConfigProblems(array $configVariables) | |
| 135 | { | |
| 136 | $problems = []; | |
| 137 | if ($configVariables['tmp_table_size'] < 32000000) { | |
| 138 | $problems[] = 'tmp_table_size should be at least 32MB'; | |
| 139 | } | |
| 140 | if ($configVariables['max_heap_table_size'] < 32000000) { | |
| 141 | $problems[] = 'max_heap_table_size should be at least 32MB'; | |
| 142 | } | |
| 143 | return implode('; ', $problems); | |
| 144 | } | |
| 145 | ||
| 146 | /** | |
| 147 | * Get the dldb update status | |
| 148 | * | |
| 149 | * @return array | |
| 150 | */ | |
| 151 | protected function readDdldUpdateStats() | |
| 152 | { | |
| 153 | $stats = $this->getReader()->fetchOne( | |
| 154 | 'SELECT value FROM config WHERE name = "sources_dldb_last"' | |
| 155 | ); | |
| 156 | return $stats['value']; | |
| 157 | } | |
| 158 | ||
| 159 | /** | |
| 160 | * Get outdated slots | |
| 161 | * | |
| 162 | * @return array | |
| 163 | */ | |
| 164 | protected function readOutdatedSlots() | |
| 165 | { | |
| 166 | $stats = $this->getReader()->fetchOne( | |
| 167 | 'SELECT COUNT(*) cnt, MIN(a.updated_at) oldest | |
| 168 | FROM slot s | |
| 169 | LEFT JOIN oeffnungszeit a ON s.availabilityID = a.OeffnungszeitID | |
| 170 | WHERE s.updateTimestamp < a.updated_at AND s.status = "free"' | |
| 171 | ); | |
| 172 | return $stats; | |
| 173 | } | |
| 174 | ||
| 175 | /** | |
| 176 | * Get free slots count | |
| 177 | * | |
| 178 | * @return array | |
| 179 | */ | |
| 180 | protected function readFreeSlots() | |
| 181 | { | |
| 182 | $stats = $this->getReader()->fetchOne( | |
| 183 | 'SELECT SUM(intern) cnt FROM slot s WHERE s.status = "free"' | |
| 184 | ); | |
| 185 | return $stats; | |
| 186 | } | |
| 187 | ||
| 188 | /** | |
| 189 | * Get last calculate slots information | |
| 190 | * | |
| 191 | * @return array | |
| 192 | */ | |
| 193 | protected function readLastCalculateSlots() | |
| 194 | { | |
| 195 | $stats = $this->getReader()->fetchOne( | |
| 196 | 'SELECT value FROM config WHERE name = "status__calculateSlotsLastRun"' | |
| 197 | ); | |
| 198 | return $stats['value']; | |
| 199 | } | |
| 200 | ||
| 201 | /** | |
| 202 | * Get mail stats | |
| 203 | * | |
| 204 | * @return array | |
| 205 | */ | |
| 206 | protected function readMailStats() | |
| 207 | { | |
| 208 | $stats = $this->getReader()->fetchOne( | |
| 209 | 'SELECT COUNT(id) as queueCount, UNIX_TIMESTAMP() - MIN(createTimestamp) as oldestSeconds, | |
| 210 | UNIX_TIMESTAMP() - MAX(createTimestamp) as newestSeconds | |
| 211 | FROM mailqueue' | |
| 212 | ); | |
| 213 | return $stats; | |
| 214 | } | |
| 215 | ||
| 216 | /** | |
| 217 | * Get process statistics | |
| 218 | * | |
| 219 | * @return array | |
| 220 | */ | |
| 221 | protected function readProcessStats(\DateTimeImmutable $now) | |
| 222 | { | |
| 223 | $midnight = $now->modify('00:00:00')->getTimestamp(); | |
| 224 | $last7days = $now->modify('-7 days 00:00:00')->getTimestamp(); | |
| 225 | ||
| 226 | $processStats = $this->getReader()->fetchOne( | |
| 227 | 'SELECT | |
| 228 | COALESCE(SUM(CASE WHEN b.status = "blocked" THEN 1 ELSE 0 END), 0) AS blocked, | |
| 229 | COALESCE(SUM(CASE WHEN b.status = "called" THEN 1 ELSE 0 END), 0) AS called, | |
| 230 | COALESCE(SUM(CASE WHEN b.status = "confirmed" THEN 1 ELSE 0 END), 0) AS confirmed, | |
| 231 | COALESCE(SUM(CASE WHEN b.status = "pending" THEN 1 ELSE 0 END), 0) AS pending, | |
| 232 | COALESCE(SUM(CASE WHEN b.status = "deleted" THEN 1 ELSE 0 END), 0) AS deleted, | |
| 233 | COALESCE(SUM(CASE WHEN b.status = "missed" THEN 1 ELSE 0 END), 0) AS missed, | |
| 234 | COALESCE(SUM(CASE WHEN b.status = "parked" THEN 1 ELSE 0 END), 0) AS parked, | |
| 235 | COALESCE(SUM(CASE WHEN b.status = "reserved" THEN 1 ELSE 0 END), 0) AS reserved, | |
| 236 | COALESCE(SUM( | |
| 237 | CASE | |
| 238 | WHEN b.external_user_id IS NOT NULL AND b.external_user_id != "" | |
| 239 | THEN 1 ELSE 0 | |
| 240 | END | |
| 241 | ), 0) AS withExternalUserId, | |
| 242 | COALESCE(SUM( | |
| 243 | CASE | |
| 244 | WHEN b.status = "confirmed" | |
| 245 | AND b.external_user_id IS NOT NULL | |
| 246 | AND b.external_user_id != "" | |
| 247 | THEN 1 ELSE 0 | |
| 248 | END | |
| 249 | ), 0) AS confirmedWithExternalUserId, | |
| 250 | global.sinceMidnight, | |
| 251 | global.last7days, | |
| 252 | global.lastInsert | |
| 253 | FROM buerger AS b | |
| 254 | CROSS JOIN ( | |
| 255 | SELECT | |
| 256 | COALESCE(SUM( | |
| 257 | CASE | |
| 258 | WHEN IPTimeStamp > ' . intval($midnight) . ' | |
| 259 | AND StandortID != 0 | |
| 260 | AND vorlaeufigeBuchung = 0 | |
| 261 | AND Abholer = 0 | |
| 262 | THEN 1 ELSE 0 | |
| 263 | END | |
| 264 | ), 0) AS sinceMidnight, | |
| 265 | COALESCE(SUM( | |
| 266 | CASE | |
| 267 | WHEN IPTimeStamp > ' . intval($last7days) . ' | |
| 268 | AND StandortID != 0 | |
| 269 | AND vorlaeufigeBuchung = 0 | |
| 270 | AND Abholer = 0 | |
| 271 | THEN 1 ELSE 0 | |
| 272 | END | |
| 273 | ), 0) AS last7days, | |
| 274 | FROM_UNIXTIME(MAX(IPTimeStamp)) AS lastInsert | |
| 275 | FROM buerger | |
| 276 | WHERE istFolgeterminvon IS NULL OR istFolgeterminvon = 0 | |
| 277 | ) AS global | |
| 278 | WHERE b.istFolgeterminvon IS NULL OR b.istFolgeterminvon = 0' | |
| 279 | ); | |
| 280 | $processStats['confirmedWithMultipleServices'] = $this->readConfirmedWithMultipleServices(); | |
| 281 | return $processStats; | |
| 282 | } | |
| 283 | ||
| 284 | /** | |
| 285 | * Confirmed appointments whose requests list more than one distinct service. | |
| 286 | * Starts from buerger.status (indexed) and looks up buergeranliegen by BuergerID, | |
| 287 | * so the cost follows current confirmed bookings rather than the full request history. | |
| 288 | */ | |
| 289 | protected function readConfirmedWithMultipleServices(): int | |
| 290 | { | |
| 291 | $row = $this->getReader()->fetchOne( | |
| 292 | 'SELECT COUNT(*) AS confirmedWithMultipleServices | |
| 293 | FROM ( | |
| 294 | SELECT ba.BuergerID | |
| 295 | FROM buerger b | |
| 296 | INNER JOIN buergeranliegen ba ON ba.BuergerID = b.BuergerID | |
| 297 | WHERE b.status = "confirmed" | |
| 298 | AND (b.istFolgeterminvon IS NULL OR b.istFolgeterminvon = 0) | |
| 299 | AND ba.AnliegenID > 0 | |
| 300 | GROUP BY ba.BuergerID | |
| 301 | HAVING COUNT(DISTINCT ba.AnliegenID) > 1 | |
| 302 | ) AS multi' | |
| 303 | ); | |
| 304 | ||
| 305 | return (int) ($row['confirmedWithMultipleServices'] ?? 0); | |
| 306 | } | |
| 307 | ||
| 308 | /** | |
| 309 | * Fetch MySQL config variables | |
| 310 | * | |
| 311 | * @return array | |
| 312 | */ | |
| 313 | protected function readConfigVariables() | |
| 314 | { | |
| 315 | return $this->getReader()->fetchPairs('SHOW VARIABLES'); | |
| 316 | } | |
| 317 | ||
| 318 | /** | |
| 319 | * Fetch MySQL status variables | |
| 320 | * | |
| 321 | * @return array | |
| 322 | */ | |
| 323 | protected function readStatusVariables() | |
| 324 | { | |
| 325 | return $this->getReader()->fetchPairs('SHOW STATUS'); | |
| 326 | } | |
| 327 | } |
Inherited from BO\Zmsbackend\Base
| 38 | public function __construct(?Connection\Pdo $writeConnection = null, ?Connection\Pdo $readConnection = null) | |
| 39 | { | |
| 40 | $this->writeDb = $writeConnection; | |
| 41 | $this->readDb = $readConnection; | |
| 42 | } |
| 44 | public static function init(?Connection\Pdo $writeConnection = null, ?Connection\Pdo $readConnection = null): static | |
| 45 | { | |
| 46 | $instance = new static($writeConnection, $readConnection); | |
| 47 | return $instance; | |
| 48 | } |
| 50 | public function getWriter(): Connection\Pdo | |
| 51 | { | |
| 52 | if (null === $this->writeDb) { | |
| 53 | $this->writeDb = Connection\Select::getWriteConnection(); | |
| 54 | $this->readDb = $this->writeDb; | |
| 55 | } | |
| 56 | return $this->writeDb; | |
| 57 | } |
| 59 | public function getReader(): Connection\Pdo | |
| 60 | { | |
| 61 | if (null !== $this->writeDb) { | |
| 62 | // if readDB gets a reset, still use writeDB | |
| 63 | return $this->writeDb; | |
| 64 | } | |
| 65 | if (null === $this->readDb) { | |
| 66 | $this->readDb = Connection\Select::getReadConnection(); | |
| 67 | } | |
| 68 | return $this->readDb; | |
| 69 | } |
| 71 | public function fetchPreparedStatement(Query\Base|string $query) | |
| 72 | { | |
| 73 | $sql = "$query"; | |
| 74 | $reader = $this->getReader(); | |
| 75 | if (spl_object_hash($reader) != static::$preparedConnectionId) { | |
| 76 | // do not use prepared statements on a different connection | |
| 77 | static::$preparedCache = []; | |
| 78 | static::$preparedConnectionId = spl_object_hash($reader); | |
| 79 | } | |
| 80 | if (!isset(static::$preparedCache[$sql])) { | |
| 81 | $prepared = $this->getReader()->prepare($sql); | |
| 82 | static::$preparedCache[$sql] = $prepared; | |
| 83 | } | |
| 84 | return static::$preparedCache[$sql]; | |
| 85 | } |
| 87 | public function startExecute(\PDOStatement $statement, array $parameters) | |
| 88 | { | |
| 89 | $statement = static::pdoExceptionHandler(function () use ($statement, $parameters) { | |
| 90 | $statement->execute($parameters); | |
| 91 | return $statement; | |
| 92 | }); | |
| 93 | return $statement; | |
| 94 | } |
| 96 | protected static function pdoExceptionHandler(\Closure $pdoFunction, array $parameters = []) | |
| 97 | { | |
| 98 | try { | |
| 99 | $statement = $pdoFunction($parameters); | |
| 100 | } catch (\PDOException $pdoException) { | |
| 101 | if (stripos($pdoException->getMessage(), 'Lock wait timeout') !== false) { | |
| 102 | throw new \BO\Zmsbackend\Exception\Pdo\LockTimeout(); | |
| 103 | } | |
| 104 | //@codeCoverageIgnoreStart | |
| 105 | if (stripos($pdoException->getMessage(), 'Deadlock found') !== false) { | |
| 106 | throw new \BO\Zmsbackend\Exception\Pdo\DeadLockFound(); | |
| 107 | } | |
| 108 | //@codeCoverageIgnoreEnd | |
| 109 | $message = "SQL: " | |
| 110 | . " Err: " | |
| 111 | . $pdoException->getMessage() | |
| 112 | //. " || Statement: " | |
| 113 | //.$statement->queryString | |
| 114 | //." || Parameters=". var_export($parameters, true) | |
| 115 | ; | |
| 116 | throw new \BO\Zmsbackend\Exception\Pdo\PDOFailed($message, 0, $pdoException); | |
| 117 | } | |
| 118 | return $statement; | |
| 119 | } |
| 121 | public function fetchStatement(Query\Base $query) | |
| 122 | { | |
| 123 | $parameters = $query->getParameters(); | |
| 124 | $statement = $this->startExecute($this->fetchPreparedStatement($query), $parameters); | |
| 125 | return $statement; | |
| 126 | } |
| 133 | public function fetchOne(Query\Base $query, \BO\Zmsentities\Schema\Entity $entity) | |
| 134 | { | |
| 135 | $statement = $this->fetchStatement($query); | |
| 136 | $data = $statement->fetch(\PDO::FETCH_ASSOC); | |
| 137 | if ($data) { | |
| 138 | $entity->exchangeArray($query->postProcessJoins($data)); | |
| 139 | $entity->setResolveLevel($query->getResolveLevel()); | |
| 140 | } | |
| 141 | $statement->closeCursor(); | |
| 142 | return $entity; | |
| 143 | } |
| 145 | public function fetchRow(Query\Base|string $query, array|null $parameters = null) | |
| 146 | { | |
| 147 | return static::pdoExceptionHandler(function () use ($query, $parameters) { | |
| 148 | $prepared = $this->fetchPreparedStatement($query); | |
| 149 | $prepared->execute($parameters); | |
| 150 | $row = $prepared->fetch(\PDO::FETCH_ASSOC); | |
| 151 | $prepared->closeCursor(); | |
| 152 | return $row; | |
| 153 | }); | |
| 154 | } |
| 156 | public function fetchValue(Query\Base|string $query, array|null $parameters = null) | |
| 157 | { | |
| 158 | return static::pdoExceptionHandler(function () use ($query, $parameters) { | |
| 159 | $prepared = $this->fetchPreparedStatement($query); | |
| 160 | $prepared->execute($parameters); | |
| 161 | $value = $prepared->fetchColumn(); | |
| 162 | $prepared->closeCursor(); | |
| 163 | return $value; | |
| 164 | }); | |
| 165 | } |
| 167 | public function fetchAll(Query\Base|string $query, array|null $parameters = null) | |
| 168 | { | |
| 169 | return static::pdoExceptionHandler(function () use ($query, $parameters) { | |
| 170 | $prepared = $this->fetchPreparedStatement($query); | |
| 171 | $prepared->execute($parameters); | |
| 172 | $list = $prepared->fetchAll(\PDO::FETCH_ASSOC); | |
| 173 | $prepared->closeCursor(); | |
| 174 | return $list; | |
| 175 | }); | |
| 176 | } |
| 178 | public function fetchHandle(Query\Base|string $query, array|null $parameters = null) | |
| 179 | { | |
| 180 | return static::pdoExceptionHandler(function () use ($query, $parameters) { | |
| 181 | $prepared = $this->fetchPreparedStatement($query); | |
| 182 | $prepared->execute($parameters); | |
| 183 | return $prepared; | |
| 184 | }); | |
| 185 | } |
| 187 | public function fetchList(Query\Base $query, \BO\Zmsentities\Schema\Entity $entity, array|\ArrayAccess $resultList = []) | |
| 188 | { | |
| 189 | $statement = $this->fetchStatement($query); | |
| 190 | while ($data = $statement->fetch(\PDO::FETCH_ASSOC)) { | |
| 191 | $dataEntity = clone $entity; | |
| 192 | $dataEntity->exchangeArray($query->postProcessJoins($data)); | |
| 193 | $dataEntity->setResolveLevel($query->getResolveLevel()); | |
| 194 | $resultList[] = $dataEntity; | |
| 195 | } | |
| 196 | $statement->closeCursor(); | |
| 197 | return $resultList; | |
| 198 | } |
| 206 | public function writeItem(Query\Base $query) | |
| 207 | { | |
| 208 | return static::pdoExceptionHandler(function () use ($query) { | |
| 209 | $this->getWriter(); //Switch to writer for write/delete | |
| 210 | $statement = $this->fetchPreparedStatement($query); | |
| 211 | $status = $statement->execute($query->getParameters()); | |
| 212 | $statement->closeCursor(); | |
| 213 | return $status; | |
| 214 | }); | |
| 215 | } |
| 221 | public function deleteItem(Query\Base $query) | |
| 222 | { | |
| 223 | return $this->writeItem($query); | |
| 224 | } |
| 226 | public function perform(string $sql, array|null $parameters = null) | |
| 227 | { | |
| 228 | return static::pdoExceptionHandler(function () use ($sql, $parameters) { | |
| 229 | $this->getWriter(); //Switch to writer for perform | |
| 230 | $prepared = $this->fetchPreparedStatement($sql); | |
| 231 | $status = $prepared->execute($parameters); | |
| 232 | $prepared->closeCursor(); | |
| 233 | return $status; | |
| 234 | }); | |
| 235 | } |
| 237 | public function fetchAffected(string $sql, array|null $parameters = null) | |
| 238 | { | |
| 239 | return static::pdoExceptionHandler(function () use ($sql, $parameters) { | |
| 240 | $this->getWriter(); //Switch to writer for perform | |
| 241 | $prepared = $this->fetchPreparedStatement($sql); | |
| 242 | $prepared->execute($parameters); | |
| 243 | $count = $prepared->rowCount(); | |
| 244 | $prepared->closeCursor(); | |
| 245 | return $count; | |
| 246 | }); | |
| 247 | } |
| 256 | public function readResolvedReferences(\BO\Zmsentities\Schema\Entity $entity, int $resolveReferences) | |
| 257 | { | |
| 258 | return $entity; | |
| 259 | } |
| 268 | public function hashStringValue(string $value, ?callable $callable = null): string | |
| 269 | { | |
| 270 | if ($callable === null) { | |
| 271 | $callable = 'sha1'; | |
| 272 | } | |
| 273 | ||
| 274 | if (is_callable($callable)) { | |
| 275 | $hash = $callable($value); | |
| 276 | ||
| 277 | if (is_string($callable)) { | |
| 278 | return $callable . ':' . $hash; | |
| 279 | } | |
| 280 | if ($callable instanceof \Closure) { | |
| 281 | return 'closure:' . $hash; | |
| 282 | } | |
| 283 | // else | |
| 284 | return 'custom:' . $hash; | |
| 285 | } | |
| 286 | ||
| 287 | throw new \InvalidArgumentException('hashStringValue() should be called with a callable as second parameter.'); | |
| 288 | } |