/**
* Performs operation returned by getSetUpOperation().
*/
protected function tearDown()
{
parent::tearDown();
$filePath = $this->getLogFilePath();
if (is_file($filePath)) {
unlink($filePath);
}
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
$sql = "DELETE FROM s_articles_notification WHERE id IN (1111111111, 1111111112, 1111111113)";
Shopware()->Db()->query($sql);
}
/**
* revert the test values
*/
public function tearDown()
{
parent::tearDown();
$sql = "UPDATE `s_articles_details` SET `width` = NULL, `height` = NULL, `length` = NULL WHERE `ordernumber` = :orderNumber";
Shopware()->Db()->query($sql, array("orderNumber" => self::ARTICLE_DETAIL_ORDER_NUMBER));
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
$sql = "DELETE FROM`s_order_documents` WHERE `docID` IN (20001,20002);";
Shopware()->Db()->query($sql, array());
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
$sql = "UPDATE `s_core_customergroups` SET `taxinput` = '1' WHERE`groupkey` = 'EK'";
Shopware()->Db()->query($sql);
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
$sql = "\n DELETE FROM `s_order_documents` WHERE `orderID` = :orderID;\n ";
Shopware()->Db()->query($sql, array('orderID' => $this->orderId));
}
public function tearDown()
{
parent::tearDown();
$sql = "\r\n DELETE FROM s_core_shops WHERE id IN (10, 11);\r\n ";
Shopware()->Db()->exec($sql);
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
$sql = "\n DELETE FROM `s_order` WHERE `id` = :orderId;\n DELETE FROM `s_order_details` WHERE `orderID` = :orderId;\n ";
Shopware()->Db()->query($sql, array("orderId" => self::ORDER_ID));
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
// delete price group
$sql = "\r\n UPDATE s_articles SET pricegroupActive = 0, pricegroupID = 0 WHERE id = 202;\r\n DELETE FROM s_core_pricegroups_discounts WHERE `customergroupID` = 1 AND groupID = 1;\r\n ";
Shopware()->Db()->query($sql);
//reset the stapping prices for the main variant
$sql = "DELETE FROM`s_articles_prices` WHERE `articleID` = 202 AND articledetailsID = ?";
Shopware()->Db()->query($sql, array(self::MAIN_VARIANT_ID));
$sql = "REPLACE INTO `s_articles_prices` (`pricegroup`, `from`, `to`, `articleID`, `articledetailsID`, `price`, `pseudoprice`, `baseprice`, `percent`) VALUES\r\n ('EK', 1, 'beliebig', 202, ?, 17.638655462185, 0, 0, '0.00')";
Shopware()->Db()->query($sql, array(self::MAIN_VARIANT_ID));
//reset the stapping prices for the variant
$sql = "DELETE FROM`s_articles_prices` WHERE `articleID` = 202 AND articledetailsID = ?";
Shopware()->Db()->query($sql, array(self::VARIANT_ID));
$sql = "REPLACE INTO `s_articles_prices` (`pricegroup`, `from`, `to`, `articleID`, `articledetailsID`, `price`, `pseudoprice`, `baseprice`, `percent`) VALUES\r\n ('EK', 1, 'beliebig', 202, ?, 17.638655462185, 0, 0, '0.00')";
Shopware()->Db()->query($sql, array(self::VARIANT_ID));
}
