two_rules_rollback.php

Go to the documentation of this file.

<?php
$objectManager = \Magento\TestFramework\Helper\Bootstrap::getObjectManager();

$catalogRuleResource = $objectManager->create(\Magento\CatalogRule\Model\ResourceModel\Rule::class);

$ruleRepository = $objectManager->create(\Magento\CatalogRule\Api\CatalogRuleRepositoryInterface::class);

foreach (['test_rule_one', 'test_rule_two'] as $ruleName) {
    //Retrieve rule id by name
    $select = $catalogRuleResource->getConnection()->select();
    $select->from($catalogRuleResource->getMainTable(), 'rule_id');
    $select->where('name = ?', $ruleName);
    $ruleId = $catalogRuleResource->getConnection()->fetchOne($select);

    try {
        $ruleRepository->deleteById($ruleId);
    } catch (\Exception $ex) {
        //Nothing to remove
    }
}

$indexBuilder = $objectManager->get(\Magento\CatalogRule\Model\Indexer\IndexBuilder::class);
$indexBuilder->reindexFull();