Ask me k'no'w querries, I will tell you no lies

Clearing Opencart V1.5.4.1 Demo data

October 16, 2012

Why can’t Opencart just have an optional sample data installation

This is the code for clearing the default database content in latest Opencart version i.e 1.5.4.1.

The reference Article


<?php 

$options = getopt('p:');
$prefix = empty($options['p']) 
		? realpath('.')
: realpath($options['p']);

if (empty($prefix)) {
	die("Bad prefix. Try again.\n");
}

require $prefix . '/admin/config.php';
require $prefix . '/system/database/' . DB_DRIVER . '.php';
require $prefix . '/system/library/db.php';

$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME,DB_PASSWORD, DB_DATABASE);
$tables = array(
	'address',
	'category',
	'category_description',
	'category_to_store',
	'coupon',
	'customer',
	'download',
	'download_description',
	'manufacturer',
	'manufacturer_to_store',
	'product',
	'product_description',
	'product_discount',
	'product_image',
	'product_option',
	'product_option_value',
	'product_related',
	'product_reward',
	'product_special',
	'product_to_category',
	'product_to_layout',
	'product_to_download',
	'product_to_store',
	'review',
	'store',
	'order',
	'order_download',
	'order_history',
	'order_option',
	'order_product',
	'order_status',
	'order_total',
	'product_to_category',
	'coupon_product',
);

foreach ($tables as $table) {
	$sql = sprintf('TRUNCATE TABLE `%s%s`', DB_PREFIX, $table);
	printf('%s %s ', $sql, str_repeat('.', 73 - strlen($sql)));
	$db->query($sql);
	echo "Done!\n";
}


Ekancepts

Ekancepts