Class CDbTransaction

CDbTransaction represents a DB transaction.

It is usually created by calling CDbConnection::beginTransaction().

The following code is a common scenario of using transactions:

$transaction=$connection->beginTransaction();
try
{
   $connection->createCommand($sql1)->execute();
   $connection->createCommand($sql2)->execute();
   //.... other SQL executions
   $transaction->commit();
}
catch(Exception $e)
{
   $transaction->rollback();
}

CComponent

CDbTransaction

Package: system\db
Copyright: 2008-2013 Yii Software LLC
License: http://www.yiiframework.com/license/
Author: Qiang Xue <qiang.xue@gmail.com>
Since: 1.0
Located at x2engine/framework/db/CDbTransaction.php

Methods summary
`public`	# `__construct( CDbConnection $connection )` Constructor. Constructor. Parameters `$connection` `CDbConnection` $connection the connection associated with this transaction See `CDbConnection::beginTransaction()`
`public`	# `commit( )` Commits a transaction. Commits a transaction. Throws `CException` if the transaction or the DB connection is not active.
`public`	# `rollback( )` Rolls back a transaction. Rolls back a transaction. Throws `CException` if the transaction or the DB connection is not active.
`public CDbConnection`	# `getConnection( )` Returns `CDbConnection` the DB connection for this transaction
`public boolean`	# `getActive( )` Returns `boolean` whether this transaction is active
`protected`	# `setActive( boolean $value )` Parameters `$value` `boolean` $value whether this transaction is active

Methods inherited from CComponent
`__call(), __get(), __isset(), __set(), __unset(), asa(), attachBehavior(), attachBehaviors(), attachEventHandler(), canGetProperty(), canSetProperty(), detachBehavior(), detachBehaviors(), detachEventHandler(), disableBehavior(), disableBehaviors(), enableBehavior(), enableBehaviors(), evaluateExpression(), getEventHandlers(), hasEvent(), hasEventHandler(), hasProperty(), raiseEvent()`

Magic properties summary
`public CDbConnection`	`$connection`	# The DB connection for this transaction. The DB connection for this transaction.
`public boolean`	`$active`	# Whether this transaction is active. Whether this transaction is active.

Packages

Classes

Exceptions

Class CDbTransaction

Parameters

See

Throws

Throws

Returns

Returns

Parameters