/sqlite3cc

To get this branch, use:
bzr branch http://bzr.ed.am/sqlite3cc

« back to all changes in this revision

Viewing changes to include/sqlitepp/transaction.hpp

  • Committer: edam
  • Date: 2009-11-25 20:32:34 UTC
  • Revision ID: edam@waxworlds.org-20091125203234-24i7mzd60c7o46py
- initial commit
- basic support for: database, statements, commands, transactions, exceptions
- initial test app
- initial liscence and readme

Show diffs side-by-side

added added

removed removed

1
1
/*
2
 
 * transaction.h
 
2
 * transaction.hpp
3
3
 *
4
4
 * Copyright (C) 2009 Tim Marston <edam@waxworlds.org>
5
5
 *
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.
 
6
 * This file is part of sqlitepp (hereafter referred to as "this program").
 
7
 * See http://www.waxworlds.org/edam/software/sqlitepp for more information.
8
8
 *
9
9
 * This program is free software: you can redistribute it and/or modify
10
10
 * it under the terms of the GNU Lesser General Public License as published
20
20
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
21
21
 */
22
22
 
23
 
#ifndef SQLITE3CC_TRANSACTION_H_
24
 
#define SQLITE3CC_TRANSACTION_H_
 
23
#ifndef TRANSACTION_HPP_
 
24
#define TRANSACTION_HPP_
25
25
 
26
26
 
27
27
#include <boost/utility.hpp>
28
 
#include <string>
29
28
 
30
29
 
31
30
namespace sqlite
35
34
class database;
36
35
 
37
36
 
38
 
/**
39
 
 * A basic (default, deferred) transaction.
40
 
 */
41
 
class basic_transaction
 
37
class transaction
42
38
        :
43
39
        private boost::noncopyable
44
40
{
50
46
         * Constructor that provides a database upon which to act
51
47
         * @param database a database
52
48
         */
53
 
        explicit basic_transaction(
 
49
        transaction(
54
50
                database &database );
55
51
 
 
52
        virtual ~transaction() throw( );
 
53
 
 
54
protected:
 
55
 
 
56
        /**
 
57
         * Constructor that provides a way for deriving classes to override the SQL
 
58
         * executed in beginning and rolling-back a transaction during construction
 
59
         * and destruction.
 
60
         * @param database a database
 
61
         * @param begin_sql the SQL statement used to begin the transaction
 
62
         * @param rollback_sql the SQL statement used to rollback the transaction,
 
63
         *              or an empty string if the default is to be used.
 
64
         */
 
65
        transaction(
 
66
                database &database,
 
67
                const std::string &begin_sql,
 
68
                const std::string &rollback_sql = "" );
 
69
 
56
70
//______________________________________________________________________________
57
71
//                                                              public interface
58
 
public:
59
 
 
60
 
        /**
61
 
         * Begin the transaction
62
 
         */
63
 
        virtual void begin();
64
72
 
65
73
        /**
66
74
         * Commit the transaction
70
78
        /**
71
79
         * Rollback the transaction
72
80
         */
73
 
        virtual void rollback();
 
81
        void rollback();
74
82
 
75
83
//______________________________________________________________________________
76
84
//                                                                implementation
77
85
protected:
78
86
 
79
 
        /** close any in-progress statements */
80
 
        void invalidate_queries();
81
 
 
82
 
        /** the database on which to act */
 
87
        /** the database */
83
88
        database &_database;
84
89
 
85
 
};
86
 
 
87
 
 
88
 
////////////////////////////////////////////////////////////////////////////////
89
 
 
90
 
 
91
 
/**
92
 
 * An exclusive transaction
93
 
 */
94
 
class immediate_transaction
95
 
        :
96
 
        public basic_transaction
97
 
{
98
 
//______________________________________________________________________________
99
 
//                                                                 instantiation
100
 
public:
101
 
 
102
 
        /**
103
 
         * Constructor that provides a database upon which to act
104
 
         * @param database a database
105
 
         */
106
 
        explicit immediate_transaction(
107
 
                database &database );
108
 
 
109
 
//______________________________________________________________________________
110
 
//                                                              public interface
111
 
public:
112
 
 
113
 
        /**
114
 
         * Begin the transaction
115
 
         */
116
 
        virtual void begin();
117
 
 
118
 
};
119
 
 
120
 
 
121
 
////////////////////////////////////////////////////////////////////////////////
122
 
 
123
 
 
124
 
/**
125
 
 * An exclusive transaction
126
 
 */
 
90
        /** the SQL used to rollback the transaction, or empty to use default */
 
91
        std::string _rollback_sql;
 
92
 
 
93
};
 
