/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
$sql = "UPDATE `s_articles` SET `laststock` = '0' WHERE `id` =?";
Shopware()->Db()->query($sql, array(self::ARTICLE_ID));
Shopware()->Api()->Import()->sDeleteArticle(array("ordernumber" => self::ORDER_NUMBER));
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
// delete price group
$sql = "\n UPDATE s_articles SET pricegroupActive = 0 WHERE id = 2;\n DELETE FROM s_core_pricegroups_discounts WHERE `customergroupID` = 1 AND `discount` = 5;\n ";
Shopware()->Db()->query($sql);
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
//set Category "Tees und Zubehör" to inactive so the childs should not be displayed
$sql = "UPDATE `s_categories` SET `active` = '1' WHERE `id` = 11";
Shopware()->Db()->exec($sql);
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
// Restore old main detail
if (!empty($this->changedDetails)) {
$this->_restoreOldMainDetails();
}
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
// // Restore old main detail
$sql = "UPDATE `s_articles_details` SET `kind` = '2' WHERE `ordernumber` = 'SW10002.1'";
Shopware()->Db()->query($sql);
$sql = "UPDATE `s_articles_details` SET `kind` = '1' WHERE `ordernumber` = 'SW10002.3'";
Shopware()->Db()->query($sql);
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
// Restore old descriptions
$sql = "";
$values = array();
foreach ($this->backup as $key => $fields) {
$sql .= "UPDATE s_articles SET `description_long` = ?, `description` = ? WHERE `id` = {$key};";
$values[] = $fields['description_long'];
$values[] = $fields['description'];
}
Shopware()->Db()->query($sql, $values);
}
/**
* Cleaning up testData
*/
public function tearDown()
{
parent::tearDown();
$sql = "UPDATE `s_blog` SET `active` = '1' WHERE `id` =3;";
Shopware()->Db()->exec($sql, array());
}
/**
* Cleaning up testData
*/
protected function tearDown()
{
parent::tearDown();
$sql = "\n DELETE FROM `s_order_basket` WHERE `sessionID` = :firstSession;\n DELETE FROM `s_order_basket` WHERE `sessionID` = :secondSession;\n ";
Shopware()->Db()->query($sql, array("firstSession" => self::FIRST_DUMMY_SESSION_ID, "secondSession" => self::SECOND_DUMMY_SESSION_ID));
}
/**
* Cleaning up testData
*/
public function tearDown()
{
parent::tearDown();
$sql = "UPDATE `s_blog` SET `active` = '1' WHERE `id` =3;";
Shopware()->Db()->exec($sql, array());
//activate blog category
$sql = "UPDATE `s_categories` SET `active` = '1' WHERE `id` =17";
Shopware()->Db()->exec($sql, array());
}
/**
* tear down the demo data
*/
protected function tearDown()
{
parent::tearDown();
$sql = "DELETE FROM s_emarketing_partner where idcode = 'test123'";
Shopware()->Db()->query($sql);
}
