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
110
111
112
113
114
115
116
117
<?php
/**
* Copyright © Magento, Inc. All rights reserved.
* See COPYING.txt for license details.
*/
namespace Magento\Framework\Search\Adapter\Mysql;
use Magento\Framework\App\ResourceConnection;
use Magento\Framework\DB\Ddl\Table;
use Magento\Framework\Search\Adapter\Mysql\Aggregation\Builder as AggregationBuilder;
use Magento\Framework\Search\AdapterInterface;
use Magento\Framework\Search\RequestInterface;
/**
* MySQL Search Adapter
*
* @deprecated 102.0.0
* @see \Magento\ElasticSearch
* @SuppressWarnings(PHPMD.CouplingBetweenObjects)
*/
class Adapter implements AdapterInterface
{
/**
* Mapper instance
*
* @var Mapper
*/
protected $mapper;
/**
* Response Factory
*
* @var ResponseFactory
*/
protected $responseFactory;
/**
* @var \Magento\Framework\App\ResourceConnection
*/
private $resource;
/**
* @var AggregationBuilder
*/
private $aggregationBuilder;
/**
* @var TemporaryStorageFactory
*/
private $temporaryStorageFactory;
/**
* @param Mapper $mapper
* @param ResponseFactory $responseFactory
* @param ResourceConnection $resource
* @param AggregationBuilder $aggregationBuilder
* @param TemporaryStorageFactory $temporaryStorageFactory
*/
public function __construct(
Mapper $mapper,
ResponseFactory $responseFactory,
ResourceConnection $resource,
AggregationBuilder $aggregationBuilder,
TemporaryStorageFactory $temporaryStorageFactory
) {
$this->mapper = $mapper;
$this->responseFactory = $responseFactory;
$this->resource = $resource;
$this->aggregationBuilder = $aggregationBuilder;
$this->temporaryStorageFactory = $temporaryStorageFactory;
}
/**
* @inheritdoc
* @throws \LogicException
*/
public function query(RequestInterface $request)
{
$query = $this->mapper->buildQuery($request);
$temporaryStorage = $this->temporaryStorageFactory->create();
$table = $temporaryStorage->storeDocumentsFromSelect($query);
$documents = $this->getDocuments($table);
$aggregations = $this->aggregationBuilder->build($request, $table, $documents);
$response = [
'documents' => $documents,
'aggregations' => $aggregations,
];
return $this->responseFactory->create($response);
}
/**
* Executes query and return raw response
*
* @param Table $table
* @return array
* @throws \Zend_Db_Exception
*/
private function getDocuments(Table $table)
{
$connection = $this->getConnection();
$select = $connection->select();
$select->from($table->getName(), ['entity_id', 'score']);
return $connection->fetchAssoc($select);
}
/**
* Get connection.
*
* @return false|\Magento\Framework\DB\Adapter\AdapterInterface
*/
private function getConnection()
{
return $this->resource->getConnection();
}
}