save to multiple tables

Question

For the last four hours I have been trying to save data to two tables. I realise that this should be a simple task, due to Magento's style of saving data, but I cannot work out how to do it.

On a previous practice module I put together some code that worked(I must have changed something as it does not work now). The code I did write seemed to be very smelly code and this time I want to do things the right way.

I can save data to a single table, but what I am unable to work out is how to use the id from table 1 and apply that to table two as the foreign key? also does it go in a save action in the controller or is it put somewhere else?

So at this point the first table contains the value that is required in the second table? Did you try to run the save code for the second file all by itself to see if it really worked? Can you show some code for what you are trying? — Dan
– Dan, Commented Sep 25, 2013 at 16:16

Fabian Blechschmidt · Accepted Answer · 2013-09-25 18:55:17Z

4

There are multiple ways to save data to two tables at a time.

If you've registered the resource (table-backed) model in Magento's ORM you should be able to do something to the effect of:

$table1 = Mage::getModel('yourmodel/table1');
$table1->setData(array('some'=>'stuff','in'=>'here'));
$table1->save();

Wash, rinse, repeat for the second table - assuming you have a column called parent_id:

$table2 = Mage::getModel('yourmodel/table2');
$table2->setParentId($table1->getId());
$table2->setData($table1->getData());
$table2->save();

This accomplishes your goal of having a table2 related to table1 by the primary key.

Another thought is that if your RDBMS (MySQL?) has the concept of a trigger, you could set up a trigger.

edited Sep 25, 2013 at 18:55

Fabian Blechschmidt

35.4k8 gold badges76 silver badges183 bronze badges

answered Sep 25, 2013 at 17:49

philwinkle

35.8k5 gold badges92 silver badges146 bronze badges

That has worked and i've placed it in my saveAction, although after looking at the Mage_Customer_Model_Resource_Customer I wondered if it would be better to place this code in my model in a _beforeSave or _afterSave function? and make all the necessary validation checks in _before save and update table2 after save? I ask as I can imagine if it is the way to go, for me, to get it to work it will take me hours.

tony09uk
– tony09uk

2013-09-26 09:32:49 +00:00
Commented Sep 26, 2013 at 9:32

Add a comment |

Stack Exchange Network

save to multiple tables

1 Answer 1

Your Answer

Hot Network Questions

save to multiple tables

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions