Magento – How to save serialized value into a table in magento

magento-1.7

In my custom model I want to store the data in serialized form. For achieving it by myself I have done the following thing but instead of all this 0 is getting stored against value

In my class Inchoo_Custombuilders_Model_Mysql4_Cableconnector extends Mage_Core_Model_MySql4_Abstract file

 $this->_serializableFields = array(
        'cable_id' => array(null, array())
    );

I also tried override the _beforeSave Action

 protected function _beforeSave()
 {
    if(is_array($this->getValue())){
        var_dump($this->getValue());die();
        $this->setValue(serialize($this->getValue()));
    }
 }

And I cannot change the database table design because some functionality that is build on the frontend is running from this table only.

What is the proper way to save serialize data into database in Magento.

Best Answer

Your methods seem a little bit off. If that _beforeSave() is inside of the Inchoo_Custombuilders_Model_Mysql4_Cableconnector class, then it should have an $object parameter passed in, and you should be checking $object->getValue(), not $this->getValue().

Now, assuming that the field name on the model is value (which by the way I would try to avoid that - I think you might run into mysql reserved keyword issues), and assuming that $object->getValue() contains an array, then what you seem to be doing should basically work fine:

protected function _beforeSave($object)
{
    if ($object->getValue()) {
        $serializedValue =  serialize($object->getValue());
        $this->setValue($serializedValue);
    }
}

If it isn't, then check to see what the value of $serializedValue is to make sure that it is what you expect it to be.

This answer refers to the Enterprise_Rma module, not the CE extension the OP is using.

As far as I understand, what you are wanting to do is set the admin user value on the RMA model when an RMA is created in the backend.
You already have added the column admin_user (or whatever you have used as your attribute code) to the enterprise_rma table.

Instead of using a controller overwrite to achieve your goal, it's much more compatible and upgrade safe to use an event observer.

Unfortunately, the RMA model doesn't set it's own event prefix, so you will have to observer the generic core_abstract_save_before event, and check the object instance type in the observer method.

To do so, you first need to define it in your modules etc/config.xml file.

<global>
    <models>
        <myModul_productReturn>
            <class>MyModul_ProductReturn_Model</class>
        </myModul_productReturn>
    </models>
</global>
<adminhtml>
    <events>
        <core_abstract_save_before>
            <observers>
                <myModul_productReturn>
                    <class>myModul_productReturn/observer</class>
                    <method>coreAbstractSaveBefore</method>
                </myModul_productReturn>
            </observers>
        </core_abstract_save_before>
    </events>
</adminhtml>

Then, in the observer class:

class MyModul_ProductReturn_Model_Observer
{
    public function coreAbstractSaveBefore(Varien_Event_Observer $observer)
    {
        $model = $observer->getObject();
        if ($model instanceof Enterprise_Rma_Model_Rma) {
            /** @var Enterprise_Rma_Model_Rma $model */
            if ($model->isObjectNew()) {
                /** @var Mage_Admin_Model_User $admin */
                $admin = Mage::getSingleton('admin/session')->getUser();
                if ($admin && $admin->getId()) {
                    $model->setAdminUser($admin->getUsername());
                }
            }
        }
    }
}

Now, every time a new RMA is saved, the admin's username will be set.

Magento – Avoid invalidating product flat table reindexing upon product attribute value save

If you only want to update a single product attribute without running the indexer, use the following method. It will be possible to update a couple of hundred products per second that way.

First, add a new product attribute estimated_time_of_arrival.
The, in your update script:

$product->addAttributeUpdate(
    'estimated_time_of_arrival',
    $date,
    $storeId // numeric store id value, e.g. Mage::app()->getStore()->getId()
);

If it's a global scope attribute, the $storeId doesn't even matter.
If you don't care about the store ID scope, you can also use:

$product->setData('estimated_time_of_arrival', $date)
    ->getResource()
    ->saveAttribute($product, 'estimated_time_of_arrival');

Both methods are equivalent (the latter will use $product->getStoreId()if the attribute has a website or store view scope).

Of course, if you use that attribute in some way that requires indexing, you will have to reindex after the updates.

Best Answer

Related Solutions

How to Echo Admin Username for Current Session and Save to Database

This answer refers to the Enterprise_Rma module, not the CE extension the OP is using.

Magento – Avoid invalidating product flat table reindexing upon product attribute value save

Related Topic