94
 
 
95
 
 
96
////////////////////////////////////////////////////////////////////////////////
 
97
 
 
98
 
127
99
class exclusive_transaction
128
100
        :
129
 
        public basic_transaction
130
 
{
131
 
//______________________________________________________________________________
132
 
//                                                                 instantiation
133
 
public:
134
 
 
135
 
        /**
136
 
         * Constructor that provides a database upon which to act
137
 
         * @param database a database
138
 
         */
139
 
        explicit exclusive_transaction(
140
 
                database &database );
141
 
 
142
 
//______________________________________________________________________________
143
 
//                                                              public interface
144
 
public:
145
 
 
146
 
        /**
147
 
         * Begin the transaction
148
 
         */
149
 
        virtual void begin();
150
 
 
151
 
};
152
 
 
153
 
 
154
 
////////////////////////////////////////////////////////////////////////////////
155
 
 
156
 
 
157
 
/**
158
 
 * A recursive transaction, allowing transactions to be nested.
159
 
 */
160
 
class recursive_transaction
161
 
        :
162
 
        public basic_transaction
163
 
{
164
 
//______________________________________________________________________________
165
 
//                                                                 instantiation
166
 
public:
167
 
 
168
 
        /**
169
 
         * Constructor that provides a database upon which to act
170
 
         * @param database a database
171
 
         */
172
 
        explicit recursive_transaction(
173
 
                database &database );
174
 
 
175
 
//______________________________________________________________________________
176
 
//                                                              public interface
177
 
public:
178
 
 
179
 
        /**
180
 
         * Begin the transaction
181
 
         */
182
 
        virtual void begin();
183
 
 
184
 
        /**
185
 
         * Commit the transaction
186
 
         */
187
 
        virtual void commit();
188
 
 
189
 
        /**
190
 
         * Rollback the transaction
191
 
         */
192
 
        virtual void rollback();
193
 
 
194
 
//______________________________________________________________________________
195
 
//                                                                implementation
196
 
protected:
197
 
 
198
 
        /* this transaction's savepoint name */
199
 
        std::string _sp_name;
200
 
 
201
 
};
202
 
 
203
 
 
204
 
////////////////////////////////////////////////////////////////////////////////
205
 
 
206
 
 
207
 
/**
208
 
 * A scope guard, or sentinel for use with one of the transaction classes.
209
 
 */
210
 
template< class T = basic_transaction >
211
 
class transaction_guard
212
 
        :
213
 
        private boost::noncopyable
214
 
{
215
 
//______________________________________________________________________________
216
 
//                                                                 instantiation
217
 
public:
218
 
 
219
 
        /**
220
 
         * Constructor that provides a database upon which to act
221
 
         * @param database a database
222
 
         */
223
 
        explicit transaction_guard(
224
 
                database &database )
225
 
                :
226
 
                _transaction( database ),
227
 
                _released( false )
228
 
        {
229
 
                _transaction.begin();
230
 
        }
231
 
 
232
 
        ~transaction_guard()
233
 
        {
234
 
                if( !_released ) {
235
 
                        try {
236
 
                                _transaction.rollback();
237
 
                        }
238
 
                        catch( ... ) {
239
 
                        }
240
 
                }
241
 
        }
242
 
 
243
 
//______________________________________________________________________________
244
 
//                                                              public interface
245
 
public:
246
 
 
247
 
        /**
248
 
         * Commit the transaction
249
 
         */
250
 
        void commit()
251
 
        {
252
 
                if( !_released ) {
253
 
                        _transaction.commit();
254
 
                        _released = true;
255
 
                }
256
 
        }
257
 
 
258
 
//______________________________________________________________________________
259
 
//                                                                implementation
260
 
protected:
261
 
 
262
 
        /** the transaction */
263
 
        T _transaction;
264
 
 
265
 
        /** have we released the transaction yet? */
266
 
        bool _released;
267
 
 
268
 
};
269
 
 
270
 
 
271
 
} // namespace sqlite
272
 
 
273
 
 
274
 
#endif /* SQLITE3CC_TRANSACTION_H_ */
 
101
        public transaction
 
102
{
 
103
//______________________________________________________________________________
 
104
//                                                                 instantiation
 
105
public:
 
106
 
 
107
        /**
 
108
         * Constructor that provides a database upon which to act
 
109
         * @param database a database
 
110
         */
 
111
        exclusive_transaction(
 
112
                database &database );
 
113
 
 
114
};
 
115
 
 
116
 
 
117
}
 
118
 
 
119
 
 
120
#endif /* TRANSACTION_HPP_ */