Difference between #4 and #7 of
How to use nested DB transactions (MySQL 5+, PostgreSQL)

Changes

Title unchanged

How to use nested DB transactions (MySQL 5+, PostgreSQL)

Category unchanged

How-tos

Yii version unchanged

Tags unchanged

db, mysql, postgresql, transaction, nested

Content changed

SOriginal source code takenand idea are from: [PHP, PDO & Nested Transactions](http://www.kennynet.co.uk/2008/12/02/php-pdo-nested-transactions/). Tested with: MySQL 5.1.30 + Yii 1.1.8. Problem: Say there is service layer in an application, and one service may use others. Now each service deals will complex business logic will needs to wrap that into transactions.

If there are services A and B here's how it might happen:
[...]
public function beginTransaction() {
if(!$this->nestable() || $this->transLevel == 0 || !$this->nestable()) {
parent::beginTransaction();
} else {
[...]
$this->transLevel--;

if(!$this->nestable()transLevel == 0 || !$this->transLevel == 0nestable()) {
parent::commit();
} else {
[...]
$this->transLevel--;

if(!$this->nestable()transLevel == 0 || !$this->transLevel == 0nestable()) {
parent::rollBack();
} else {
[...]
That's it, there you go ;)

 
 
Links
 
-----
 
- [Chinese version](http://www.itkuaixun.com/bbs/thread-206-1-1.html "Chinese version")
41 0
26 followers
Viewed: 68 421 times
Version: 1.1
Category: How-tos
Tags: db, mysql, nested, postgresql, transaction
Written by: mindeh
Last updated by: Boaz
Created on: Jun 30, 2009
Last updated: 9 years ago
Update Article
Revert to #4 | Revert to #7

Revisions

View all history