1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
<?php
/**
* The oci8 extension is fairly weak and doesn't support oci_num_rows, among
* other things. We use a wrapper class to handle that and other
* Oracle-specific bits, like converting column names back to lowercase.
* @ingroup Database
*/
class ORAResult {
private $rows;
private $cursor;
private $nrows;
private $columns = [];
private function array_unique_md( $array_in ) {
$array_out = [];
$array_hashes = [];
foreach ( $array_in as $item ) {
$hash = md5( serialize( $item ) );
if ( !isset( $array_hashes[$hash] ) ) {
$array_hashes[$hash] = $hash;
$array_out[] = $item;
}
}
return $array_out;
}
/**
* @param IDatabase $db
* @param resource $stmt A valid OCI statement identifier
* @param bool $unique
*/
function __construct( &$db, $stmt, $unique = false ) {
$this->db =& $db;
$this->nrows = oci_fetch_all( $stmt, $this->rows, 0, -1, OCI_FETCHSTATEMENT_BY_ROW | OCI_NUM );
if ( $this->nrows === false ) {
$e = oci_error( $stmt );
$db->reportQueryError( $e['message'], $e['code'], '', __METHOD__ );
$this->free();
return;
}
if ( $unique ) {
$this->rows = $this->array_unique_md( $this->rows );
$this->nrows = count( $this->rows );
}
if ( $this->nrows > 0 ) {
foreach ( $this->rows[0] as $k => $v ) {
$this->columns[$k] = strtolower( oci_field_name( $stmt, $k + 1 ) );
}
}
$this->cursor = 0;
oci_free_statement( $stmt );
}
public function free() {
unset( $this->db );
}
public function seek( $row ) {
$this->cursor = min( $row, $this->nrows );
}
public function numRows() {
return $this->nrows;
}
public function numFields() {
return count( $this->columns );
}
public function fetchObject() {
if ( $this->cursor >= $this->nrows ) {
return false;
}
$row = $this->rows[$this->cursor++];
$ret = new stdClass();
foreach ( $row as $k => $v ) {
$lc = $this->columns[$k];
$ret->$lc = $v;
}
return $ret;
}
public function fetchRow() {
if ( $this->cursor >= $this->nrows ) {
return false;
}
$row = $this->rows[$this->cursor++];
$ret = [];
foreach ( $row as $k => $v ) {
$lc = $this->columns[$k];
$ret[$lc] = $v;
$ret[$k] = $v;
}
return $ret;
}
}
|
