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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
<?php
require_once dirname(__FILE__) . '/../idiorm.php';
/**
*
* Mock version of the PDOStatement class.
*
*/
class MockPDOStatement extends PDOStatement {
private $current_row = 0;
private $statement = NULL;
private $bindParams = array();
/**
* Store the statement that gets passed to the constructor
*/
public function __construct($statement) {
$this->statement = $statement;
}
/**
* Check that the array
*/
public function execute($params = NULL) {
$count = 0;
$m = array();
if (is_null($params)) $params = $this->bindParams;
if (preg_match_all('/"[^"\\\\]*(?:\\?)[^"\\\\]*"|\'[^\'\\\\]*(?:\\?)[^\'\\\\]*\'|(\\?)/', $this->statement, $m, PREG_SET_ORDER)) {
$count = count($m);
for ($v = 0; $v < $count; $v++) {
if (count($m[$v]) == 1) unset($m[$v]);
}
$count = count($m);
for ($i = 0; $i < $count; $i++) {
if (!isset($params[$i])) {
ob_start();
var_dump($m, $params);
$output = ob_get_clean();
throw new Exception('Incorrect parameter count. Expected ' . $count . ' got ' . count($params) . ".\n" . $this->statement . "\n" . $output);
}
}
}
}
/**
* Add data to arrays
*/
public function bindParam($index, $value, $type)
{
// Do check on index, and type
if (!is_int($index)) throw new Exception('Incorrect parameter type. Expected $index to be an integer.');
if (!is_int($type) || ($type != PDO::PARAM_STR && $type != PDO::PARAM_NULL && $type != PDO::PARAM_BOOL && $type != PDO::PARAM_INT))
throw new Exception('Incorrect parameter type. Expected $type to be an integer.');
// Add param to array
$this->bindParams[$index - 1] = $value;
}
/**
* Return some dummy data
*/
public function fetch($fetch_style=PDO::FETCH_BOTH, $cursor_orientation=PDO::FETCH_ORI_NEXT, $cursor_offset=0) {
if ($this->current_row == 5) {
return false;
} else {
return array('name' => 'Fred', 'age' => 10, 'id' => ++$this->current_row);
}
}
}
/**
* Another mock PDOStatement class, used for testing multiple connections
*/
class MockDifferentPDOStatement extends MockPDOStatement { }
/**
*
* Mock database class implementing a subset
* of the PDO API.
*
*/
class MockPDO extends PDO {
/**
* Return a dummy PDO statement
*/
public function prepare($statement, $driver_options=array()) {
$this->last_query = new MockPDOStatement($statement);
return $this->last_query;
}
}
/**
* A different mock database class, for testing multiple connections
* Mock database class implementing a subset of the PDO API.
*/
class MockDifferentPDO extends MockPDO {
/**
* Return a dummy PDO statement
*/
public function prepare($statement, $driver_options = array()) {
$this->last_query = new MockDifferentPDOStatement($statement);
return $this->last_query;
}
}
class MockMsSqlPDO extends MockPDO {
public $fake_driver = 'mssql';
/**
* If we are asking for the name of the driver, check if a fake one
* has been set.
*/
public function getAttribute($attribute) {
if ($attribute == self::ATTR_DRIVER_NAME) {
if (!is_null($this->fake_driver)) {
return $this->fake_driver;
}
}
return parent::getAttribute($attribute);
}
}
|