1
|
|
|
<?php |
2
|
|
|
/* |
3
|
|
|
* This file is part of the PommProject/PommBundle package. |
4
|
|
|
* |
5
|
|
|
* (c) 2018 Grégoire HUBERT <[email protected]> |
6
|
|
|
* |
7
|
|
|
* For the full copyright and license information, please view the LICENSE |
8
|
|
|
* file that was distributed with this source code. |
9
|
|
|
*/ |
10
|
|
|
namespace PommProject\PommBundle\Controller; |
11
|
|
|
|
12
|
|
|
use Symfony\Component\HttpFoundation\Request; |
13
|
|
|
use Symfony\Component\HttpFoundation\Response; |
14
|
|
|
use Symfony\Component\Routing\Generator\UrlGeneratorInterface; |
15
|
|
|
use Symfony\Component\HttpKernel\Profiler\Profiler; |
16
|
|
|
use Symfony\Component\HttpKernel\Exception\NotFoundHttpException; |
17
|
|
|
|
18
|
|
|
use PommProject\Foundation\Pomm; |
19
|
|
|
|
20
|
|
|
/** |
21
|
|
|
* Controllers for the Pomm profiler extension. |
22
|
|
|
* |
23
|
|
|
* @package PommBundle |
24
|
|
|
* @copyright 2018 Grégoire HUBERT |
25
|
|
|
* @author Grégoire HUBERT |
26
|
|
|
* @license X11 {@link http://opensource.org/licenses/mit-license.php} |
27
|
|
|
*/ |
28
|
|
|
class PommProfilerController |
29
|
|
|
{ |
30
|
|
|
private $generator; |
31
|
|
|
private $profiler; |
32
|
|
|
private $twig; |
33
|
|
|
private $pomm; |
34
|
|
|
|
35
|
|
|
public function __construct( |
36
|
|
|
UrlGeneratorInterface $generator, |
37
|
|
|
Profiler $profiler, |
38
|
|
|
\Twig_Environment $twig, |
39
|
|
|
Pomm $pomm |
40
|
|
|
) { |
41
|
|
|
$this->generator = $generator; |
42
|
|
|
$this->profiler = $profiler; |
43
|
|
|
$this->twig = $twig; |
44
|
|
|
$this->pomm = $pomm; |
45
|
|
|
} |
46
|
|
|
|
47
|
|
|
/** |
48
|
|
|
* Controller to explain a SQL query. |
49
|
|
|
* |
50
|
|
|
* @param $request |
51
|
|
|
* @param string $token |
52
|
|
|
* @param int $index_query |
53
|
|
|
* |
54
|
|
|
* @return Response |
55
|
|
|
*/ |
56
|
|
|
public function explainAction(Request $request, $token, $index_query) |
57
|
|
|
{ |
58
|
|
|
$panel = 'pomm'; |
59
|
|
|
$page = 'home'; |
60
|
|
|
|
61
|
|
|
if (!($profile = $this->profiler->loadProfile($token))) { |
62
|
|
|
return new Response( |
63
|
|
|
$this->twig->render( |
64
|
|
|
'@WebProfiler/Profiler/info.html.twig', |
65
|
|
|
array('about' => 'no_token', 'token' => $token) |
66
|
|
|
), |
67
|
|
|
200, |
68
|
|
|
array('Content-Type' => 'text/html') |
69
|
|
|
); |
70
|
|
|
} |
71
|
|
|
|
72
|
|
|
$this->profiler->disable(); |
73
|
|
|
|
74
|
|
|
if (!$profile->hasCollector($panel)) { |
75
|
|
|
throw new NotFoundHttpException(sprintf('Panel "%s" is not available for token "%s".', $panel, $token)); |
76
|
|
|
} |
77
|
|
|
|
78
|
|
|
if (!array_key_exists($index_query, $profile->getCollector($panel)->getQueries())) { |
|
|
|
|
79
|
|
|
throw new \InvalidArgumentException(sprintf("No such query index '%s'.", $index_query)); |
80
|
|
|
} |
81
|
|
|
|
82
|
|
|
$query_data = $profile->getCollector($panel)->getQueries()[$index_query]; |
|
|
|
|
83
|
|
|
|
84
|
|
|
$explain = $this->pomm[$query_data['session_stamp']] |
85
|
|
|
->getClientUsingPooler('query_manager', null) |
86
|
|
|
->query(sprintf("explain %s", $query_data['sql']), $query_data['parameters']); |
87
|
|
|
|
88
|
|
|
return new Response($this->twig->render('@Pomm/Profiler/explain.html.twig', array( |
89
|
|
|
'token' => $token, |
90
|
|
|
'profile' => $profile, |
91
|
|
|
'collector' => $profile->getCollector($panel), |
92
|
|
|
'panel' => $panel, |
93
|
|
|
'page' => $page, |
94
|
|
|
'request' => $request, |
95
|
|
|
'query_index' => $index_query, |
96
|
|
|
'explain' => $explain, |
97
|
|
|
)), 200, array('Content-Type' => 'text/html')); |
98
|
|
|
} |
99
|
|
|
} |
100
|
|
|
|
Let’s take a look at an example:
In the above example, the authenticate() method works fine as long as you just pass instances of MyUser. However, if you now also want to pass a different implementation of User which does not have a getDisplayName() method, the code will break.
Available Fixes
Change the type-hint for the parameter:
Add an additional type-check:
Add the method to the interface: