/
QueryCommand.php
109 lines (97 loc) · 3.17 KB
/
QueryCommand.php
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
<?php
declare(strict_types=1);
namespace Doctrine\ODM\MongoDB\Tools\Console\Command;
use Doctrine\Common\Util\Debug;
use Symfony\Component\Console;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputOption;
use function is_numeric;
use function json_decode;
/**
* Command to query mongodb and inspect the outputted results from your document classes.
*
*/
class QueryCommand extends Console\Command\Command
{
/**
* @see Console\Command\Command
*/
protected function configure()
{
$this
->setName('odm:query')
->setDescription('Query mongodb and inspect the outputted results from your document classes.')
->setDefinition([
new InputArgument(
'class',
InputArgument::REQUIRED,
'The class to query.'
),
new InputArgument(
'query',
InputArgument::REQUIRED,
'The query to execute and output the results for.'
),
new InputOption(
'hydrate',
null,
InputOption::VALUE_NONE,
'Whether or not to hydrate the results in to document objects.'
),
new InputOption(
'skip',
null,
InputOption::VALUE_REQUIRED,
'The number of documents to skip in the cursor.'
),
new InputOption(
'limit',
null,
InputOption::VALUE_REQUIRED,
'The number of documents to return.'
),
new InputOption(
'depth',
null,
InputOption::VALUE_REQUIRED,
'Dumping depth of Document graph.',
7
),
])
->setHelp(<<<EOT
Execute a query and output the results.
EOT
);
}
/**
* @see Console\Command\Command
*/
protected function execute(Console\Input\InputInterface $input, Console\Output\OutputInterface $output)
{
$dm = $this->getHelper('documentManager')->getDocumentManager();
$qb = $dm->getRepository($input->getArgument('class'))->createQueryBuilder();
$qb->setQueryArray((array) json_decode($input->getArgument('query')));
$qb->hydrate((bool) $input->getOption('hydrate'));
$depth = $input->getOption('depth');
if (! is_numeric($depth)) {
throw new \LogicException("Option 'depth' must contain an integer value");
}
$skip = $input->getOption('skip');
if ($skip !== null) {
if (! is_numeric($skip)) {
throw new \LogicException("Option 'skip' must contain an integer value");
}
$qb->skip((int) $skip);
}
$limit = $input->getOption('limit');
if ($limit !== null) {
if (! is_numeric($limit)) {
throw new \LogicException("Option 'limit' must contain an integer value");
}
$qb->limit((int) $limit);
}
foreach ($qb->getQuery() as $result) {
Debug::dump($result, $depth);
}
}
}