3 Copyright (C) 2013 celeron55, Perttu Ahola <celeron55@gmail.com>
5 This program is free software; you can redistribute it and/or modify
6 it under the terms of the GNU Lesser General Public License as published by
7 the Free Software Foundation; either version 2.1 of the License, or
8 (at your option) any later version.
10 This program is distributed in the hope that it will be useful,
11 but WITHOUT ANY WARRANTY; without even the implied warranty of
12 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 GNU Lesser General Public License for more details.
15 You should have received a copy of the GNU Lesser General Public License along
16 with this program; if not, write to the Free Software Foundation, Inc.,
17 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
25 #include "exceptions.h"
31 class Database_SQLite3 : public Database
34 virtual ~Database_SQLite3();
39 bool initialized() const { return m_initialized; }
42 Database_SQLite3(const std::string &savedir, const std::string &dbname);
44 // Open and initialize the database if needed
45 void verifyDatabase();
48 inline void str_to_sqlite(sqlite3_stmt *s, int iCol, const std::string &str) const
50 sqlite3_vrfy(sqlite3_bind_text(s, iCol, str.c_str(), str.size(), NULL));
53 inline void str_to_sqlite(sqlite3_stmt *s, int iCol, const char *str) const
55 sqlite3_vrfy(sqlite3_bind_text(s, iCol, str, strlen(str), NULL));
58 inline void int_to_sqlite(sqlite3_stmt *s, int iCol, int val) const
60 sqlite3_vrfy(sqlite3_bind_int(s, iCol, val));
63 inline void int64_to_sqlite(sqlite3_stmt *s, int iCol, s64 val) const
65 sqlite3_vrfy(sqlite3_bind_int64(s, iCol, (sqlite3_int64)val));
68 inline void double_to_sqlite(sqlite3_stmt *s, int iCol, double val) const
70 sqlite3_vrfy(sqlite3_bind_double(s, iCol, val));
73 inline std::string sqlite_to_string(sqlite3_stmt *s, int iCol)
75 const char *text = reinterpret_cast<const char *>(
76 sqlite3_column_text(s, iCol));
77 return std::string(text ? text : "");
80 inline s32 sqlite_to_int(sqlite3_stmt *s, int iCol)
82 return sqlite3_column_int(s, iCol);
85 inline u32 sqlite_to_uint(sqlite3_stmt *s, int iCol)
87 return (u32)sqlite3_column_int(s, iCol);
90 inline s64 sqlite_to_int64(sqlite3_stmt *s, int iCol)
92 return (s64)sqlite3_column_int64(s, iCol);
95 inline u64 sqlite_to_uint64(sqlite3_stmt *s, int iCol)
97 return (u64)sqlite3_column_int64(s, iCol);
100 inline float sqlite_to_float(sqlite3_stmt *s, int iCol)
102 return (float)sqlite3_column_double(s, iCol);
105 inline const v3f sqlite_to_v3f(sqlite3_stmt *s, int iCol)
107 return v3f(sqlite_to_float(s, iCol), sqlite_to_float(s, iCol + 1),
108 sqlite_to_float(s, iCol + 2));
111 // Query verifiers helpers
112 inline void sqlite3_vrfy(
113 int s, const std::string &m = "", int r = SQLITE_OK) const
116 throw DatabaseException(m + ": " + sqlite3_errmsg(m_database));
119 inline void sqlite3_vrfy(
120 const int s, const int r, const std::string &m = "") const
122 sqlite3_vrfy(s, m, r);
125 // Create the database structure
126 virtual void createDatabase() = 0;
127 virtual void initStatements() = 0;
129 sqlite3 *m_database = nullptr;
135 bool m_initialized = false;
137 std::string m_savedir = "";
138 std::string m_dbname = "";
140 sqlite3_stmt *m_stmt_begin = nullptr;
141 sqlite3_stmt *m_stmt_end = nullptr;
143 s64 m_busy_handler_data[2];
145 static int busyHandler(void *data, int count);
148 class MapDatabaseSQLite3 : private Database_SQLite3, public MapDatabase
151 MapDatabaseSQLite3(const std::string &savedir);
152 virtual ~MapDatabaseSQLite3();
154 bool saveBlock(const v3s16 &pos, const std::string &data);
155 void loadBlock(const v3s16 &pos, std::string *block);
156 bool deleteBlock(const v3s16 &pos);
157 void listAllLoadableBlocks(std::vector<v3s16> &dst);
159 void beginSave() { Database_SQLite3::beginSave(); }
160 void endSave() { Database_SQLite3::endSave(); }
163 virtual void createDatabase();
164 virtual void initStatements();
167 void bindPos(sqlite3_stmt *stmt, const v3s16 &pos, int index = 1);
170 sqlite3_stmt *m_stmt_read = nullptr;
171 sqlite3_stmt *m_stmt_write = nullptr;
172 sqlite3_stmt *m_stmt_list = nullptr;
173 sqlite3_stmt *m_stmt_delete = nullptr;
176 class PlayerDatabaseSQLite3 : private Database_SQLite3, public PlayerDatabase
179 PlayerDatabaseSQLite3(const std::string &savedir);
180 virtual ~PlayerDatabaseSQLite3();
182 void savePlayer(RemotePlayer *player);
183 bool loadPlayer(RemotePlayer *player, PlayerSAO *sao);
184 bool removePlayer(const std::string &name);
185 void listPlayers(std::vector<std::string> &res);
188 virtual void createDatabase();
189 virtual void initStatements();
192 bool playerDataExists(const std::string &name);
195 sqlite3_stmt *m_stmt_player_load = nullptr;
196 sqlite3_stmt *m_stmt_player_add = nullptr;
197 sqlite3_stmt *m_stmt_player_update = nullptr;
198 sqlite3_stmt *m_stmt_player_remove = nullptr;
199 sqlite3_stmt *m_stmt_player_list = nullptr;
200 sqlite3_stmt *m_stmt_player_load_inventory = nullptr;
201 sqlite3_stmt *m_stmt_player_load_inventory_items = nullptr;
202 sqlite3_stmt *m_stmt_player_add_inventory = nullptr;
203 sqlite3_stmt *m_stmt_player_add_inventory_items = nullptr;
204 sqlite3_stmt *m_stmt_player_remove_inventory = nullptr;
205 sqlite3_stmt *m_stmt_player_remove_inventory_items = nullptr;
206 sqlite3_stmt *m_stmt_player_metadata_load = nullptr;
207 sqlite3_stmt *m_stmt_player_metadata_remove = nullptr;
208 sqlite3_stmt *m_stmt_player_metadata_add = nullptr;
211 class AuthDatabaseSQLite3 : private Database_SQLite3, public AuthDatabase
214 AuthDatabaseSQLite3(const std::string &savedir);
215 virtual ~AuthDatabaseSQLite3();
217 virtual bool getAuth(const std::string &name, AuthEntry &res);
218 virtual bool saveAuth(const AuthEntry &authEntry);
219 virtual bool createAuth(AuthEntry &authEntry);
220 virtual bool deleteAuth(const std::string &name);
221 virtual void listNames(std::vector<std::string> &res);
222 virtual void reload();
225 virtual void createDatabase();
226 virtual void initStatements();
229 virtual void writePrivileges(const AuthEntry &authEntry);
231 sqlite3_stmt *m_stmt_read = nullptr;
232 sqlite3_stmt *m_stmt_write = nullptr;
233 sqlite3_stmt *m_stmt_create = nullptr;
234 sqlite3_stmt *m_stmt_delete = nullptr;
235 sqlite3_stmt *m_stmt_list_names = nullptr;
236 sqlite3_stmt *m_stmt_read_privs = nullptr;
237 sqlite3_stmt *m_stmt_write_privs = nullptr;
238 sqlite3_stmt *m_stmt_delete_privs = nullptr;
239 sqlite3_stmt *m_stmt_last_insert_rowid = nullptr;