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