transaction.cpp revision 1.1.1.1 1 1.1 jmmv // Copyright 2011 Google Inc.
2 1.1 jmmv // All rights reserved.
3 1.1 jmmv //
4 1.1 jmmv // Redistribution and use in source and binary forms, with or without
5 1.1 jmmv // modification, are permitted provided that the following conditions are
6 1.1 jmmv // met:
7 1.1 jmmv //
8 1.1 jmmv // * Redistributions of source code must retain the above copyright
9 1.1 jmmv // notice, this list of conditions and the following disclaimer.
10 1.1 jmmv // * Redistributions in binary form must reproduce the above copyright
11 1.1 jmmv // notice, this list of conditions and the following disclaimer in the
12 1.1 jmmv // documentation and/or other materials provided with the distribution.
13 1.1 jmmv // * Neither the name of Google Inc. nor the names of its contributors
14 1.1 jmmv // may be used to endorse or promote products derived from this software
15 1.1 jmmv // without specific prior written permission.
16 1.1 jmmv //
17 1.1 jmmv // THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
18 1.1 jmmv // "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
19 1.1 jmmv // LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
20 1.1 jmmv // A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
21 1.1 jmmv // OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
22 1.1 jmmv // SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
23 1.1 jmmv // LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
24 1.1 jmmv // DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
25 1.1 jmmv // THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
26 1.1 jmmv // (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
27 1.1 jmmv // OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
28 1.1 jmmv
29 1.1 jmmv #include "utils/sqlite/transaction.hpp"
30 1.1 jmmv
31 1.1 jmmv #include "utils/format/macros.hpp"
32 1.1 jmmv #include "utils/logging/macros.hpp"
33 1.1 jmmv #include "utils/sanity.hpp"
34 1.1 jmmv #include "utils/sqlite/database.hpp"
35 1.1 jmmv #include "utils/sqlite/exceptions.hpp"
36 1.1 jmmv #include "utils/sqlite/statement.ipp"
37 1.1 jmmv
38 1.1 jmmv namespace sqlite = utils::sqlite;
39 1.1 jmmv
40 1.1 jmmv
41 1.1 jmmv /// Internal implementation for the transaction.
42 1.1 jmmv struct utils::sqlite::transaction::impl {
43 1.1 jmmv /// The database this transaction belongs to.
44 1.1 jmmv database& db;
45 1.1 jmmv
46 1.1 jmmv /// Possible statuses of a transaction.
47 1.1 jmmv enum statuses {
48 1.1 jmmv open_status,
49 1.1 jmmv committed_status,
50 1.1 jmmv rolled_back_status,
51 1.1 jmmv };
52 1.1 jmmv
53 1.1 jmmv /// The current status of the transaction.
54 1.1 jmmv statuses status;
55 1.1 jmmv
56 1.1 jmmv /// Constructs a new transaction.
57 1.1 jmmv ///
58 1.1 jmmv /// \param db_ The database this transaction belongs to.
59 1.1 jmmv /// \param status_ The status of the new transaction.
60 1.1 jmmv impl(database& db_, const statuses status_) :
61 1.1 jmmv db(db_),
62 1.1 jmmv status(status_)
63 1.1 jmmv {
64 1.1 jmmv }
65 1.1 jmmv
66 1.1 jmmv /// Destroys the transaction.
67 1.1 jmmv ///
68 1.1 jmmv /// This rolls back the transaction if it is open.
69 1.1 jmmv ~impl(void)
70 1.1 jmmv {
71 1.1 jmmv if (status == impl::open_status) {
72 1.1 jmmv try {
73 1.1 jmmv rollback();
74 1.1 jmmv } catch (const sqlite::error& e) {
75 1.1 jmmv LW(F("Error while rolling back a transaction: %s") % e.what());
76 1.1 jmmv }
77 1.1 jmmv }
78 1.1 jmmv }
79 1.1 jmmv
80 1.1 jmmv /// Commits the transaction.
81 1.1 jmmv ///
82 1.1 jmmv /// \throw api_error If there is any problem while committing the
83 1.1 jmmv /// transaction.
84 1.1 jmmv void
85 1.1 jmmv commit(void)
86 1.1 jmmv {
87 1.1 jmmv PRE(status == impl::open_status);
88 1.1 jmmv db.exec("COMMIT");
89 1.1 jmmv status = impl::committed_status;
90 1.1 jmmv }
91 1.1 jmmv
92 1.1 jmmv /// Rolls the transaction back.
93 1.1 jmmv ///
94 1.1 jmmv /// \throw api_error If there is any problem while rolling the
95 1.1 jmmv /// transaction back.
96 1.1 jmmv void
97 1.1 jmmv rollback(void)
98 1.1 jmmv {
99 1.1 jmmv PRE(status == impl::open_status);
100 1.1 jmmv db.exec("ROLLBACK");
101 1.1 jmmv status = impl::rolled_back_status;
102 1.1 jmmv }
103 1.1 jmmv };
104 1.1 jmmv
105 1.1 jmmv
106 1.1 jmmv /// Initializes a transaction object.
107 1.1 jmmv ///
108 1.1 jmmv /// This is an internal function. Use database::begin_transaction() to
109 1.1 jmmv /// instantiate one of these objects.
110 1.1 jmmv ///
111 1.1 jmmv /// \param db The database this transaction belongs to.
112 1.1 jmmv sqlite::transaction::transaction(database& db) :
113 1.1 jmmv _pimpl(new impl(db, impl::open_status))
114 1.1 jmmv {
115 1.1 jmmv }
116 1.1 jmmv
117 1.1 jmmv
118 1.1 jmmv /// Destructor for the transaction.
119 1.1 jmmv sqlite::transaction::~transaction(void)
120 1.1 jmmv {
121 1.1 jmmv }
122 1.1 jmmv
123 1.1 jmmv
124 1.1 jmmv /// Commits the transaction.
125 1.1 jmmv ///
126 1.1 jmmv /// \throw api_error If there is any problem while committing the transaction.
127 1.1 jmmv void
128 1.1 jmmv sqlite::transaction::commit(void)
129 1.1 jmmv {
130 1.1 jmmv _pimpl->commit();
131 1.1 jmmv }
132 1.1 jmmv
133 1.1 jmmv
134 1.1 jmmv /// Rolls the transaction back.
135 1.1 jmmv ///
136 1.1 jmmv /// \throw api_error If there is any problem while rolling the transaction back.
137 1.1 jmmv void
138 1.1 jmmv sqlite::transaction::rollback(void)
139 1.1 jmmv {
140 1.1 jmmv _pimpl->rollback();
141 1.1 jmmv }
142