bzr branch
http://bzr.ed.am/sqlite3cc
|
1
by edam
- initial commit |
1 |
/* |
|
2
by edam
- further initial development |
2 |
* transaction.cc |
|
1
by edam
- initial commit |
3 |
* |
4 |
* Copyright (C) 2009 Tim Marston <edam@waxworlds.org> |
|
5 |
* |
|
|
2
by edam
- further initial development |
6 |
* This file is part of sqlite3cc (hereafter referred to as "this program"). |
7 |
* See http://www.waxworlds.org/edam/software/sqlite3cc for more information. |
|
|
1
by edam
- initial commit |
8 |
* |
9 |
* This program is free software: you can redistribute it and/or modify |
|
10 |
* it under the terms of the GNU Lesser General Public License as published |
|
11 |
* by the Free Software Foundation, either version 3 of the License, or |
|
12 |
* (at your option) any later version. |
|
13 |
* |
|
14 |
* This program is distributed in the hope that it will be useful, |
|
15 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
16 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
17 |
* GNU Lesser General Public License for more details. |
|
18 |
* |
|
19 |
* You should have received a copy of the GNU Lesser General Public License |
|
20 |
* along with this program. If not, see <http://www.gnu.org/licenses/>. |
|
21 |
*/ |
|
22 |
||
|
2
by edam
- further initial development |
23 |
#include <sqlite3cc/transaction.h> |
24 |
#include <sqlite3cc/database.h> |
|
25 |
#include <sqlite3cc/exception.h> |
|
|
3
by edam
- rewrote transaction classes and added transaction_guard |
26 |
#include <boost/thread.hpp> |
|
9
by edam
- added NEWS |
27 |
#include <boost/lexical_cast.hpp> |
|
3
by edam
- rewrote transaction classes and added transaction_guard |
28 |
|
29 |
||
30 |
sqlite::basic_transaction::basic_transaction( |
|
|
1
by edam
- initial commit |
31 |
database &database ) |
32 |
: |
|
33 |
_database( database ) |
|
34 |
{
|
|
|
3
by edam
- rewrote transaction classes and added transaction_guard |
35 |
} |
36 |
||
37 |
||
38 |
void sqlite::basic_transaction::begin() |
|
39 |
{
|
|
|
1
by edam
- initial commit |
40 |
int error_code = _database.exec( "BEGIN" ); |
41 |
if( error_code != SQLITE_OK ) throw sqlite_error( error_code ); |
|
42 |
} |
|
43 |
||
44 |
||
|
3
by edam
- rewrote transaction classes and added transaction_guard |
45 |
void sqlite::basic_transaction::commit() |
|
1
by edam
- initial commit |
46 |
{
|
47 |
int error_code = _database.exec( "COMMIT" ); |
|
48 |
if( error_code != SQLITE_OK ) throw sqlite_error( error_code ); |
|
49 |
} |
|
50 |
||
51 |
||
|
3
by edam
- rewrote transaction classes and added transaction_guard |
52 |
void sqlite::basic_transaction::rollback() |
|
1
by edam
- initial commit |
53 |
{
|
|
3
by edam
- rewrote transaction classes and added transaction_guard |
54 |
int error_code = _database.exec( "ROLLBACK" ); |
|
1
by edam
- initial commit |
55 |
if( error_code != SQLITE_OK ) throw sqlite_error( error_code ); |
56 |
} |
|
57 |
||
58 |
||
59 |
sqlite::exclusive_transaction::exclusive_transaction( |
|
60 |
database &database ) |
|
61 |
: |
|
|
3
by edam
- rewrote transaction classes and added transaction_guard |
62 |
basic_transaction( database ) |
63 |
{
|
|
64 |
} |
|
65 |
||
66 |
||
67 |
void sqlite::exclusive_transaction::begin() |
|
68 |
{
|
|
69 |
int error_code = _database.exec( "BEGIN EXCLUSIVE" ); |
|
70 |
if( error_code != SQLITE_OK ) throw sqlite_error( error_code ); |
|
71 |
} |
|
72 |
||
73 |
||
74 |
sqlite::recursive_transaction::recursive_transaction( |
|
75 |
database &database ) |
|
76 |
: |
|
77 |
basic_transaction( database ) |
|
78 |
{
|
|
79 |
static unsigned long long i = 0; |
|
80 |
unsigned long long my_i; |
|
81 |
static boost::mutex mutex; |
|
82 |
{
|
|
83 |
boost::lock_guard< boost::mutex > lock( mutex ); |
|
84 |
my_i = i++; |
|
85 |
} |
|
86 |
_sp_name = "_" + boost::lexical_cast< std::string >( my_i++ ); |
|
87 |
} |
|
88 |
||
89 |
||
90 |
void sqlite::recursive_transaction::begin() |
|
91 |
{
|
|
92 |
int error_code = _database.exec( "SAVEPOINT " + _sp_name ); |
|
93 |
if( error_code != SQLITE_OK ) throw sqlite_error( error_code ); |
|
94 |
} |
|
95 |
||
96 |
||
97 |
void sqlite::recursive_transaction::commit() |
|
98 |
{
|
|
99 |
int error_code = _database.exec( "RELEASE " + _sp_name ); |
|
100 |
if( error_code != SQLITE_OK ) throw sqlite_error( error_code ); |
|
101 |
} |
|
102 |
||
103 |
||
104 |
void sqlite::recursive_transaction::rollback() |
|
105 |
{
|
|
106 |
int error_code = _database.exec( "ROLLBACK TO " + _sp_name ); |
|
107 |
if( error_code != SQLITE_OK ) throw sqlite_error( error_code ); |
|
108 |
||
109 |
// we have rolled back this transaction's savepoint, but the savepoint will |
|
110 |
// remain on the transaction stack unless we also release it |
|
111 |
error_code = _database.exec( "RELEASE " + _sp_name ); |
|
112 |
if( error_code != SQLITE_OK ) throw sqlite_error( error_code ); |
|
|
1
by edam
- initial commit |
113 |
} |