Skip to main content

TO Execute Multiple Raw Query In Magento 2

<?php

        /*
         *
         * TO Execute Multiple Raw Query In Magento 2
         *
         * */
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$conn = $resource->getConnection('write');
$sqlScript = file($sqlFile);
$query = '';
foreach ($sqlScript as $line) {
$startWith = substr(trim($line), 0 ,2);
$endWith = substr(trim($line), -1 ,1);
if (empty($line) || $startWith == '--' || $startWith == '/*' || $startWith == '//') continue;
$query = $query . $line;
if ($endWith == ';') {
$conn->query($query);
$query= '';
}
}
echo '<div class="success-response sql-import-response">SQL file imported successfully</div>';

Comments

Popular posts from this blog

Magento 2 Preview order email

<?php use Magento\Framework\App\Bootstrap ; require __DIR__ . '/app/bootstrap.php' ; $params = $_SERVER ; $bootstrap = Bootstrap:: create ( BP , $params ) ; $objectManager = $bootstrap -> getObjectManager () ; $state = $objectManager -> get ( 'Magento\Framework\App\State' ) ; $state -> setAreaCode (\Magento\Framework\App\Area:: AREA_GLOBAL ) ; /* $orderId = 853;// Put your Order Id Here \Magento\Store\Model\App\Emulation $appEmulation, \Magento\Email\Model\TemplateFactory $emailFactory $order = $objectManager->create('\Magento\Sales\Model\Order')->load($orderId); */ $emailFactory = $objectManager -> create ( '\Magento\Email\Model\TemplateFactory' ) ; $appEmulation = $objectManager -> create ( '\Magento\Store\Model\App\Emulation' ) ; $emailSender = $objectManager -> create ( '\Magento\Sales\Model\Order\Email\Sender\OrderSender' ) ; $paymentHelper = $objectManager -> create ( '\Magento\Payment\Helper\Data...