問題描述

使用 Zend Framework，我需要 (1) 從 MySQL 數據庫讀取一條記錄，以及 (2) 立即寫回該記錄以表明它已被讀取.我不希望其他進程或查詢能夠在步驟 (1) 和 (2) 之間讀取或寫入同一條記錄.

Using Zend Framework, I need to (1) read a record from a MySQL database, and (2) immediately write back to that record to indicate that it has been read. I don't want other processes or queries to be able to read from or write to the same record in between steps (1) and (2).

我正在考慮對這些步驟使用事務.如果我使用以下方法，是否滿足我的要求?

I was considering using a transaction for these steps. If I use the following methods, will that fulfil my requirements?

Zend_Db_Adapter_Abstract::beginTransaction()
Zend_Db_Adapter_Abstract::commit()
Zend_Db_Adapter_Abstract::rollBack()

推薦答案

假設您正在使用 InnoDB 引擎，用于您將在其上發出事務的表:

Presupposing you are using the InnoDB engine for tables that you will issue transactions on:

如果要求你首先需要讀取該行并獨占鎖定它，那么在你打算更新它之前，你應該發出一個 SELECT ... FOR UPDATE 查詢.類似的東西:

If the requirement is that you first need to read the row and exclusively lock it, before you are going to update it, you should issue a SELECT ... FOR UPDATE query. Something like:

$db->beginTransaction();
try
{
    $select = $db->select()
                 ->forUpdate() // <-- here's the magic
                 ->from(
                     array( 'a' => 'yourTable' ),
                     array( 'your', 'column', 'names' )
                 )
                 ->where( 'someColumn = ?', $whatever );

    $result = $this->_adapter->fetchRow( $select );

    /*
      alter data in $result
      and update if necessary:
    */
    $db->update( 'yourTable', $result, array( 'someColumn = ?' => $whatever ) );

    $db->commit();
}
catch( Exception $e )
{
    $db->rollBack();
}

或者只是在 $db 上發出原始"SELECT ... FOR UPDATE 和 UPDATE SQL 語句.

Or simply issue 'raw' SELECT ... FOR UPDATE and UPDATE SQL statements on $db of course.

這篇關于Zend Framework 中的數據庫事務:它們是孤立的嗎?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！