Home | History | Annotate | Line # | Download | only in sqlite
      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