xref: /src/contrib/kyua/utils/sqlite/transaction.cpp (revision b0d29bc47dba79f6f38e67eabadfb4b32ffd9390)
108334c51SBrooks Davis // Copyright 2011 The Kyua Authors.
208334c51SBrooks Davis // All rights reserved.
308334c51SBrooks Davis //
408334c51SBrooks Davis // Redistribution and use in source and binary forms, with or without
508334c51SBrooks Davis // modification, are permitted provided that the following conditions are
608334c51SBrooks Davis // met:
708334c51SBrooks Davis //
808334c51SBrooks Davis // * Redistributions of source code must retain the above copyright
908334c51SBrooks Davis //   notice, this list of conditions and the following disclaimer.
1008334c51SBrooks Davis // * Redistributions in binary form must reproduce the above copyright
1108334c51SBrooks Davis //   notice, this list of conditions and the following disclaimer in the
1208334c51SBrooks Davis //   documentation and/or other materials provided with the distribution.
1308334c51SBrooks Davis // * Neither the name of Google Inc. nor the names of its contributors
1408334c51SBrooks Davis //   may be used to endorse or promote products derived from this software
1508334c51SBrooks Davis //   without specific prior written permission.
1608334c51SBrooks Davis //
1708334c51SBrooks Davis // THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
1808334c51SBrooks Davis // "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
1908334c51SBrooks Davis // LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
2008334c51SBrooks Davis // A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
2108334c51SBrooks Davis // OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
2208334c51SBrooks Davis // SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
2308334c51SBrooks Davis // LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
2408334c51SBrooks Davis // DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
2508334c51SBrooks Davis // THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
2608334c51SBrooks Davis // (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
2708334c51SBrooks Davis // OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
2808334c51SBrooks Davis 
2908334c51SBrooks Davis #include "utils/sqlite/transaction.hpp"
3008334c51SBrooks Davis 
3108334c51SBrooks Davis #include "utils/format/macros.hpp"
3208334c51SBrooks Davis #include "utils/logging/macros.hpp"
3308334c51SBrooks Davis #include "utils/noncopyable.hpp"
3408334c51SBrooks Davis #include "utils/sanity.hpp"
3508334c51SBrooks Davis #include "utils/sqlite/database.hpp"
3608334c51SBrooks Davis #include "utils/sqlite/exceptions.hpp"
3708334c51SBrooks Davis #include "utils/sqlite/statement.ipp"
3808334c51SBrooks Davis 
3908334c51SBrooks Davis namespace sqlite = utils::sqlite;
4008334c51SBrooks Davis 
4108334c51SBrooks Davis 
4208334c51SBrooks Davis /// Internal implementation for the transaction.
4308334c51SBrooks Davis struct utils::sqlite::transaction::impl : utils::noncopyable {
4408334c51SBrooks Davis     /// The database this transaction belongs to.
4508334c51SBrooks Davis     database& db;
4608334c51SBrooks Davis 
4708334c51SBrooks Davis     /// Possible statuses of a transaction.
4808334c51SBrooks Davis     enum statuses {
4908334c51SBrooks Davis         open_status,
5008334c51SBrooks Davis         committed_status,
5108334c51SBrooks Davis         rolled_back_status,
5208334c51SBrooks Davis     };
5308334c51SBrooks Davis 
5408334c51SBrooks Davis     /// The current status of the transaction.
5508334c51SBrooks Davis     statuses status;
5608334c51SBrooks Davis 
5708334c51SBrooks Davis     /// Constructs a new transaction.
5808334c51SBrooks Davis     ///
5908334c51SBrooks Davis     /// \param db_ The database this transaction belongs to.
6008334c51SBrooks Davis     /// \param status_ The status of the new transaction.
implutils::sqlite::transaction::impl6108334c51SBrooks Davis     impl(database& db_, const statuses status_) :
6208334c51SBrooks Davis         db(db_),
6308334c51SBrooks Davis         status(status_)
6408334c51SBrooks Davis     {
6508334c51SBrooks Davis     }
6608334c51SBrooks Davis 
6708334c51SBrooks Davis     /// Destroys the transaction.
6808334c51SBrooks Davis     ///
6908334c51SBrooks Davis     /// This rolls back the transaction if it is open.
~implutils::sqlite::transaction::impl7008334c51SBrooks Davis     ~impl(void)
7108334c51SBrooks Davis     {
7208334c51SBrooks Davis         if (status == impl::open_status) {
7308334c51SBrooks Davis             try {
7408334c51SBrooks Davis                 rollback();
7508334c51SBrooks Davis             } catch (const sqlite::error& e) {
7608334c51SBrooks Davis                 LW(F("Error while rolling back a transaction: %s") % e.what());
7708334c51SBrooks Davis             }
7808334c51SBrooks Davis         }
7908334c51SBrooks Davis     }
8008334c51SBrooks Davis 
8108334c51SBrooks Davis     /// Commits the transaction.
8208334c51SBrooks Davis     ///
8308334c51SBrooks Davis     /// \throw api_error If there is any problem while committing the
8408334c51SBrooks Davis     ///     transaction.
8508334c51SBrooks Davis     void
commitutils::sqlite::transaction::impl8608334c51SBrooks Davis     commit(void)
8708334c51SBrooks Davis     {
8808334c51SBrooks Davis         PRE(status == impl::open_status);
8908334c51SBrooks Davis         db.exec("COMMIT");
9008334c51SBrooks Davis         status = impl::committed_status;
9108334c51SBrooks Davis     }
9208334c51SBrooks Davis 
9308334c51SBrooks Davis     /// Rolls the transaction back.
9408334c51SBrooks Davis     ///
9508334c51SBrooks Davis     /// \throw api_error If there is any problem while rolling the
9608334c51SBrooks Davis     ///     transaction back.
9708334c51SBrooks Davis     void
rollbackutils::sqlite::transaction::impl9808334c51SBrooks Davis     rollback(void)
9908334c51SBrooks Davis     {
10008334c51SBrooks Davis         PRE(status == impl::open_status);
10108334c51SBrooks Davis         db.exec("ROLLBACK");
10208334c51SBrooks Davis         status = impl::rolled_back_status;
10308334c51SBrooks Davis     }
10408334c51SBrooks Davis };
10508334c51SBrooks Davis 
10608334c51SBrooks Davis 
10708334c51SBrooks Davis /// Initializes a transaction object.
10808334c51SBrooks Davis ///
10908334c51SBrooks Davis /// This is an internal function.  Use database::begin_transaction() to
11008334c51SBrooks Davis /// instantiate one of these objects.
11108334c51SBrooks Davis ///
11208334c51SBrooks Davis /// \param db The database this transaction belongs to.
transaction(database & db)11308334c51SBrooks Davis sqlite::transaction::transaction(database& db) :
11408334c51SBrooks Davis     _pimpl(new impl(db, impl::open_status))
11508334c51SBrooks Davis {
11608334c51SBrooks Davis }
11708334c51SBrooks Davis 
11808334c51SBrooks Davis 
11908334c51SBrooks Davis /// Destructor for the transaction.
~transaction(void)12008334c51SBrooks Davis sqlite::transaction::~transaction(void)
12108334c51SBrooks Davis {
12208334c51SBrooks Davis }
12308334c51SBrooks Davis 
12408334c51SBrooks Davis 
12508334c51SBrooks Davis /// Commits the transaction.
12608334c51SBrooks Davis ///
12708334c51SBrooks Davis /// \throw api_error If there is any problem while committing the transaction.
12808334c51SBrooks Davis void
commit(void)12908334c51SBrooks Davis sqlite::transaction::commit(void)
13008334c51SBrooks Davis {
13108334c51SBrooks Davis     _pimpl->commit();
13208334c51SBrooks Davis }
13308334c51SBrooks Davis 
13408334c51SBrooks Davis 
13508334c51SBrooks Davis /// Rolls the transaction back.
13608334c51SBrooks Davis ///
13708334c51SBrooks Davis /// \throw api_error If there is any problem while rolling the transaction back.
13808334c51SBrooks Davis void
rollback(void)13908334c51SBrooks Davis sqlite::transaction::rollback(void)
14008334c51SBrooks Davis {
14108334c51SBrooks Davis     _pimpl->rollback();
14208334c51SBrooks Davis }
143