shaiss / delete-test-orders-for-prestashop Goto Github PK

For Prestashop 1.25 I think the following SQL works well to re-set orders, 
stats and so-forth....

[code]
    function DeleteOrders()
    {
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "orders`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_detail`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_discount`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_history`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_message`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_message_lang`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_return`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_return_detail`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_slip`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "order_slip_detail`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "message`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "cart`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "cart_discount`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "cart_product`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "connections`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "connections_page`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "connections_source`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "date_range`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "guest`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "pagenotfound`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "product_sale`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "statssearch`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "ups_cache`");
        Db::getInstance()->ExecuteS("TRUNCATE `" . _DB_PREFIX_ . "usps_cache`");
        Db::getInstance()->ExecuteS("UPDATE `" . _DB_PREFIX_ . "usps_cache` SET counter=0");
        Db::getInstance()->ExecuteS("UPDATE `" . _DB_PREFIX_ . "configuration` SET value=1 
WHERE name='PS_DELIVERY_NUMBER'");
        Db::getInstance()->ExecuteS("UPDATE `" . _DB_PREFIX_ . "configuration` SET value=1 
WHERE name='PS_INVOICE_NUMBER'");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "orders` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_detail` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_discount` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_history` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_message` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_message_lang` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_return` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_return_detail` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_slip` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "order_slip_detail` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "message` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "cart` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "cart_discount` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "cart_product` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "connections` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "connections_page` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "connections_source` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "date_range` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "guest` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "pagenotfount` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "product_sale` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "statssearch` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "ups_cache` 
AUTO_INCREMENT=1");
        Db::getInstance()->ExecuteS("ALTER TABLE `" . _DB_PREFIX_ . "usps_cache` 
AUTO_INCREMENT=1");

        return true;

    }
[/code]

The offline credit card module has its own tables.
Add an "if table exists, then TRUNCATE" line

Lines 140-155 should use _DB_PREFIX_ not ps_ hardcoded.