magento-2-programmatically/deleteSearchQuery.php at master · magepow/magento-2-programmatically · GitHub

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
<?php

require dirname(__FILE__) . '/app/bootstrap.php';
$bootstrap = \Magento\Framework\App\Bootstrap::create(BP, $_SERVER);

class Outslide extends \Magento\Framework\App\Http
    implements \Magento\Framework\AppInterface {
    public function launch()
    {
        $myClass = $this->_objectManager->create('DeleteSearchQuery');
        $myClass->deleteSearchQuery();
        return $this->_response;
    }

}


class DeleteSearchQuery{

    protected $_objectManager;
    protected $_registry;

    /**
     * @var CustomerRepositoryInterface
     */
    protected $customerRepository;

    public function __construct(
        \Magento\Framework\Registry $registry,
        )
    {
        $this->_registry = $registry;
        $this->_objectManager = \Magento\Framework\App\ObjectManager::getInstance();
    }

    public function deleteSearchQuery() {

        $this->_registry->register("isSecureArea", true);

        $limit = 100000;
        // $limit = 10;
        $collection = $this->_objectManager->create('\Magento\Search\Model\Query');
        $searchQuery = $collection->getCollection()
                                ->addFieldToSelect("*")
                                // ->addFieldToFilter("query_text", ["like" => "%http%"])
                                // ->addFieldToFilter("query_text", ["like" => "%www%"])
                                // ->addFieldToFilter("query_text", ["like" => "%.com%"])
                                // ->addFieldToFilter("query_text", ["like" => "%.cn%"])
                                // ->addFieldToFilter("query_text", ["like" => "%btc%"])
                                // ->addFieldToFilter("query_text", ["like" => "%bitcoin%"])
                                // ->addFieldToFilter("query_text", ["like" => "%eth%"])
                                // ->addFieldToFilter("query_text", ["like" => "%ripple%"])
                                // ->addFieldToFilter("query_text", ["like" => "%solana%"])
                                // ->setOrder('query_text ', 'DESC')
                                // ->setOrder('query_text ', 'ASC')
                                ->setOrder('num_results', 'ASC')
                                ->setPageSize($limit)->setCurPage(1);

        $querysDeleted = 0;
        foreach ($searchQuery as $query) {
            echo $query->getQueryText();
            $query->delete();
            $querysDeleted++;
        }

        if ($querysDeleted) {
            echo __('A total of %1 record(s) were deleted.', $querysDeleted);
        }
    }

}

/** @var \Magento\Framework\App\Http $app */
$app = $bootstrap->createApplication('Outslide');
$bootstrap->run($app);