Sometimes, running update scripts to quickly update the database or to export
some data does not require a complete module to hold the code. For these types
of operations you can build a shell script to get into Magento’s environment without
executing a traditional browser based request. The file is basically the Magento
index.php file with one major change, instead of Mage::run(’default’) we will simply
use Mage::app(’default’). This type of file can be used to export pending orders,
update product categorization, change available quantities, or any other type of automated
maintenance.
<?php
//if you store this script outside the Web site document
// root (recommended) use chdir() to move execution back to
// the document root.
//chdir("../magento/’);
//if you are performing admin tasks, sometimes the system
// checks if you are in SSL mode. Uncomment the following
// line to get this behavior.
//$_SERVER[’SERVER_PORT’] = 443;
require_once ’app/Mage.php’;
umask(0);
Mage::app(’default’);
//add your own code below:
/*
Example code:
load a category
$category = Mage::getModel(’catalog/category’)-load(1);
get a database handle
$w = Mage::getResourceSingleton(’core/resource’)->getConnection(’core_write’);
$w->query(’select ’entity_id’ from ’catalog_product_entity’);
*/
?>
Comments
Post a Comment