Phalcon事务和嵌套事务

Phalcon支持事务处理, 因为它随PDO一起提供。为了提高数据库的性能, 我们可以执行数据操作。下面是应用事务的数据库结构：

事务示例：

<?php

try {
    // Start a transaction
    $connection->begin();

    // Execute some SQL statements
    $connection->execute('DELETE 'company' WHERE 'id' = 101');
    $connection->execute('DELETE 'company' WHERE 'id' = 102');
    $connection->execute('DELETE 'company' WHERE 'id' = 103');

    // Commit if everything goes well
    $connection->commit();
} catch (Exception $e) {
    // An exception has occurred rollback the transaction
    $connection->rollback();
}

//数据库”公司”数据已删除。

嵌套事务示例：

<?php

try {
    // Start a transaction
    $connection->begin();

    // Execute some SQL statements
    $connection->execute('DELETE 'company' WHERE 'id' = 101');

    try {
        // Start a nested transaction
        $connection->begin();

        // Execute these SQL statements into the nested transaction
        $connection->execute('DELETE 'company' WHERE 'id' = 102');
        $connection->execute('DELETE 'company' WHERE 'id' = 103');

        // Create a save point
        $connection->commit();
    } catch (Exception $e) {
        // An error has occurred, release the nested transaction
        $connection->rollback();
    }

    // Continue, executing more SQL statements
    $connection->execute('DELETE 'company' WHERE 'id' = 104');

    // Commit if everything goes well
    $connection->commit();
} catch (Exception $e) {
    // An exception has occurred rollback the transaction
    $connection->rollback();
}

//数据库”公司”数据已删除。