PageRenderTime 46ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/magmi/plugins/base/general/optimizer/magmi_optimizer_plugin.php

https://bitbucket.org/jit_bec/shopifine
PHP | 42 lines | 37 code | 4 blank | 1 comment | 0 complexity | e9ae38c4edcb6f75fd74b36e8b8a5a15 MD5 | raw file
Possible License(s): LGPL-3.0
  1. <?php
  2. class Magmi_OptimizerPlugin extends Magmi_GeneralImportPlugin
  3. {
  4. public function getPluginInfo()
  5. {
  6. return array("name"=>"Magmi Optimizer",
  7. "author"=>"Dweeves",
  8. "version"=>"1.0.5",
  9. "url"=>"http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Magmi_Optimizer");
  10. }
  11. public function beforeImport()
  12. {
  13. $tbls=array("eav_attribute_option_value"=>array("value","MAGMI_EAOV_OPTIMIZATION_IDX"),
  14. "catalog_product_entity_media_gallery"=>array("value","MAGMI_CPEM_OPTIMIZATION_IDX"),
  15. "catalog_category_entity_varchar"=>array("value","MAGMI_CCEV_OPTIMIZATION_IDX"),
  16. "eav_attribute"=>array("attribute_code","MAGMI_EA_CODE_OPTIMIZATION_IDX"));
  17. $this->log("Optimizing magmi","info");
  18. foreach($tbls as $tblname=>$idxinfo)
  19. {
  20. try
  21. {
  22. $t=$this->tablename($tblname);
  23. $this->log("Adding index {$idxinfo[1]} on $t","info");
  24. $sql="ALTER TABLE $t ADD INDEX {$idxinfo[1]} (`{$idxinfo[0]}`)";
  25. $this->exec_stmt($sql);
  26. }
  27. catch(Exception $e)
  28. {
  29. //ignore exception
  30. $this->log("Already optmized!","info");
  31. }
  32. }
  33. return true;
  34. }
  35. public function initialize($params)
  36. {
  37. }
  38. }