47 inline void str_to_sqlite(sqlite3_stmt *s,
int iCol, std::string_view str)
const
49 sqlite3_vrfy(sqlite3_bind_text(s, iCol, str.data(), str.size(), NULL));
59 sqlite3_vrfy(sqlite3_bind_int64(s, iCol, (sqlite3_int64) val));
70 const char* text =
reinterpret_cast<const char*
>(sqlite3_column_text(s, iCol));
71 return text ? std::string_view(text) : std::string_view();
84 const char *data =
reinterpret_cast<const char*
>(sqlite3_column_blob(s, iCol));
86 return std::string_view();
87 size_t len = sqlite3_column_bytes(s, iCol);
88 return std::string_view(data, len);
93 return sqlite3_column_int(s, iCol);
98 return (u32) sqlite3_column_int(s, iCol);
103 return (s64) sqlite3_column_int64(s, iCol);
108 return (u64) sqlite3_column_int64(s, iCol);
113 return (
float) sqlite3_column_double(s, iCol);
123 inline void sqlite3_vrfy(
int s, std::string_view m =
"",
int r = SQLITE_OK)
const
127 msg.append(
": ").append(sqlite3_errmsg(
m_database));
132 inline void sqlite3_vrfy(
const int s,
const int r, std::string_view m =
"")
const
177 void bindPos(sqlite3_stmt *stmt,
const v3s16 &pos,
int index = 1);
230 virtual bool deleteAuth(
const std::string &name);
231 virtual void listNames(std::vector<std::string> &res);
259 virtual void getModKeys(
const std::string &modname, std::vector<std::string> *storage);
260 virtual bool getModEntry(
const std::string &modname,
261 const std::string &key, std::string *value);
262 virtual bool hasModEntry(
const std::string &modname,
const std::string &key);
263 virtual bool setModEntry(
const std::string &modname,
264 const std::string &key,std::string_view value);
265 virtual bool removeModEntry(
const std::string &modname,
const std::string &key);
267 virtual void listMods(std::vector<std::string> *res);
Definition: database-sqlite3.h:222
virtual void listNames(std::vector< std::string > &res)
Definition: database-sqlite3.cpp:734
sqlite3_stmt * m_stmt_list_names
Definition: database-sqlite3.h:245
virtual bool deleteAuth(const std::string &name)
Definition: database-sqlite3.cpp:720
virtual void createDatabase()
Definition: database-sqlite3.cpp:617
sqlite3_stmt * m_stmt_read
Definition: database-sqlite3.h:241
sqlite3_stmt * m_stmt_write
Definition: database-sqlite3.h:242
sqlite3_stmt * m_stmt_delete
Definition: database-sqlite3.h:244
sqlite3_stmt * m_stmt_create
Definition: database-sqlite3.h:243
virtual bool getAuth(const std::string &name, AuthEntry &res)
Definition: database-sqlite3.cpp:658
virtual ~AuthDatabaseSQLite3()
Definition: database-sqlite3.cpp:604
sqlite3_stmt * m_stmt_delete_privs
Definition: database-sqlite3.h:248
virtual void reload()
Definition: database-sqlite3.cpp:744
sqlite3_stmt * m_stmt_read_privs
Definition: database-sqlite3.h:246
virtual bool createAuth(AuthEntry &authEntry)
Definition: database-sqlite3.cpp:698
virtual void initStatements()
Definition: database-sqlite3.cpp:642
virtual void writePrivileges(const AuthEntry &authEntry)
Definition: database-sqlite3.cpp:749
sqlite3_stmt * m_stmt_last_insert_rowid
Definition: database-sqlite3.h:249
sqlite3_stmt * m_stmt_write_privs
Definition: database-sqlite3.h:247
virtual bool saveAuth(const AuthEntry &authEntry)
Definition: database-sqlite3.cpp:681
Definition: database.h:76
Definition: exceptions.h:55
Definition: database-sqlite3.h:32
std::string_view sqlite_to_blob(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:82
void openDatabase()
Definition: database-sqlite3.cpp:139
bool initialized() const
Definition: database-sqlite3.h:39
sqlite3 * m_database
Definition: database-sqlite3.h:141
virtual ~Database_SQLite3()
Definition: database-sqlite3.cpp:189
void str_to_sqlite(sqlite3_stmt *s, int iCol, std::string_view str) const
Definition: database-sqlite3.h:47
std::string_view sqlite_to_string_view(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:68
void sqlite3_vrfy(int s, std::string_view m="", int r=SQLITE_OK) const
Definition: database-sqlite3.h:123
std::string m_dbname
Definition: database-sqlite3.h:149
float sqlite_to_float(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:111
virtual void initStatements()=0
s64 m_busy_handler_data[2]
Definition: database-sqlite3.h:154
void int64_to_sqlite(sqlite3_stmt *s, int iCol, s64 val) const
Definition: database-sqlite3.h:57
void verifyDatabase()
Definition: database-sqlite3.cpp:175
void endSave()
Definition: database-sqlite3.cpp:131
sqlite3_stmt * m_stmt_end
Definition: database-sqlite3.h:152
sqlite3_stmt * m_stmt_begin
Definition: database-sqlite3.h:151
std::string sqlite_to_string(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:75
s32 sqlite_to_int(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:91
u64 sqlite_to_uint64(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:106
s64 sqlite_to_int64(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:101
void double_to_sqlite(sqlite3_stmt *s, int iCol, double val) const
Definition: database-sqlite3.h:62
virtual void createDatabase()=0
bool m_initialized
Definition: database-sqlite3.h:146
u32 sqlite_to_uint(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:96
void sqlite3_vrfy(const int s, const int r, std::string_view m="") const
Definition: database-sqlite3.h:132
static int busyHandler(void *data, int count)
Definition: database-sqlite3.cpp:71
const v3f sqlite_to_v3f(sqlite3_stmt *s, int iCol)
Definition: database-sqlite3.h:116
void int_to_sqlite(sqlite3_stmt *s, int iCol, int val) const
Definition: database-sqlite3.h:52
std::string m_savedir
Definition: database-sqlite3.h:148
void beginSave()
Definition: database-sqlite3.cpp:123
Definition: database.h:30
Definition: database-sqlite3.h:160
sqlite3_stmt * m_stmt_list
Definition: database-sqlite3.h:182
sqlite3_stmt * m_stmt_write
Definition: database-sqlite3.h:181
sqlite3_stmt * m_stmt_delete
Definition: database-sqlite3.h:183
void listAllLoadableBlocks(std::vector< v3s16 > &dst)
Definition: database-sqlite3.cpp:294
void beginSave()
Definition: database-sqlite3.h:170
virtual void createDatabase()
Definition: database-sqlite3.cpp:216
void endSave()
Definition: database-sqlite3.h:171
sqlite3_stmt * m_stmt_read
Definition: database-sqlite3.h:180
void loadBlock(const v3s16 &pos, std::string *block)
Definition: database-sqlite3.cpp:275
virtual ~MapDatabaseSQLite3()
Definition: database-sqlite3.cpp:207
bool deleteBlock(const v3s16 &pos)
Definition: database-sqlite3.cpp:245
virtual void initStatements()
Definition: database-sqlite3.cpp:229
bool saveBlock(const v3s16 &pos, std::string_view data)
Definition: database-sqlite3.cpp:261
void bindPos(sqlite3_stmt *stmt, const v3s16 &pos, int index=1)
Definition: database-sqlite3.cpp:239
Definition: database.h:38
Definition: database-sqlite3.h:253
sqlite3_stmt * m_stmt_set
Definition: database-sqlite3.h:281
virtual void getModEntries(const std::string &modname, StringMap *storage)
Definition: database-sqlite3.cpp:807
virtual bool getModEntry(const std::string &modname, const std::string &key, std::string *value)
Definition: database-sqlite3.cpp:837
sqlite3_stmt * m_stmt_get
Definition: database-sqlite3.h:279
virtual ~ModStorageDatabaseSQLite3()
Definition: database-sqlite3.cpp:767
sqlite3_stmt * m_stmt_has
Definition: database-sqlite3.h:280
virtual bool removeModEntries(const std::string &modname)
Definition: database-sqlite3.cpp:907
sqlite3_stmt * m_stmt_get_all
Definition: database-sqlite3.h:277
sqlite3_stmt * m_stmt_remove_all
Definition: database-sqlite3.h:283
virtual void getModKeys(const std::string &modname, std::vector< std::string > *storage)
Definition: database-sqlite3.cpp:822
sqlite3_stmt * m_stmt_remove
Definition: database-sqlite3.h:282
virtual void initStatements()
Definition: database-sqlite3.cpp:793
virtual void beginSave()
Definition: database-sqlite3.h:269
virtual bool removeModEntry(const std::string &modname, const std::string &key)
Definition: database-sqlite3.cpp:891
sqlite3_stmt * m_stmt_get_keys
Definition: database-sqlite3.h:278
virtual void endSave()
Definition: database-sqlite3.h:270
virtual void createDatabase()
Definition: database-sqlite3.cpp:778
virtual void listMods(std::vector< std::string > *res)
Definition: database-sqlite3.cpp:920
virtual bool hasModEntry(const std::string &modname, const std::string &key)
Definition: database-sqlite3.cpp:857
virtual bool setModEntry(const std::string &modname, const std::string &key, std::string_view value)
Definition: database-sqlite3.cpp:874
Definition: database.h:89
Definition: database-sqlite3.h:187
sqlite3_stmt * m_stmt_player_add_inventory
Definition: database-sqlite3.h:212
sqlite3_stmt * m_stmt_player_load_inventory_items
Definition: database-sqlite3.h:211
bool playerDataExists(const std::string &name)
Definition: database-sqlite3.cpp:422
sqlite3_stmt * m_stmt_player_remove_inventory_items
Definition: database-sqlite3.h:215
bool loadPlayer(RemotePlayer *player, PlayerSAO *sao)
Definition: database-sqlite3.cpp:521
virtual ~PlayerDatabaseSQLite3()
Definition: database-sqlite3.cpp:314
sqlite3_stmt * m_stmt_player_load_inventory
Definition: database-sqlite3.h:210
bool removePlayer(const std::string &name)
Definition: database-sqlite3.cpp:574
virtual void initStatements()
Definition: database-sqlite3.cpp:387
void listPlayers(std::vector< std::string > &res)
Definition: database-sqlite3.cpp:585
sqlite3_stmt * m_stmt_player_metadata_load
Definition: database-sqlite3.h:216
sqlite3_stmt * m_stmt_player_add_inventory_items
Definition: database-sqlite3.h:213
virtual void createDatabase()
Definition: database-sqlite3.cpp:333
sqlite3_stmt * m_stmt_player_remove
Definition: database-sqlite3.h:208
sqlite3_stmt * m_stmt_player_remove_inventory
Definition: database-sqlite3.h:214
sqlite3_stmt * m_stmt_player_list
Definition: database-sqlite3.h:209
sqlite3_stmt * m_stmt_player_update
Definition: database-sqlite3.h:207
sqlite3_stmt * m_stmt_player_load
Definition: database-sqlite3.h:205
sqlite3_stmt * m_stmt_player_metadata_add
Definition: database-sqlite3.h:218
void savePlayer(RemotePlayer *player)
Definition: database-sqlite3.cpp:431
sqlite3_stmt * m_stmt_player_metadata_remove
Definition: database-sqlite3.h:217
sqlite3_stmt * m_stmt_player_add
Definition: database-sqlite3.h:206
Definition: database.h:56
Definition: player_sao.h:71
Definition: remoteplayer.h:40
core::vector3d< s16 > v3s16
Definition: irr_v3d.h:28
core::vector3df v3f
Definition: irr_v3d.h:26
std::unordered_map< std::string, std::string > StringMap
Definition: string.h:78
Definition: database.h:67