1: <?php
  2: /**
  3:  * Magento
  4:  *
  5:  * NOTICE OF LICENSE
  6:  *
  7:  * This source file is subject to the Open Software License (OSL 3.0)
  8:  * that is bundled with this package in the file LICENSE.txt.
  9:  * It is also available through the world-wide-web at this URL:
 10:  * http://opensource.org/licenses/osl-3.0.php
 11:  * If you did not receive a copy of the license and are unable to
 12:  * obtain it through the world-wide-web, please send an email
 13:  * to license@magentocommerce.com so we can send you a copy immediately.
 14:  *
 15:  * DISCLAIMER
 16:  *
 17:  * Do not edit or add to this file if you wish to upgrade Magento to newer
 18:  * versions in the future. If you wish to customize Magento for your
 19:  * needs please refer to http://www.magentocommerce.com for more information.
 20:  *
 21:  * @category    Mage
 22:  * @package     Mage_XmlConnect
 23:  * @copyright   Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
 24:  * @license     http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 25:  */
 26: 
 27: /**
 28:  * Configuration data recourse model
 29:  *
 30:  * @category    Mage
 31:  * @package     Mage_Xmlconnect
 32:  * @author      Magento Core Team <core@magentocommerce.com>
 33:  */
 34: class Mage_XmlConnect_Model_Resource_ConfigData extends Mage_Core_Model_Mysql4_Abstract
 35: {
 36:     /**
 37:      * Initialize configuration data
 38:      *
 39:      * @return null
 40:      */
 41:     protected function _construct()
 42:     {
 43:         $this->_init('xmlconnect/configData', null);
 44:     }
 45: 
 46:     /**
 47:      * Save config value
 48:      *
 49:      * @param int $applicationId
 50:      * @param string $category
 51:      * @param string $path
 52:      * @param string $value
 53:      * @return Mage_XmlConnect_Model_Mysql4_ConfigData
 54:      */
 55:     public function saveConfig($applicationId, $category, $path, $value)
 56:     {
 57:         $newData = array(
 58:             'application_id' => $applicationId,
 59:             'category'  => $category,
 60:             'path'      => $path,
 61:             'value'     => $value
 62:         );
 63: 
 64:         $this->_getWriteAdapter()->insertOnDuplicate($this->getMainTable(), $newData, array('value'));
 65:         return $this;
 66:     }
 67: 
 68:     /**
 69:      * Delete config value
 70:      *
 71:      * @param int $applicationId
 72:      * @param bool $category
 73:      * @param bool $path
 74:      * @param bool $pathLike
 75:      * @return Mage_XmlConnect_Model_Mysql4_ConfigData
 76:      */
 77:     public function deleteConfig($applicationId, $category = false, $path = false, $pathLike = true)
 78:     {
 79:         try {
 80:             $this->_getWriteAdapter()->beginTransaction();
 81:             $writeAdapter = $this->_getWriteAdapter();
 82:             $deleteWhere[] = $writeAdapter->quoteInto('application_id=?', $applicationId);
 83:             if ($category) {
 84:                 $deleteWhere[] = $writeAdapter->quoteInto('category=?', $category);
 85:             }
 86:             if ($path) {
 87:                 $deleteWhere[] = $pathLike ? $writeAdapter->quoteInto('path like ?', $path . '/%')
 88:                     : $writeAdapter->quoteInto('path=?', $path);
 89:             }
 90:             $writeAdapter->delete($this->getMainTable(), $deleteWhere);
 91:             $this->_getWriteAdapter()->commit();
 92:         } catch (Mage_Core_Exception $e) {
 93:             $this->_getWriteAdapter()->rollBack();
 94:             throw $e;
 95:         } catch (Exception $e){
 96:             $this->_getWriteAdapter()->rollBack();
 97:             Mage::logException($e);
 98:         }
 99: 
100:         return $this;
101:     }
102: }
103: