1 | <?php |
||||||
2 | /** |
||||||
3 | * Plasma Driver MySQL component |
||||||
4 | * Copyright 2018-2019 PlasmaPHP, All Rights Reserved |
||||||
5 | * |
||||||
6 | * Website: https://github.com/PlasmaPHP |
||||||
7 | * License: https://github.com/PlasmaPHP/driver-mysql/blob/master/LICENSE |
||||||
8 | */ |
||||||
9 | |||||||
10 | namespace Plasma\Drivers\MySQL\Commands; |
||||||
11 | |||||||
12 | /** |
||||||
13 | * Abstract command which has a promise. |
||||||
14 | * @internal |
||||||
15 | */ |
||||||
16 | abstract class PromiseCommand implements CommandInterface { |
||||||
17 | use \Evenement\EventEmitterTrait; |
||||||
18 | |||||||
19 | /** |
||||||
20 | * @var \Plasma\DriverInterface |
||||||
21 | */ |
||||||
22 | protected $driver; |
||||||
23 | |||||||
24 | /** |
||||||
25 | * @var \React\Promise\Deferred |
||||||
26 | */ |
||||||
27 | protected $deferred; |
||||||
28 | |||||||
29 | /** |
||||||
30 | * @var mixed |
||||||
31 | */ |
||||||
32 | protected $resolveValue; |
||||||
33 | |||||||
34 | /** |
||||||
35 | * @var bool |
||||||
36 | */ |
||||||
37 | protected $finished = false; |
||||||
38 | |||||||
39 | /** |
||||||
40 | * @var int|null |
||||||
41 | */ |
||||||
42 | protected $fieldsCount; |
||||||
43 | |||||||
44 | /** |
||||||
45 | * Constructor. |
||||||
46 | * @param \Plasma\DriverInterface $driver |
||||||
47 | */ |
||||||
48 | 68 | function __construct(\Plasma\DriverInterface $driver) { |
|||||
49 | 68 | $this->driver = $driver; |
|||||
50 | 68 | $this->deferred = new \React\Promise\Deferred(); |
|||||
51 | |||||||
52 | $this->once('error', function (\Throwable $error) { |
||||||
53 | $this->deferred->reject($error); |
||||||
54 | 68 | }); |
|||||
55 | |||||||
56 | $this->once('end', function () { |
||||||
57 | // Let the event loop read the stream buffer before resolving |
||||||
58 | $this->driver->getLoop()->futureTick(function () { |
||||||
59 | 59 | $this->deferred->resolve($this->resolveValue); |
|||||
60 | 59 | $this->resolveValue = null; |
|||||
61 | 59 | }); |
|||||
62 | 68 | }); |
|||||
63 | 68 | } |
|||||
64 | |||||||
65 | /** |
||||||
66 | * Get the encoded message for writing to the database connection. |
||||||
67 | * @return string |
||||||
68 | */ |
||||||
69 | abstract function getEncodedMessage(): string; |
||||||
70 | |||||||
71 | /** |
||||||
72 | * Get the promise. |
||||||
73 | * @return \React\Promise\PromiseInterface |
||||||
74 | */ |
||||||
75 | 68 | function getPromise(): \React\Promise\PromiseInterface { |
|||||
76 | 68 | return $this->deferred->promise(); |
|||||
77 | } |
||||||
78 | |||||||
79 | /** |
||||||
80 | * Sets the parser state, if necessary. If not, return `-1`. |
||||||
81 | * @return int |
||||||
82 | */ |
||||||
83 | 59 | function setParserState(): int { |
|||||
84 | 59 | return -1; |
|||||
85 | } |
||||||
86 | |||||||
87 | /** |
||||||
88 | * Sets the command as completed. This state gets reported back to the user. |
||||||
89 | * @return void |
||||||
90 | */ |
||||||
91 | 59 | function onComplete(): void { |
|||||
92 | 59 | $this->finished = true; |
|||||
93 | 59 | $this->emit('end'); |
|||||
94 | 59 | } |
|||||
95 | |||||||
96 | /** |
||||||
97 | * Sets the command as errored. This state gets reported back to the user. |
||||||
98 | * @param \Throwable $throwable |
||||||
99 | * @return void |
||||||
100 | */ |
||||||
101 | function onError(\Throwable $throwable): void { |
||||||
102 | $this->finished = true; |
||||||
103 | |||||||
104 | if($this->resolveValue !== null) { |
||||||
105 | // Let the event loop read the stream buffer and resolve the promise before emitting |
||||||
106 | // Works around a race condition, where the promise resolves |
||||||
107 | // after receiving an error response packet |
||||||
108 | // and therefore the user misses the error event |
||||||
109 | $this->driver->getLoop()->futureTick(function () use (&$throwable) { |
||||||
110 | $this->emit('error', array($throwable)); |
||||||
111 | }); |
||||||
112 | |||||||
113 | return; |
||||||
114 | } |
||||||
115 | |||||||
116 | $this->emit('error', array($throwable)); |
||||||
117 | } |
||||||
118 | |||||||
119 | /** |
||||||
120 | * Sends the next received value into the command. |
||||||
121 | * @param mixed $value |
||||||
122 | * @return void |
||||||
123 | */ |
||||||
124 | abstract function onNext($value): void; |
||||||
125 | |||||||
126 | /** |
||||||
127 | * Whether the command has finished. |
||||||
128 | * @return bool |
||||||
129 | */ |
||||||
130 | 59 | function hasFinished(): bool { |
|||||
131 | 59 | return $this->finished; |
|||||
132 | } |
||||||
133 | |||||||
134 | /** |
||||||
135 | * Whether this command sets the connection as busy. |
||||||
136 | * @return bool |
||||||
137 | */ |
||||||
138 | 59 | function waitForCompletion(): bool { |
|||||
139 | 59 | return true; |
|||||
140 | } |
||||||
141 | |||||||
142 | /** |
||||||
143 | * Whether the sequence ID should be resetted. |
||||||
144 | * @return bool |
||||||
145 | */ |
||||||
146 | abstract function resetSequence(): bool; |
||||||
147 | |||||||
148 | /** |
||||||
149 | * Handles the column definitions of query commands on next caller. |
||||||
150 | * @param \Plasma\BinaryBuffer $buffer |
||||||
151 | * @param \Plasma\Drivers\MySQL\ProtocolParser $parser |
||||||
152 | * @return \Plasma\ColumnDefinitionInterface|null |
||||||
153 | */ |
||||||
154 | 47 | function handleQueryOnNextCallerColumns(\Plasma\BinaryBuffer $buffer, \Plasma\Drivers\MySQL\ProtocolParser $parser): ?\Plasma\ColumnDefinitionInterface { |
|||||
155 | 47 | if($this->fieldsCount === null) { |
|||||
156 | 46 | $fieldCount = $buffer->readIntLength(); |
|||||
157 | |||||||
158 | 46 | if($fieldCount === 0x00) { |
|||||
159 | $this->driver->getLoop()->futureTick(function () use (&$buffer, &$parser) { |
||||||
160 | $msg = new \Plasma\Drivers\MySQL\Messages\OkResponseMessage($parser); |
||||||
161 | $parser->handleMessage($buffer, $msg); |
||||||
162 | }); |
||||||
163 | |||||||
164 | return null; |
||||||
165 | 46 | } elseif($fieldCount === 0xFB) { |
|||||
166 | // Handle it on future tick, so we can cleanly finish the buffer of this call |
||||||
167 | $this->driver->getLoop()->futureTick(function () use (&$buffer, &$parser) { |
||||||
168 | $msg = new \Plasma\Drivers\MySQL\Messages\LocalInFileRequestMessage($parser); |
||||||
169 | $parser->handleMessage($buffer, $msg); |
||||||
170 | }); |
||||||
171 | |||||||
172 | return null; |
||||||
173 | 46 | } elseif($fieldCount === 0xFF) { |
|||||
174 | $this->driver->getLoop()->futureTick(function () use (&$buffer, &$parser) { |
||||||
175 | $msg = new \Plasma\Drivers\MySQL\Messages\ErrResponseMessage($parser); |
||||||
176 | $parser->handleMessage($buffer, $msg); |
||||||
177 | }); |
||||||
178 | |||||||
179 | return null; |
||||||
180 | } |
||||||
181 | |||||||
182 | 46 | $this->fieldsCount = $fieldCount; |
|||||
183 | 46 | return null; |
|||||
184 | } |
||||||
185 | |||||||
186 | 47 | return static::parseColumnDefinition($buffer); |
|||||
187 | } |
||||||
188 | |||||||
189 | /** |
||||||
190 | * Parses the column definition. |
||||||
191 | * @param \Plasma\BinaryBuffer $buffer |
||||||
192 | * @return \Plasma\ColumnDefinitionInterface |
||||||
193 | */ |
||||||
194 | 47 | static function parseColumnDefinition(\Plasma\BinaryBuffer $buffer): \Plasma\ColumnDefinitionInterface { |
|||||
195 | 47 | $buffer->readStringLength(); // catalog - always "def" |
|||||
196 | 47 | $database = $buffer->readStringLength(); |
|||||
197 | |||||||
198 | 47 | $table = $buffer->readStringLength(); |
|||||
199 | 47 | $buffer->readStringLength(); // orgTable |
|||||
200 | |||||||
201 | 47 | $name = $buffer->readStringLength(); |
|||||
202 | 47 | $buffer->readStringLength(); // orgName |
|||||
203 | |||||||
204 | 47 | $buffer->read(1); // 0x0C |
|||||
205 | |||||||
206 | 47 | $charset = $buffer->readInt2(); |
|||||
207 | 47 | $length = $buffer->readInt4(); |
|||||
208 | 47 | $type = $buffer->readInt1(); |
|||||
209 | 47 | $flags = $buffer->readInt2(); |
|||||
210 | 47 | $decimals = $buffer->readInt1(); |
|||||
211 | |||||||
212 | 47 | $buffer->read(2); // fillers |
|||||
213 | |||||||
214 | /*if($this instanceof COM_FIELD_LIST) { |
||||||
215 | $buffer->readStringLength(); |
||||||
216 | }*/ |
||||||
217 | |||||||
218 | 47 | $charset = \Plasma\Drivers\MySQL\CharacterSetFlags::CHARSET_MAP[$charset] ?? 'Unknown charset "'.$charset.'"'; |
|||||
219 | 47 | $type = \Plasma\Drivers\MySQL\FieldFlags::TYPE_MAP[$type] ?? 'Unknown type "'.$type.'"'; |
|||||
220 | |||||||
221 | 47 | return (new \Plasma\Drivers\MySQL\ColumnDefinition($database, $table, $name, $type, $charset, $length, $flags, $decimals)); |
|||||
3 ignored issues
–
show
Bug
introduced
by
![]() It seems like
$database can also be of type null ; however, parameter $database of Plasma\Drivers\MySQL\Col...finition::__construct() does only seem to accept string , maybe add an additional type check?
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
![]() It seems like
$name can also be of type null ; however, parameter $name of Plasma\Drivers\MySQL\Col...finition::__construct() does only seem to accept string , maybe add an additional type check?
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
![]() |
|||||||
222 | } |
||||||
223 | |||||||
224 | /** |
||||||
225 | * Parses the text resultset row and returns the row. |
||||||
226 | * @param \Plasma\BinaryBuffer $buffer |
||||||
227 | * @return array |
||||||
228 | */ |
||||||
229 | 10 | protected function parseResultsetRow(\Plasma\BinaryBuffer $buffer): array { |
|||||
230 | 10 | $row = array(); |
|||||
231 | |||||||
232 | /** @var \Plasma\ColumnDefinitionInterface $column */ |
||||||
233 | 10 | foreach($this->fields as $column) { |
|||||
234 | 10 | $rawValue = $buffer->readStringLength(); |
|||||
235 | |||||||
236 | try { |
||||||
237 | 10 | $value = \Plasma\Types\TypeExtensionsManager::getManager('driver-mysql') |
|||||
238 | 10 | ->decodeType($column->getType(), $rawValue) |
|||||
239 | ->getValue(); |
||||||
240 | 10 | } catch (\Plasma\Exception $e) { |
|||||
241 | 10 | $value = \Plasma\Drivers\MySQL\TextProtocolValues::decode($column, $rawValue); |
|||||
242 | } |
||||||
243 | |||||||
244 | 10 | $row[$column->getName()] = $value; |
|||||
245 | } |
||||||
246 | |||||||
247 | 10 | return $row; |
|||||
248 | } |
||||||
249 | } |
||||||
250 |