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