Magento last insert id in middle of transaction

Question

I am using transactions in Magento. I need to use primeryKey of first insert query to all my subsequent queries.


    $model1->setfield1()
           ->setField2();
    $transaction->addObject($model1);
    $connection    = Mage::getSingleton('core/resource')->getConnection('core_read');
    $lastInsertId  = $connection->fetchOne('SELECT last_insert_id()'); // return 0
    $model2->setfield3($lastInsertId )
    $model3->setfield4($lastInsertId )
    $transaction->addObject($model2);
    $transaction->addObject($model3);

    $transaction-Save();
    $lastInsertId2  = $connection->fetchOne('SELECT last_insert_id()'); // returns correct result

how to get last inserted id before saving the transaction

score 2 · Answer 1 · answered Sep 03 '11 at 11:21

2

Tyy this: $lastInsertId = $connection->lastInsertId();

answered Sep 03 '11 at 11:21

Sudhir Bastakoti

99,167
15
158
162

Hi Sudhir, Calling it before saving the transaction returns 0, just like my code was returning, calling it after saving the transactin return correct result. – sushantsahay Sep 04 '11 at 17:55

score 2 · Accepted Answer · answered Sep 05 '11 at 23:08

2

I guess PDO (which magento uses) can't get last_inserted_id while transaction isn't commited yet. I guess you should either try plain sql like there or try use nested transactions.

answered Sep 05 '11 at 23:08

Dmytro Zavalkin

5,265
1
30
34

How can I use nested transactions in Magento? – sushantsahay Sep 07 '11 at 04:27

score 0 · Answer 3 · answered Mar 15 '13 at 05:01

Not sure about the case with transactions, but I usually do it like this:

$data = $this->getRequest()->getPost();
$list = Mage::getModel('myextension/list')->setData($data);
$list->setUserId($userId)
    ->setCreatedTime(now());

try
{
 $list->save();
}
catch(Exception $e)
{
 Mage::getSingleton('core/session')->addError($e->getMessage());
 return $this->_redirect('*/*/');
}

$last_insert_id = $list->getId();

score 0 · Answer 4 · answered Jul 19 '16 at 10:55

Magento transaction does not change data in the DB until you call save() method:

$transaction->addObject($model1);
...
$transaction->save();

addObject() just adds new object to the transaction's registry (\Mage_Core_Model_Resource_Transaction::$_objects). $model1->save() method will be called on $transaction->save(). No INSERT operation is performed before $transaction->save() call.

Magento last insert id in middle of transaction

4 Answers4