/magmi/plugins/base/general/optimizer/magmi_optimizer_plugin.php
PHP | 42 lines | 37 code | 4 blank | 1 comment | 0 complexity | e9ae38c4edcb6f75fd74b36e8b8a5a15 MD5 | raw file
Possible License(s): LGPL-3.0
- <?php
- class Magmi_OptimizerPlugin extends Magmi_GeneralImportPlugin
- {
- public function getPluginInfo()
- {
- return array("name"=>"Magmi Optimizer",
- "author"=>"Dweeves",
- "version"=>"1.0.5",
- "url"=>"http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Magmi_Optimizer");
- }
-
- public function beforeImport()
- {
- $tbls=array("eav_attribute_option_value"=>array("value","MAGMI_EAOV_OPTIMIZATION_IDX"),
- "catalog_product_entity_media_gallery"=>array("value","MAGMI_CPEM_OPTIMIZATION_IDX"),
- "catalog_category_entity_varchar"=>array("value","MAGMI_CCEV_OPTIMIZATION_IDX"),
- "eav_attribute"=>array("attribute_code","MAGMI_EA_CODE_OPTIMIZATION_IDX"));
- $this->log("Optimizing magmi","info");
- foreach($tbls as $tblname=>$idxinfo)
- {
- try
- {
- $t=$this->tablename($tblname);
- $this->log("Adding index {$idxinfo[1]} on $t","info");
- $sql="ALTER TABLE $t ADD INDEX {$idxinfo[1]} (`{$idxinfo[0]}`)";
- $this->exec_stmt($sql);
- }
- catch(Exception $e)
- {
- //ignore exception
- $this->log("Already optmized!","info");
- }
- }
- return true;
- }
-
-
- public function initialize($params)
- {
-
- }
- }