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
113
114
115
116
117
118
119
120
121
|
/***********************************************************************
transaction.cpp - Implements the Transaction class.
Copyright (c) 2006-2007 by Educational Technology Resources, Inc.
Others may also hold copyrights on code in this file. See the
CREDITS.txt file in the top directory of the distribution for details.
This file is part of MySQL++.
MySQL++ is free software; you can redistribute it and/or modify it
under the terms of the GNU Lesser General Public License as published
by the Free Software Foundation; either version 2.1 of the License, or
(at your option) any later version.
MySQL++ is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public
License for more details.
You should have received a copy of the GNU Lesser General Public
License along with MySQL++; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
USA
***********************************************************************/
#define MYSQLPP_NOT_HEADER
#include "common.h"
#include "transaction.h"
#include "connection.h"
#include "query.h"
using namespace std;
using namespace mysqlpp;
//// ctors /////////////////////////////////////////////////////////////
Transaction::Transaction(Connection& conn, bool consistent) :
conn_(conn),
finished_(true) // don't bother rolling it back if ctor fails
{
// Begin the transaction set
Query q(conn_.query("START TRANSACTION"));
if (consistent) {
q << " WITH CONSISTENT SNAPSHOT";
}
q.execute();
// Setup succeeded, so mark our transaction as not-finished.
finished_ = false;
}
Transaction::Transaction(Connection& conn, IsolationLevel level,
IsolationScope scope, bool consistent) :
conn_(conn),
finished_(true) // don't bother rolling it back if ctor fails
{
// Set the transaction isolation level and scope as the user wishes
Query q(conn_.query("SET "));
if (scope == session) q << "SESSION ";
if (scope == global) q << "GLOBAL ";
q << "TRANSACTION ISOLATION LEVEL ";
switch (level) {
case read_uncommitted: q << "READ UNCOMMITTED";
case read_committed: q << "READ COMMITTED";
case repeatable_read: q << "REPEATABLE READ";
case serializable: q << "SERIALIZABLE";
}
q.execute();
// Begin the transaction set. Note that the above isn't part of
// the transaction, on purpose, so that scope == transaction affects
// *this* transaction, not the next one.
q << "START TRANSACTION";
if (consistent) {
q << " WITH CONSISTENT SNAPSHOT";
}
q.execute();
// Setup succeeded, so mark our transaction as not-finished.
finished_ = false;
}
//// dtor //////////////////////////////////////////////////////////////
Transaction::~Transaction()
{
if (!finished_) {
try {
rollback();
}
catch (...) {
// eat all exceptions
}
}
}
//// commit ////////////////////////////////////////////////////////////
void
Transaction::commit()
{
conn_.query("COMMIT").execute();
finished_ = true;
}
//// rollback //////////////////////////////////////////////////////////
void
Transaction::rollback()
{
conn_.query("ROLLBACK").execute();
finished_ = true;
}
|
