blob: f1be4e0b9b61e4d94a45328e6f3af7ec7747f850 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
<?php
/**
* TDbTransaction class file
*
* @author Qiang Xue <qiang.xue@gmail.com>
* @link http://www.pradosoft.com/
* @copyright Copyright © 2005-2013 PradoSoft
* @license http://www.pradosoft.com/license/
* @version $Id: TDbTransaction.php 3245 2013-01-07 20:23:32Z ctrlaltca $
* @package System.Data
*/
Prado::using('System.Data.TDbDataReader');
/**
* TDbTransaction class.
*
* TDbTransaction represents a DB transaction.
* It is usually created by calling {@link TDbConnection::beginTransaction}.
*
* The following code is a common scenario of using transactions:
* <code>
* try
* {
* $transaction=$connection->beginTransaction();
* $connection->createCommand($sql1)->execute();
* $connection->createCommand($sql2)->execute();
* //.... other SQL executions
* $transaction->commit();
* }
* catch(Exception $e)
* {
* $transaction->rollBack();
* }
* </code>
*
* @author Qiang Xue <qiang.xue@gmail.com>
* @version $Id: TDbTransaction.php 3245 2013-01-07 20:23:32Z ctrlaltca $
* @package System.Data
* @since 3.0
*/
class TDbTransaction extends TComponent
{
private $_connection=null;
private $_active;
/**
* Constructor.
* @param TDbConnection the connection associated with this transaction
* @see TDbConnection::beginTransaction
*/
public function __construct(TDbConnection $connection)
{
$this->_connection=$connection;
$this->setActive(true);
}
/**
* Commits a transaction.
* @throws TDbException if the transaction or the DB connection is not active.
*/
public function commit()
{
if($this->_active && $this->_connection->getActive())
{
$this->_connection->getPdoInstance()->commit();
$this->_active=false;
}
else
throw new TDbException('dbtransaction_transaction_inactive');
}
/**
* Rolls back a transaction.
* @throws TDbException if the transaction or the DB connection is not active.
*/
public function rollback()
{
if($this->_active && $this->_connection->getActive())
{
$this->_connection->getPdoInstance()->rollBack();
$this->_active=false;
}
else
throw new TDbException('dbtransaction_transaction_inactive');
}
/**
* @return TDbConnection the DB connection for this transaction
*/
public function getConnection()
{
return $this->_connection;
}
/**
* @return boolean whether this transaction is active
*/
public function getActive()
{
return $this->_active;
}
/**
* @param boolean whether this transaction is active
*/
protected function setActive($value)
{
$this->_active=TPropertyValue::ensureBoolean($value);
}
}
|
