Versions
Look up a class, method, property or event

CDbTransaction

Package system.db
Inheritance class CDbTransaction » CComponent
Since 1.0
Version $Id: CDbTransaction.php 1021 2009-05-11 12:33:44Z qiang.xue $
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();
}

Public Properties

Hide inherited properties

PropertyTypeDescriptionDefined By
active boolean whether this transaction is active CDbTransaction
connection CDbConnection the DB connection for this transaction CDbTransaction

Public Methods

Hide inherited methods

MethodDescriptionDefined By
__call() Calls the named method which is not a class method. CComponent
__construct() Constructor. CDbTransaction
__get() Returns a property value, an event handler list or a behavior based on its name. CComponent
__isset() Checks if a property value is null. CComponent
__set() Sets value of a component property. CComponent
__unset() Sets a component property to be null. CComponent
asa() Returns the named behavior object. CComponent
attachBehavior() Attaches a behavior to this component. CComponent
attachBehaviors() Attaches a list of behaviors to the component. CComponent
attachEventHandler() Attaches an event handler to an event. CComponent
canGetProperty() Determines whether a property can be read. CComponent
canSetProperty() Determines whether a property can be set. CComponent
commit() Commits a transaction. CDbTransaction
detachBehavior() Detaches a behavior from the component. CComponent
detachBehaviors() Detaches all behaviors from the component. CComponent
detachEventHandler() Detaches an existing event handler. CComponent
disableBehavior() Disables an attached behavior. CComponent
disableBehaviors() Disables all behaviors attached to this component. CComponent
enableBehavior() Enables an attached behavior. CComponent
enableBehaviors() Enables all behaviors attached to this component. CComponent
getActive() CDbTransaction
getConnection() CDbTransaction
getEventHandlers() Returns the list of attached event handlers for an event. CComponent
hasEvent() Determines whether an event is defined. CComponent
hasEventHandler() Checks whether the named event has attached handlers. CComponent
hasProperty() Determines whether a property is defined. CComponent
raiseEvent() Raises an event. CComponent
rollback() Rolls back a transaction. CDbTransaction

Protected Methods

Hide inherited methods

MethodDescriptionDefined By
setActive() CDbTransaction

Property Details

active property
public boolean getActive()
protected void setActive(boolean $value)

whether this transaction is active

connection property read-only

the DB connection for this transaction

Method Details

__construct() method
public void __construct(CDbConnection $connection)
$connection CDbConnection the connection associated with this transaction

Constructor.

commit() method
public void commit()

Commits a transaction.

getActive() method
public boolean getActive()
{return} boolean whether this transaction is active

getConnection() method
public CDbConnection getConnection()
{return} CDbConnection the DB connection for this transaction

rollback() method
public void rollback()

Rolls back a transaction.

setActive() method
protected void setActive(boolean $value)
$value boolean whether this transaction is active

Be the first person to leave a comment

Please to leave your comment.