1 ////////////////////////////////////////////////////////////////////////////// 2 // 3 // Copyright (c) 2004-2021 musikcube team 4 // 5 // All rights reserved. 6 // 7 // Redistribution and use in source and binary forms, with or without 8 // modification, are permitted provided that the following conditions are met: 9 // 10 // * Redistributions of source code must retain the above copyright notice, 11 // this list of conditions and the following disclaimer. 12 // 13 // * Redistributions in binary form must reproduce the above copyright 14 // notice, this list of conditions and the following disclaimer in the 15 // documentation and/or other materials provided with the distribution. 16 // 17 // * Neither the name of the author nor the names of other contributors may 18 // be used to endorse or promote products derived from this software 19 // without specific prior written permission. 20 // 21 // THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 22 // AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 23 // IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 24 // ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE 25 // LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 26 // CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 27 // SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 28 // INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 29 // CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 30 // ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 31 // POSSIBILITY OF SUCH DAMAGE. 32 // 33 ////////////////////////////////////////////////////////////////////////////// 34 35 #pragma once 36 37 #include <musikcore/config.h> 38 #include <musikcore/db/Statement.h> 39 #include <musikcore/db/ScopedTransaction.h> 40 41 #include <map> 42 #include <mutex> 43 44 struct sqlite3; 45 struct sqlite3_stmt; 46 47 namespace musik { namespace core { namespace db { 48 49 typedef enum { 50 Okay = 0, 51 Row = 100, 52 Done = 101, 53 Error = 1 54 } ReturnCode; 55 56 class Connection { 57 public: 58 DELETE_COPY_AND_ASSIGNMENT_DEFAULTS(Connection) 59 60 Connection() noexcept; 61 ~Connection(); 62 63 int Open(const std::string &database, unsigned int options = 0, unsigned int cache = 0); 64 int Close() noexcept; 65 int Execute(const char* sql); 66 67 int64_t LastInsertedId() noexcept; 68 69 int LastModifiedRowCount() noexcept; 70 71 void Interrupt(); 72 void Checkpoint() noexcept; 73 74 private: 75 void Initialize(unsigned int cache); 76 void UpdateReferenceCount(bool init); 77 int StepStatement(sqlite3_stmt *stmt) noexcept; 78 79 friend class Statement; 80 friend class ScopedTransaction; 81 82 int transactionCounter; 83 sqlite3 *connection; 84 std::mutex mutex; 85 }; 86 87 } } } 88 89