捕获“INSERT”的异常关于重复密钥更新” ZF 中的解决方法

发布于 2024-10-17 19:03:38 字数 1174 浏览 10 评论 0原文

ZF 1.9.5 此处。有人建议在使用 Zend_Db_Table 时捕获异常以模拟ON DUPLICATE KEY UPDATE。

目前，我收到

SQLSTATE[23000]: Integrityconstraint Violation: 1062 Duplicateentry 'i7dd30253497cfc0539d7c5830a926f7d' for key 'ukey'

..使用

$orderRow = $this->createRow();
$orderRow->ukey = $ukey;
$orderRow->save();

时，我想用 try 来捕获那个 bug /捕获。出现异常时更新，否则插入。
但我不知道该抓什么。 Zend_Db_Exception？ PDOException？ Zend_Db_Adapter_Exception？我已经尝试了几个，但我认为我没有得到它。

稍后编辑。这对我有用：

        try {
            $orderRow = $this->createRow();
            $orderRow->ukey = $ukey;
            $orderRow->$stepCol = time();
            $orderRow->save();
        } catch (Zend_Db_Statement_Exception $e) {
            // on UNIQUE error, update
            if ($e->getCode() == 23000) {
                $orderRow = $this->fetchRow($this->select()->where('ukey = ?', $ukey));
                $orderRow->$stepCol = time();
                $orderRow->save();
            }
        }

原文

ZF 1.9.5 here. Someone suggested catching exceptions to emulate ON DUPLICATE KEY UPDATE when using Zend_Db_Table.

Currently, I'm getting

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'i7dd30253497cfc0539d7c5830a926f7d' for key 'ukey'

..when using

$orderRow = $this->createRow();
$orderRow->ukey = $ukey;
$orderRow->save();

So, I want to catch that bugger with try / catch. On exception update , else insert.
But I don't know what to catch. Zend_Db_Exception? PDOException? Zend_Db_Adapter_Exception? I've tried several, but I don't think I got it.

Later edit.
This worked for me:

        try {
            $orderRow = $this->createRow();
            $orderRow->ukey = $ukey;
            $orderRow->$stepCol = time();
            $orderRow->save();
        } catch (Zend_Db_Statement_Exception $e) {
            // on UNIQUE error, update
            if ($e->getCode() == 23000) {
                $orderRow = $this->fetchRow($this->select()->where('ukey = ?', $ukey));
                $orderRow->$stepCol = time();
                $orderRow->save();
            }
        }

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

灼痛 2024-10-24 19:03:38

只需看看抛出的异常是这样的：

try {
    // query
} catch (Exception $e) {
    var_dump(get_class($e));
}

这应该告诉您需要捕获哪种异常，因为“Exception”将捕获每种类型的异常，无论是 ZF 异常还是 PDO 异常还是完全不同的异常

Just look what exception is getting thrown like this:

try {
    // query
} catch (Exception $e) {
    var_dump(get_class($e));
}

That should tell you what kind of exception you need to catch because "Exception" will catch every type of exception, be it a ZF exception or a PDO exception or something completely different

回复收藏 0 原文