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