29 lines
1.0 KiB
PHP
Executable File
29 lines
1.0 KiB
PHP
Executable File
<?php
|
|
/**
|
|
* Copyright © Magento, Inc. All rights reserved.
|
|
* See COPYING.txt for license details.
|
|
*/
|
|
|
|
$objectManager = \Magento\TestFramework\Helper\Bootstrap::getObjectManager();
|
|
$resource = $objectManager->get(\Magento\Framework\App\ResourceConnection::class);
|
|
$connection = $resource->getConnection();
|
|
$resourceModel = $objectManager->create(\Magento\OfflineShipping\Model\ResourceModel\Carrier\Tablerate::class);
|
|
$entityTable = $resourceModel->getTable('shipping_tablerate');
|
|
$data =
|
|
[
|
|
'website_id' => 1,
|
|
'dest_country_id' => 'US',
|
|
'dest_region_id' => 0,
|
|
'dest_zip' => '*',
|
|
'condition_name' => 'package_qty',
|
|
'condition_value' => 1,
|
|
'price' => 10,
|
|
'cost' => 10
|
|
];
|
|
$connection->query(
|
|
"INSERT INTO {$entityTable} (`website_id`, `dest_country_id`, `dest_region_id`, `dest_zip`, `condition_name`,"
|
|
. "`condition_value`, `price`, `cost`) VALUES (:website_id, :dest_country_id, :dest_region_id, :dest_zip,"
|
|
. " :condition_name, :condition_value, :price, :cost);",
|
|
$data
|
|
);
|