41 inline void str_to_sqlite(sqlite3_stmt *s,
int iCol, std::string_view str)
const
43 sqlite3_vrfy(sqlite3_bind_text(s, iCol, str.data(), str.size(), NULL));
46 inline void blob_to_sqlite(sqlite3_stmt *s,
int iCol, std::string_view str)
const
48 sqlite3_vrfy(sqlite3_bind_blob(s, iCol, str.data(), str.size(), NULL));
58 sqlite3_vrfy(sqlite3_bind_int64(s, iCol, (sqlite3_int64) val));
69 const char* text =
reinterpret_cast<const char*
>(sqlite3_column_text(s, iCol));
70 return text ? std::string_view(text) : std::string_view();
83 const char *data =
reinterpret_cast<const char*
>(sqlite3_column_blob(s, iCol));
85 return std::string_view();
86 size_t len = sqlite3_column_bytes(s, iCol);
87 return std::string_view(data, len);
92 return sqlite3_column_int(s, iCol);
97 return (u32) sqlite3_column_int(s, iCol);
102 return (s64) sqlite3_column_int64(s, iCol);
107 return (u64) sqlite3_column_int64(s, iCol);
112 return (
float) sqlite3_column_double(s, iCol);
122 inline void sqlite3_vrfy(
int s, std::string_view m =
"",
int r = SQLITE_OK)
const
133 inline void sqlite3_vrfy(
const int s,
const int r, std::string_view m =
"")
const
176#define PARENT_CLASS_FUNCS \
177 void beginSave() { Database_SQLite3::beginSave(); } \
178 void endSave() { Database_SQLite3::endSave(); } \
179 void verifyDatabase() { Database_SQLite3::verifyDatabase(); }
201 int bindPos(sqlite3_stmt *stmt,
v3s16 pos,
int index = 1);
257 virtual bool deleteAuth(
const std::string &name);
258 virtual void listNames(std::vector<std::string> &res);
288 virtual void getModKeys(
const std::string &modname, std::vector<std::string> *storage);
289 virtual bool getModEntry(
const std::string &modname,
290 const std::string &key, std::string *value);
291 virtual bool hasModEntry(
const std::string &modname,
const std::string &key);
292 virtual bool setModEntry(
const std::string &modname,
293 const std::string &key,std::string_view value);
294 virtual bool removeModEntry(
const std::string &modname,
const std::string &key);
296 virtual void listMods(std::vector<std::string> *res);
315#undef PARENT_CLASS_FUNCS
virtual void listNames(std::vector< std::string > &res)
Definition database-sqlite3.cpp:784
sqlite3_stmt * m_stmt_list_names
Definition database-sqlite3.h:274
virtual bool deleteAuth(const std::string &name)
Definition database-sqlite3.cpp:770
virtual void createDatabase()
Definition database-sqlite3.cpp:666
sqlite3_stmt * m_stmt_read
Definition database-sqlite3.h:270
sqlite3_stmt * m_stmt_write
Definition database-sqlite3.h:271
sqlite3_stmt * m_stmt_delete
Definition database-sqlite3.h:273
sqlite3_stmt * m_stmt_create
Definition database-sqlite3.h:272
virtual bool getAuth(const std::string &name, AuthEntry &res)
Definition database-sqlite3.cpp:707
AuthDatabaseSQLite3(const std::string &savedir)
Definition database-sqlite3.cpp:648
sqlite3_stmt * m_stmt_delete_privs
Definition database-sqlite3.h:277
virtual void reload()
Definition database-sqlite3.cpp:794
sqlite3_stmt * m_stmt_read_privs
Definition database-sqlite3.h:275
virtual bool createAuth(AuthEntry &authEntry)
Definition database-sqlite3.cpp:748
virtual void initStatements()
Definition database-sqlite3.cpp:691
virtual void writePrivileges(const AuthEntry &authEntry)
Definition database-sqlite3.cpp:799
sqlite3_stmt * m_stmt_last_insert_rowid
Definition database-sqlite3.h:278
sqlite3_stmt * m_stmt_write_privs
Definition database-sqlite3.h:276
virtual bool saveAuth(const AuthEntry &authEntry)
Definition database-sqlite3.cpp:731
DatabaseException(const std::string &s)
Definition exceptions.h:48
bool checkColumn(const char *table, const char *column)
Definition database-sqlite3.cpp:181
std::string_view sqlite_to_blob(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:81
void openDatabase()
Definition database-sqlite3.cpp:110
sqlite3 * m_database
Definition database-sqlite3.h:156
void beginSave() override
Definition database-sqlite3.cpp:94
void str_to_sqlite(sqlite3_stmt *s, int iCol, std::string_view str) const
Definition database-sqlite3.h:41
bool initialized() const override
Definition database-sqlite3.h:25
std::string_view sqlite_to_string_view(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:67
void sqlite3_vrfy(int s, std::string_view m="", int r=SQLITE_OK) const
Definition database-sqlite3.h:122
float sqlite_to_float(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:110
virtual void initStatements()=0
void int64_to_sqlite(sqlite3_stmt *s, int iCol, s64 val) const
Definition database-sqlite3.h:56
bool checkTable(const char *table)
Definition database-sqlite3.cpp:163
const std::string m_dbname
Definition database-sqlite3.h:165
void blob_to_sqlite(sqlite3_stmt *s, int iCol, std::string_view str) const
Definition database-sqlite3.h:46
sqlite3_stmt * m_stmt_end
Definition database-sqlite3.h:168
sqlite3_stmt * m_stmt_begin
Definition database-sqlite3.h:167
std::string sqlite_to_string(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:74
s32 sqlite_to_int(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:90
u64 sqlite_to_uint64(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:105
s64 sqlite_to_int64(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:100
void double_to_sqlite(sqlite3_stmt *s, int iCol, double val) const
Definition database-sqlite3.h:61
virtual void createDatabase()=0
bool m_initialized
Definition database-sqlite3.h:162
Database_SQLite3(const std::string &savedir, const std::string &dbname)
Definition database-sqlite3.cpp:88
u32 sqlite_to_uint(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:95
void verifyDatabase() override
Definition database-sqlite3.cpp:149
void sqlite3_vrfy(const int s, const int r, std::string_view m="") const
Definition database-sqlite3.h:133
const std::string m_savedir
Definition database-sqlite3.h:164
static int busyHandler(void *data, int count)
Definition database-sqlite3.cpp:46
const v3f sqlite_to_v3f(sqlite3_stmt *s, int iCol)
Definition database-sqlite3.h:115
bool sqlite3_vrfy_step(int s, std::string_view m="") const
Helper for verifying result of sqlite3_step().
Definition database-sqlite3.h:142
void int_to_sqlite(sqlite3_stmt *s, int iCol, int val) const
Definition database-sqlite3.h:51
void endSave() override
Definition database-sqlite3.cpp:102
u64 m_busy_handler_data[2]
Definition database-sqlite3.h:170
sqlite3_stmt * m_stmt_list
Definition database-sqlite3.h:207
sqlite3_stmt * m_stmt_write
Definition database-sqlite3.h:206
sqlite3_stmt * m_stmt_delete
Definition database-sqlite3.h:208
void listAllLoadableBlocks(std::vector< v3s16 > &dst)
Definition database-sqlite3.cpp:331
virtual void createDatabase()
Definition database-sqlite3.cpp:227
sqlite3_stmt * m_stmt_read
Definition database-sqlite3.h:205
void loadBlock(const v3s16 &pos, std::string *block)
Definition database-sqlite3.cpp:313
MapDatabaseSQLite3(const std::string &savedir)
Definition database-sqlite3.cpp:212
bool deleteBlock(const v3s16 &pos)
Definition database-sqlite3.cpp:284
virtual void initStatements()
Definition database-sqlite3.cpp:251
int bindPos(sqlite3_stmt *stmt, v3s16 pos, int index=1)
Bind block position into statement at column index.
Definition database-sqlite3.cpp:271
bool saveBlock(const v3s16 &pos, std::string_view data)
Definition database-sqlite3.cpp:300
bool m_new_format
Definition database-sqlite3.h:203
ModStorageDatabaseSQLite3(const std::string &savedir)
Definition database-sqlite3.cpp:812
sqlite3_stmt * m_stmt_set
Definition database-sqlite3.h:310
virtual void getModEntries(const std::string &modname, StringMap *storage)
Definition database-sqlite3.cpp:859
virtual bool getModEntry(const std::string &modname, const std::string &key, std::string *value)
Definition database-sqlite3.cpp:889
sqlite3_stmt * m_stmt_get
Definition database-sqlite3.h:308
sqlite3_stmt * m_stmt_get_mods
Definition database-sqlite3.h:305
sqlite3_stmt * m_stmt_has
Definition database-sqlite3.h:309
virtual bool removeModEntries(const std::string &modname)
Definition database-sqlite3.cpp:951
sqlite3_stmt * m_stmt_get_all
Definition database-sqlite3.h:306
sqlite3_stmt * m_stmt_remove_all
Definition database-sqlite3.h:312
virtual void getModKeys(const std::string &modname, std::vector< std::string > *storage)
Definition database-sqlite3.cpp:874
sqlite3_stmt * m_stmt_remove
Definition database-sqlite3.h:311
virtual void initStatements()
Definition database-sqlite3.cpp:844
virtual bool removeModEntry(const std::string &modname, const std::string &key)
Definition database-sqlite3.cpp:936
sqlite3_stmt * m_stmt_get_keys
Definition database-sqlite3.h:307
virtual void createDatabase()
Definition database-sqlite3.cpp:829
virtual void listMods(std::vector< std::string > *res)
Definition database-sqlite3.cpp:964
virtual bool hasModEntry(const std::string &modname, const std::string &key)
Definition database-sqlite3.cpp:908
virtual bool setModEntry(const std::string &modname, const std::string &key, std::string_view value)
Definition database-sqlite3.cpp:921
sqlite3_stmt * m_stmt_player_add_inventory
Definition database-sqlite3.h:239
sqlite3_stmt * m_stmt_player_load_inventory_items
Definition database-sqlite3.h:238
bool playerDataExists(const std::string &name)
Definition database-sqlite3.cpp:470
sqlite3_stmt * m_stmt_player_remove_inventory_items
Definition database-sqlite3.h:242
bool loadPlayer(RemotePlayer *player, PlayerSAO *sao)
Definition database-sqlite3.cpp:569
sqlite3_stmt * m_stmt_player_load_inventory
Definition database-sqlite3.h:237
bool removePlayer(const std::string &name)
Definition database-sqlite3.cpp:623
virtual void initStatements()
Definition database-sqlite3.cpp:436
void listPlayers(std::vector< std::string > &res)
Definition database-sqlite3.cpp:634
sqlite3_stmt * m_stmt_player_metadata_load
Definition database-sqlite3.h:243
sqlite3_stmt * m_stmt_player_add_inventory_items
Definition database-sqlite3.h:240
virtual void createDatabase()
Definition database-sqlite3.cpp:379
sqlite3_stmt * m_stmt_player_remove
Definition database-sqlite3.h:235
sqlite3_stmt * m_stmt_player_remove_inventory
Definition database-sqlite3.h:241
sqlite3_stmt * m_stmt_player_list
Definition database-sqlite3.h:236
sqlite3_stmt * m_stmt_player_update
Definition database-sqlite3.h:234
sqlite3_stmt * m_stmt_player_load
Definition database-sqlite3.h:232
sqlite3_stmt * m_stmt_player_metadata_add
Definition database-sqlite3.h:245
void savePlayer(RemotePlayer *player)
Definition database-sqlite3.cpp:479
sqlite3_stmt * m_stmt_player_metadata_remove
Definition database-sqlite3.h:244
PlayerDatabaseSQLite3(const std::string &savedir)
Definition database-sqlite3.cpp:354
sqlite3_stmt * m_stmt_player_add
Definition database-sqlite3.h:233
Definition player_sao.h:58
Definition remoteplayer.h:28
#define PARENT_CLASS_FUNCS
Definition database-sqlite3.h:176
core::vector3d< s16 > v3s16
Definition irr_v3d.h:13
core::vector3df v3f
Definition irr_v3d.h:11
static std::vector< table_key > table
Definition keycode.cpp:34
std::unordered_map< std::string, std::string > StringMap
Definition string.h:69