Subversion Repositories oidplus

Rev

Rev 1316 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
635 daniel-mar 1 
<?php
2 
 
3 
/*
4 
 * OIDplus 2.0
1086 daniel-mar 5 
 * Copyright 2019 - 2023 Daniel Marschall, ViaThinkSoft
635 daniel-mar 6 
 *
7 
 * Licensed under the Apache License, Version 2.0 (the "License");
8 
 * you may not use this file except in compliance with the License.
9 
 * You may obtain a copy of the License at
10 
 *
11 
 *     http://www.apache.org/licenses/LICENSE-2.0
12 
 *
13 
 * Unless required by applicable law or agreed to in writing, software
14 
 * distributed under the License is distributed on an "AS IS" BASIS,
15 
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16 
 * See the License for the specific language governing permissions and
17 
 * limitations under the License.
18 
 */
19 
 
1050 daniel-mar 20 
namespace ViaThinkSoft\OIDplus;
635 daniel-mar 21 
 
1086 daniel-mar 22 
// phpcs:disable PSR1.Files.SideEffects
23 
\defined('INSIDE_OIDPLUS') or die;
24 
// phpcs:enable PSR1.Files.SideEffects
25 
 
635 daniel-mar 26 
class OIDplusQueryResultPDO extends OIDplusQueryResult {
1130 daniel-mar 27 
        /**
28 
         * @var bool
29 
         */
635 daniel-mar 30 
        protected $no_resultset;
1130 daniel-mar 31 
 
32 
        /**
33 
         * @var mixed
34 
         */
635 daniel-mar 35 
        protected $res;
36 
 
1116 daniel-mar 37 
        /**
1130 daniel-mar 38 
         * @param mixed $res
1116 daniel-mar 39 
         */
635 daniel-mar 40 
        public function __construct($res) {
41 
                $this->no_resultset = is_bool($res);
42 
 
43 
                if (!$this->no_resultset) {
44 
                        $this->res = $res;
1152 daniel-mar 45 
 
46 
                        // This way we can simulate MARS (Multiple Active Result Sets) so that the test case "Simultanous prepared statements" works
1236 daniel-mar 47 
                        $this->prefetchAll();
635 daniel-mar 48 
                }
49 
        }
50 
 
1116 daniel-mar 51 
        /**
52 
         *
53 
         */
635 daniel-mar 54 
        public function __destruct() {
1232 daniel-mar 55 
                if ($this->res) {
56 
                        $this->res->closeCursor();
57 
                        $this->res = null;
58 
                }
635 daniel-mar 59 
        }
60 
 
1116 daniel-mar 61 
        /**
62 
         * @return bool
63 
         */
635 daniel-mar 64 
        public function containsResultSet(): bool {
65 
                return !$this->no_resultset;
66 
        }
67 
 
1116 daniel-mar 68 
        /**
1156 daniel-mar 69 
         * @return void
70 
         */
71 
        public function prefetchAll() {
72 
                if (!is_null($this->prefetchedArray)) return;
73 
                $this->prefetchedArray = $this->res->fetchAll();
1236 daniel-mar 74 
                foreach ($this->prefetchedArray as &$row) {
75 
                        $this->fixFields($row);
76 
                }
1316 daniel-mar 77 
                unset($row);
1156 daniel-mar 78 
        }
79 
 
80 
        /**
1116 daniel-mar 81 
         * @return int
82 
         */
1152 daniel-mar 83 
        protected function do_num_rows(): int {
635 daniel-mar 84 
                $ret = $this->res->rowCount();
85 
 
86 
                // -1 can happen when PDO is connected via ODBC that is running a driver that does not support num_rows (e.g. Microsoft Access)
87 
                if ($ret === -1) {
1156 daniel-mar 88 
                        $this->prefetchAll();
1471 daniel-mar 89 
                        return count($this->prefetchedArray);
635 daniel-mar 90 
                }
91 
 
92 
                return $ret;
93 
        }
94 
 
1116 daniel-mar 95 
        /**
1156 daniel-mar 96 
         * @return array|null
1116 daniel-mar 97 
         */
1152 daniel-mar 98 
        protected function do_fetch_array()/*: ?array*/ {
1156 daniel-mar 99 
                $ret = $this->res->fetch(\PDO::FETCH_ASSOC);
100 
                if ($ret === false) $ret = null;
635 daniel-mar 101 
                return $ret;
102 
        }
103 
 
1116 daniel-mar 104 
        /**
1156 daniel-mar 105 
         * @return object|null
1116 daniel-mar 106 
         */
1152 daniel-mar 107 
        protected function do_fetch_object()/*: ?object*/ {
1156 daniel-mar 108 
                $ret = $this->res->fetch(\PDO::FETCH_OBJ);
109 
                if ($ret === false) $ret = null;
635 daniel-mar 110 
                return $ret;
111 
        }
783 daniel-mar 112 
}