|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
namespace App\Component\Db; |
|
4
|
|
|
|
|
5
|
|
|
use App\Component\Model\Orm\Orm; |
|
6
|
|
|
use App\Component\Db\Factory; |
|
7
|
|
|
|
|
8
|
|
|
class Core |
|
9
|
|
|
{ |
|
10
|
|
|
/** |
|
11
|
|
|
* connection |
|
12
|
|
|
* |
|
13
|
|
|
* @var \PDO |
|
14
|
|
|
*/ |
|
15
|
|
|
protected $connection; |
|
16
|
|
|
|
|
17
|
|
|
/** |
|
18
|
|
|
* logger |
|
19
|
|
|
* |
|
20
|
|
|
* @var \Monolog\Logger |
|
21
|
|
|
*/ |
|
22
|
|
|
protected $logger; |
|
23
|
|
|
|
|
24
|
|
|
/** |
|
25
|
|
|
* sql |
|
26
|
|
|
* |
|
27
|
|
|
* @var string |
|
28
|
|
|
*/ |
|
29
|
|
|
protected $sql; |
|
30
|
|
|
|
|
31
|
|
|
/** |
|
32
|
|
|
* $statement |
|
33
|
|
|
* @var \PDOStatement |
|
34
|
|
|
*/ |
|
35
|
|
|
protected $statement; |
|
36
|
|
|
|
|
37
|
|
|
/** |
|
38
|
|
|
* fetch mode |
|
39
|
|
|
* |
|
40
|
|
|
* @var int |
|
41
|
|
|
*/ |
|
42
|
|
|
protected $fetchMode = \PDO::FETCH_ASSOC; |
|
43
|
|
|
|
|
44
|
|
|
/** |
|
45
|
|
|
* database name |
|
46
|
|
|
* |
|
47
|
|
|
* @var string |
|
48
|
|
|
*/ |
|
49
|
|
|
protected $database; |
|
50
|
|
|
|
|
51
|
|
|
/** |
|
52
|
|
|
* rowset result |
|
53
|
|
|
* |
|
54
|
|
|
* @var array |
|
55
|
|
|
*/ |
|
56
|
|
|
protected $rowset; |
|
57
|
|
|
|
|
58
|
|
|
/** |
|
59
|
|
|
* set connection from Orm instance |
|
60
|
|
|
* |
|
61
|
|
|
* @param Orm $ormInstance |
|
62
|
|
|
* @return Core |
|
63
|
|
|
*/ |
|
64
|
|
|
public function fromOrm(Orm &$ormInstance): Core |
|
65
|
|
|
{ |
|
66
|
|
|
$this->database = $ormInstance->getDatabase(); |
|
67
|
|
|
$slot = $ormInstance->getSlot(); |
|
68
|
|
|
$container = $ormInstance->getContainer(); |
|
69
|
|
|
$this->logger = $container->getService(\Monolog\Logger::class); |
|
70
|
|
|
$factory = new Factory($container); |
|
71
|
|
|
$this->connection = $factory->getConnection($slot, $this->database); |
|
72
|
|
|
$this->rowset = []; |
|
73
|
|
|
return $this; |
|
74
|
|
|
} |
|
75
|
|
|
|
|
76
|
|
|
/** |
|
77
|
|
|
* run |
|
78
|
|
|
* |
|
79
|
|
|
* @param string $sql |
|
80
|
|
|
* @param array $bindParams |
|
81
|
|
|
* @return boolean |
|
82
|
|
|
*/ |
|
83
|
|
|
public function run($sql, $bindParams = [], $bindTypes = []):Core |
|
84
|
|
|
{ |
|
85
|
|
|
$this->sql = $sql; |
|
86
|
|
|
try { |
|
87
|
|
|
$this->statement = $this->connection->prepare($sql); |
|
|
|
|
|
|
88
|
|
|
$this->statement->setFetchMode($this->fetchMode); |
|
89
|
|
|
if ($bindParams) { |
|
|
|
|
|
|
90
|
|
|
$this->bindArray($this->statement, $bindParams, $bindTypes); |
|
|
|
|
|
|
91
|
|
|
} |
|
92
|
|
|
} catch (\PDOException $exc) { |
|
93
|
|
|
$this->logger->alert('Prepare failed'); |
|
94
|
|
|
$this->logger->alert($exc->getMessage()); |
|
95
|
|
|
} |
|
96
|
|
|
try { |
|
97
|
|
|
$this->statement->execute(); |
|
98
|
|
|
} catch (\PDOException $exc) { |
|
99
|
|
|
$this->logger->alert('Execute failed'); |
|
100
|
|
|
$this->logger->alert($exc->getMessage()); |
|
101
|
|
|
} |
|
102
|
|
|
return $this; |
|
103
|
|
|
} |
|
104
|
|
|
|
|
105
|
|
|
/** |
|
106
|
|
|
* hydrate |
|
107
|
|
|
* |
|
108
|
|
|
* @return Core |
|
109
|
|
|
*/ |
|
110
|
|
|
public function hydrate(): Core |
|
111
|
|
|
{ |
|
112
|
|
|
$this->rowset = $this->statement->fetchAll($this->fetchMode); |
|
113
|
|
|
$this->statement->closeCursor(); |
|
114
|
|
|
return $this; |
|
115
|
|
|
} |
|
116
|
|
|
|
|
117
|
|
|
/** |
|
118
|
|
|
* return run result |
|
119
|
|
|
* |
|
120
|
|
|
* @return array |
|
121
|
|
|
*/ |
|
122
|
|
|
public function getRowset():array |
|
123
|
|
|
{ |
|
124
|
|
|
return $this->rowset; |
|
125
|
|
|
} |
|
126
|
|
|
|
|
127
|
|
|
/** |
|
128
|
|
|
* bindArray |
|
129
|
|
|
* |
|
130
|
|
|
* @param \PDOStatement $poStatement |
|
131
|
|
|
* @param array $paArray |
|
132
|
|
|
* @param array $forcedTypes |
|
133
|
|
|
* @return $this |
|
134
|
|
|
*/ |
|
135
|
|
|
public function bindArray(\PDOStatement &$poStatement, array &$paArray, array $forcedTypes = []) |
|
136
|
|
|
{ |
|
137
|
|
|
foreach ($paArray as $k => $v) { |
|
138
|
|
|
$type = (is_int($v)) ? \PDO::PARAM_INT : \PDO::PARAM_STR; |
|
139
|
|
|
|
|
140
|
|
|
if (isset($forcedTypes[$k])) { |
|
141
|
|
|
$type = $forcedTypes[$k]; |
|
142
|
|
|
$v = ($type == \PDO::PARAM_INT) ? (int) $v : $v; |
|
143
|
|
|
} |
|
144
|
|
|
$value = is_array($v) ? serialize($v) : $v; |
|
145
|
|
|
$key = $k; |
|
146
|
|
|
try { |
|
147
|
|
|
$poStatement->bindValue($key, $value, $type); |
|
148
|
|
|
} catch (\PDOException $exc) { |
|
149
|
|
|
$this->logger->alert( |
|
150
|
|
|
'Sql Bind Error [' . $key . ':' . $value . ':' . $type . ']' |
|
151
|
|
|
); |
|
152
|
|
|
} |
|
153
|
|
|
} |
|
154
|
|
|
return $this; |
|
155
|
|
|
} |
|
156
|
|
|
} |
|
157
|
|
|
|
pierre-fromager /
nymfonya
Loading history...
Our type inference engine has found a suspicous assignment of a value to a property. This check raises an issue when a value that can be of a mixed type is assigned to a property that is type hinted more strictly.
For example, imagine you have a variable
$accountIdthat can either hold an Id object or false (if there is no account id yet). Your code now assigns that value to theidproperty of an instance of theAccountclass. This class holds a proper account, so the id value must no longer be false.Either this assignment is in error or a type check should be added for that assignment.