$row = $this->find($id)->current();
$carHistory = new Automobili_Model_CarHistory();
$carHistory->insert($row->toArray());
is shorter then yours
$row = $this->find($id)->current();
$historyTable = new My_Model_CarHistory();
$historyRow = $historyTable->createRow($row->toArray());
$historyRow->save();
$historyTable = new My_Model_CarHistory();
$historyRow = $historyTable->createRow($row->toArray());
$historyRow->save();
and maybe faster, isn't it?
What is the advantage of your approach?
Thanks for the response!
Regards,
Saša Stamenković
Regards,
Saša Stamenković
On Mon, Nov 30, 2009 at 9:05 PM, Ralph Schindler-2 [via Zend Framework Community] <[hidden email]> wrote:
Hi,
Perhaps something like this-
$row = $this->find($id)->current();
$historyTable = new My_Model_CarHistory();
$historyRow = $historyTable->createRow($row->toArray());
$historyRow->save();
This assumes that you want the primary keys to be the same. Otherwise
you might have to do this:
$data = $row->toArray();
unset($data['id');
before inserting it into the createRow() method, to ensure that it gets
it's own database provided primary key.
Hope that helps,
Ralph
umpirsky wrote:
> Hi.
>
> I tried (in my class which extends Zend_Db_Table_Abstract):
>
> $row = $this->find($id)->current();
> $row->setTable(new My_Model_History());
> $row->save();
>
> My_Model_History and current class have same mysql structure, identical
> tables, one is active, and other I want to use for data history.
>
> I got:
>
> Zend_Db_Table_Row_Exception: Cannot refresh row as parent is missing
> thrown in Zend\Db\Table\Row\Abstract.php on line 758
>
> It works with:
>
> $row = $this->find($id)->current();
> $history = new My_Model_CarHistory();
> $history->insert($row->toArray());
>
> Is there a way to do it with sth similar to 1st example, or there is maybe
> some other better option?
>
> Regards,
> Sasa Stamenkovic.
View this message in context: Re: [fw-db] Select - insert Zend_Db_Row
Sent from the Zend DB mailing list archive at Nabble.com.
