This project does not seem to handle request data directly as such no vulnerable execution paths were found.
include
, or for example
via PHP's auto-loading mechanism.
These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more
1 | <?php |
||
2 | namespace Childish\database; |
||
3 | |||
4 | use PDO; |
||
5 | use Childish\connection\Connection; |
||
6 | use Childish\connection\ConnectionFactory; |
||
7 | use Childish\support\Tools; |
||
8 | use InvalidArgumentException; |
||
9 | |||
10 | /** |
||
11 | * DatabaseManager |
||
12 | * |
||
13 | * @author Pu ShaoWei <[email protected]> |
||
14 | * @date 2017/12/7 |
||
15 | * @version 1.0 |
||
16 | */ |
||
17 | class DatabaseManager |
||
18 | { |
||
19 | /** |
||
20 | * The database connection factory instance. |
||
21 | * |
||
22 | * @var ConnectionFactory |
||
23 | */ |
||
24 | protected $factory; |
||
25 | |||
26 | /** |
||
27 | * The active connection instances. |
||
28 | * |
||
29 | * @var array |
||
30 | */ |
||
31 | protected $connections = []; |
||
32 | |||
33 | /** |
||
34 | * The custom connection resolvers. |
||
35 | * |
||
36 | * @var array |
||
37 | */ |
||
38 | protected $extensions = []; |
||
39 | |||
40 | |||
41 | /** |
||
42 | * DatabaseManager constructor. |
||
43 | * |
||
44 | * @param $app |
||
45 | * @param ConnectionFactory $factory |
||
46 | */ |
||
47 | public function __construct($app, ConnectionFactory $factory) |
||
48 | { |
||
49 | $this->app = $app; |
||
0 ignored issues
–
show
|
|||
50 | $this->factory = $factory; |
||
51 | } |
||
52 | |||
53 | /** |
||
54 | * Get a database connection instance. |
||
55 | * |
||
56 | * @param string $name |
||
57 | * @return \Childish\connection\Connection |
||
58 | */ |
||
59 | public function connection($name = null) |
||
60 | { |
||
61 | list($database, $type) = $this->parseConnectionName($name); |
||
62 | |||
63 | $name = $name ? : $database; |
||
64 | |||
65 | // If we haven't created this connection, we'll create it based on the config |
||
66 | // provided in the application. Once we've created the connections we will |
||
67 | // set the "fetch mode" for PDO which determines the query return types. |
||
68 | if (!isset($this->connections[$name])) { |
||
69 | $this->connections[$name] = $this->configure( |
||
70 | $this->makeConnection($database), $type |
||
71 | ); |
||
72 | } |
||
73 | |||
74 | return $this->connections[$name]; |
||
75 | } |
||
76 | |||
77 | /** |
||
78 | * Parse the connection into an array of the name and read / write type. |
||
79 | * |
||
80 | * @param string $name |
||
81 | * @return array |
||
82 | */ |
||
83 | protected function parseConnectionName($name) |
||
84 | { |
||
85 | $name = $name ? : $this->getDefaultConnection(); |
||
86 | |||
87 | return Tools::endsWith($name, ['::read', '::write']) |
||
88 | ? explode('::', $name, 2) : [$name, null]; |
||
89 | } |
||
90 | |||
91 | /** |
||
92 | * Make the database connection instance. |
||
93 | * |
||
94 | * @param string $name |
||
95 | * @return \Childish\connection\Connection |
||
96 | */ |
||
97 | protected function makeConnection($name) |
||
98 | { |
||
99 | $config = $this->configuration($name); |
||
100 | |||
101 | // First we will check by the connection name to see if an extension has been |
||
102 | // registered specifically for that connection. If it has we will call the |
||
103 | // Closure and pass it the config allowing it to resolve the connection. |
||
104 | if (isset($this->extensions[$name])) { |
||
105 | return call_user_func($this->extensions[$name], $config, $name); |
||
106 | } |
||
107 | |||
108 | // Next we will check to see if an extension has been registered for a driver |
||
109 | // and will call the Closure if so, which allows us to have a more generic |
||
110 | // resolver for the drivers themselves which applies to all connections. |
||
111 | if (isset($this->extensions[$driver = $config['driver']])) { |
||
112 | return call_user_func($this->extensions[$driver], $config, $name); |
||
113 | } |
||
114 | |||
115 | return $this->factory->make($config, $name); |
||
116 | } |
||
117 | |||
118 | /** |
||
119 | * Get the configuration for a connection. |
||
120 | * |
||
121 | * @param string $name |
||
122 | * @return array |
||
123 | * @throws \InvalidArgumentException |
||
124 | */ |
||
125 | protected function configuration($name) |
||
126 | { |
||
127 | $name = $name ? : $this->getDefaultConnection(); |
||
128 | |||
129 | // To get the database connection configuration, we will just pull each of the |
||
130 | // connection configurations and get the configurations for the given name. |
||
131 | // If the configuration doesn't exist, we'll throw an exception and bail. |
||
132 | $connections = $this->app['config']['database.connections']; |
||
133 | |||
134 | if (is_null($config = Tools::get($connections, $name))) { |
||
135 | throw new InvalidArgumentException("Database [$name] not configured."); |
||
136 | } |
||
137 | |||
138 | return $config; |
||
139 | } |
||
140 | |||
141 | /** |
||
142 | * Prepare the database connection instance. |
||
143 | * |
||
144 | * @param \Childish\connection\Connection $connection |
||
145 | * @param string $type |
||
146 | * @return \Childish\connection\Connection |
||
147 | */ |
||
148 | protected function configure(Connection $connection, $type) |
||
149 | { |
||
150 | $connection = $this->setPdoForType($connection, $type); |
||
151 | |||
152 | // First we'll set the fetch mode and a few other dependencies of the database |
||
153 | // connection. This method basically just configures and prepares it to get |
||
154 | |||
155 | |||
156 | // Here we'll set a reconnector callback. This reconnector can be any callable |
||
157 | // so we will set a Closure to reconnect from this manager with the name of |
||
158 | // the connection, which will allow us to reconnect from the connections. |
||
159 | $connection->setReconnector(function ($connection) { |
||
160 | $this->reconnect($connection->getName()); |
||
161 | }); |
||
162 | |||
163 | return $connection; |
||
164 | } |
||
165 | |||
166 | /** |
||
167 | * Prepare the read / write mode for database connection instance. |
||
168 | * |
||
169 | * @param \Childish\connection\Connection $connection |
||
170 | * @param string $type |
||
171 | * @return \Childish\connection\Connection |
||
172 | */ |
||
173 | protected function setPdoForType(Connection $connection, $type = null) |
||
174 | { |
||
175 | if ($type == 'read') { |
||
176 | $connection->setPdo($connection->getReadPdo()); |
||
177 | } else if ($type == 'write') { |
||
178 | $connection->setReadPdo($connection->getPdo()); |
||
179 | } |
||
180 | |||
181 | return $connection; |
||
182 | } |
||
183 | |||
184 | /** |
||
185 | * Disconnect from the given database and remove from local cache. |
||
186 | * |
||
187 | * @param string $name |
||
188 | * @return void |
||
189 | */ |
||
190 | public function purge($name = null) |
||
191 | { |
||
192 | $name = $name ? : $this->getDefaultConnection(); |
||
193 | |||
194 | $this->disconnect($name); |
||
195 | |||
196 | unset($this->connections[$name]); |
||
197 | } |
||
198 | |||
199 | /** |
||
200 | * Disconnect from the given database. |
||
201 | * |
||
202 | * @param string $name |
||
203 | * @return void |
||
204 | */ |
||
205 | public function disconnect($name = null) |
||
206 | { |
||
207 | if (isset($this->connections[$name = $name ? : $this->getDefaultConnection()])) { |
||
208 | $this->connections[$name]->disconnect(); |
||
209 | } |
||
210 | } |
||
211 | |||
212 | /** |
||
213 | * Reconnect to the given database. |
||
214 | * |
||
215 | * @param string $name |
||
216 | * @return \Childish\connection\Connection |
||
217 | */ |
||
218 | public function reconnect($name = null) |
||
219 | { |
||
220 | $this->disconnect($name = $name ? : $this->getDefaultConnection()); |
||
221 | |||
222 | if (!isset($this->connections[$name])) { |
||
223 | return $this->connection($name); |
||
224 | } |
||
225 | |||
226 | return $this->refreshPdoConnections($name); |
||
227 | } |
||
228 | |||
229 | /** |
||
230 | * Refresh the PDO connections on a given connection. |
||
231 | * |
||
232 | * @param string $name |
||
233 | * @return \Childish\connection\Connection |
||
234 | */ |
||
235 | protected function refreshPdoConnections($name) |
||
236 | { |
||
237 | $fresh = $this->makeConnection($name); |
||
238 | |||
239 | return $this->connections[$name] |
||
240 | ->setPdo($fresh->getPdo()) |
||
241 | ->setReadPdo($fresh->getReadPdo()); |
||
242 | } |
||
243 | |||
244 | /** |
||
245 | * Get the default connection name. |
||
246 | * |
||
247 | * @return string |
||
248 | */ |
||
249 | public function getDefaultConnection() |
||
250 | { |
||
251 | return $this->app['config']['database.default']; |
||
252 | } |
||
253 | |||
254 | /** |
||
255 | * Set the default connection name. |
||
256 | * |
||
257 | * @param string $name |
||
258 | * @return void |
||
259 | */ |
||
260 | public function setDefaultConnection($name) |
||
261 | { |
||
262 | $this->app['config']['database.default'] = $name; |
||
263 | } |
||
264 | |||
265 | /** |
||
266 | * Get all of the support drivers. |
||
267 | * |
||
268 | * @return array |
||
269 | */ |
||
270 | public function supportedDrivers() |
||
271 | { |
||
272 | return ['mysql', 'pgsql', 'sqlite', 'sqlsrv']; |
||
273 | } |
||
274 | |||
275 | /** |
||
276 | * Get all of the drivers that are actually available. |
||
277 | * |
||
278 | * @return array |
||
279 | */ |
||
280 | public function availableDrivers() |
||
281 | { |
||
282 | return array_intersect( |
||
283 | $this->supportedDrivers(), |
||
284 | str_replace('dblib', 'sqlsrv', PDO::getAvailableDrivers()) |
||
285 | ); |
||
286 | } |
||
287 | |||
288 | /** |
||
289 | * Register an extension connection resolver. |
||
290 | * |
||
291 | * @param string $name |
||
292 | * @param callable $resolver |
||
293 | * @return void |
||
294 | */ |
||
295 | public function extend($name, callable $resolver) |
||
296 | { |
||
297 | $this->extensions[$name] = $resolver; |
||
298 | } |
||
299 | |||
300 | /** |
||
301 | * Return all of the created connections. |
||
302 | * |
||
303 | * @return array |
||
304 | */ |
||
305 | public function getConnections() |
||
306 | { |
||
307 | return $this->connections; |
||
308 | } |
||
309 | |||
310 | /** |
||
311 | * Dynamically pass methods to the default connection. |
||
312 | * |
||
313 | * @param string $method |
||
314 | * @param array $parameters |
||
315 | * @return mixed |
||
316 | */ |
||
317 | public function __call($method, $parameters) |
||
318 | { |
||
319 | return $this->connection()->$method(...$parameters); |
||
320 | } |
||
321 | } |
In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code:
Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: