Yii Framework Wiki
Difference between
#6 and
#7 of
How to use nested DB transactions (MySQL 5+, PostgreSQL)
Revision #7 has been created by Boaz on Oct 21, 2015, 10:14:42 AM with the memo:
probable typo - fixed
« previous (#6)
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
Original source code and 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:
```php
class ServiceA {
If there are services A and B here's how it might happen:
```php
class ServiceA {
[...]
26 followers
Viewed: 67 887 times
Version: 1.1
Category: How-tos
Written by: mindeh
Last updated by: Boaz
Created on: Jun 30, 2009
Last updated: 9 years ago
Revisions
View all history-
9 years ago by
Boaz probable typo - fixed
-
13 years ago by
Darwin Wen Add chinese version url
-
13 years ago by
samdark Optimized code
-
13 years ago by
samdark Updated configuration for 1.1.8
-
13 years ago by
jonjonw Modified instructions to use a subclass...
-
14 years ago by
wei formatting, tags
-
15 years ago by
mindeh initial version