#include <database-sqlite3.h>

Inheritance diagram for PlayerDatabaseSQLite3:

Collaboration diagram for PlayerDatabaseSQLite3:

Public Member Functions
	PlayerDatabaseSQLite3 (const std::string &savedir)
virtual	~PlayerDatabaseSQLite3 ()
void	savePlayer (RemotePlayer *player)
bool	loadPlayer (RemotePlayer player, PlayerSAO sao)
bool	removePlayer (const std::string &name)
void	listPlayers (std::vector< std::string > &res)
Public Member Functions inherited from PlayerDatabase
virtual	~PlayerDatabase ()=default

Protected Member Functions
virtual void	createDatabase ()
virtual void	initStatements ()

Private Member Functions
bool	playerDataExists (const std::string &name)
Private Member Functions inherited from Database_SQLite3
virtual	~Database_SQLite3 ()
void	beginSave () override
void	endSave () override
bool	initialized () const override
void	verifyDatabase () override
	Database_SQLite3 (const std::string &savedir, const std::string &dbname)
bool	checkTable (const char *table)
bool	checkColumn (const char table, const char column)
void	str_to_sqlite (sqlite3_stmt *s, int iCol, std::string_view str) const
void	blob_to_sqlite (sqlite3_stmt *s, int iCol, std::string_view str) const
void	int_to_sqlite (sqlite3_stmt *s, int iCol, int val) const
void	int64_to_sqlite (sqlite3_stmt *s, int iCol, s64 val) const
void	double_to_sqlite (sqlite3_stmt *s, int iCol, double val) const
std::string_view	sqlite_to_string_view (sqlite3_stmt *s, int iCol)
std::string	sqlite_to_string (sqlite3_stmt *s, int iCol)
std::string_view	sqlite_to_blob (sqlite3_stmt *s, int iCol)
s32	sqlite_to_int (sqlite3_stmt *s, int iCol)
u32	sqlite_to_uint (sqlite3_stmt *s, int iCol)
s64	sqlite_to_int64 (sqlite3_stmt *s, int iCol)
u64	sqlite_to_uint64 (sqlite3_stmt *s, int iCol)
float	sqlite_to_float (sqlite3_stmt *s, int iCol)
const v3f	sqlite_to_v3f (sqlite3_stmt *s, int iCol)
void	sqlite3_vrfy (int s, std::string_view m="", int r=SQLITE_OK) const
void	sqlite3_vrfy (const int s, const int r, std::string_view m="") const

Private Attributes
sqlite3_stmt *	m_stmt_player_load = nullptr
sqlite3_stmt *	m_stmt_player_add = nullptr
sqlite3_stmt *	m_stmt_player_update = nullptr
sqlite3_stmt *	m_stmt_player_remove = nullptr
sqlite3_stmt *	m_stmt_player_list = nullptr
sqlite3_stmt *	m_stmt_player_load_inventory = nullptr
sqlite3_stmt *	m_stmt_player_load_inventory_items = nullptr
sqlite3_stmt *	m_stmt_player_add_inventory = nullptr
sqlite3_stmt *	m_stmt_player_add_inventory_items = nullptr
sqlite3_stmt *	m_stmt_player_remove_inventory = nullptr
sqlite3_stmt *	m_stmt_player_remove_inventory_items = nullptr
sqlite3_stmt *	m_stmt_player_metadata_load = nullptr
sqlite3_stmt *	m_stmt_player_metadata_remove = nullptr
sqlite3_stmt *	m_stmt_player_metadata_add = nullptr
Private Attributes inherited from Database_SQLite3
sqlite3 *	m_database = nullptr

Constructor & Destructor Documentation

◆ PlayerDatabaseSQLite3()

PlayerDatabaseSQLite3::PlayerDatabaseSQLite3 ( const std::string & savedir )

References Database_SQLite3::Database_SQLite3().

Here is the call graph for this function:

◆ ~PlayerDatabaseSQLite3()

PlayerDatabaseSQLite3::~PlayerDatabaseSQLite3 ( )

virtual

References FINALIZE_STATEMENT.

Member Function Documentation

◆ createDatabase()

void PlayerDatabaseSQLite3::createDatabase ( )

protectedvirtual

Implements Database_SQLite3.

References Database_SQLite3::m_database, and SQLOK.

◆ initStatements()

void PlayerDatabaseSQLite3::initStatements ( )

protectedvirtual

Implements Database_SQLite3.

References PREPARE_STATEMENT.

◆ listPlayers()

void PlayerDatabaseSQLite3::listPlayers ( std::vector< std::string > & res )

virtual

Implements PlayerDatabase.

References m_stmt_player_list, Database_SQLite3::sqlite_to_string_view(), and Database_SQLite3::verifyDatabase().

Here is the call graph for this function:

◆ loadPlayer()

bool PlayerDatabaseSQLite3::loadPlayer	(	RemotePlayer *	player,
		PlayerSAO *	sao )

virtual

Implements PlayerDatabase.

References Inventory::addList(), InventoryList::changeItem(), ItemStack::deSerialize(), PlayerSAO::getMeta(), Player::getName(), PlayerSAO::getPlayer(), Database_SQLite3::int_to_sqlite(), Player::inventory, m_stmt_player_load, m_stmt_player_load_inventory, m_stmt_player_load_inventory_items, m_stmt_player_metadata_load, MYMIN, PlayerSAO::setBasePosition(), PlayerSAO::setBreath(), PlayerSAO::setHPRaw(), PlayerSAO::setLookPitch(), SimpleMetadata::setModified(), PlayerSAO::setPlayerYaw(), SimpleMetadata::setString(), InventoryList::setWidth(), Database_SQLite3::sqlite_to_float(), Database_SQLite3::sqlite_to_int(), Database_SQLite3::sqlite_to_string(), Database_SQLite3::sqlite_to_string_view(), Database_SQLite3::sqlite_to_uint(), Database_SQLite3::sqlite_to_v3f(), Database_SQLite3::str_to_sqlite(), U16_MAX, and Database_SQLite3::verifyDatabase().

Here is the call graph for this function:

◆ playerDataExists()

bool PlayerDatabaseSQLite3::playerDataExists ( const std::string & name )

private

References m_stmt_player_load, Database_SQLite3::str_to_sqlite(), and Database_SQLite3::verifyDatabase().

Referenced by removePlayer(), and savePlayer().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ removePlayer()

bool PlayerDatabaseSQLite3::removePlayer ( const std::string & name )

virtual

Implements PlayerDatabase.

References m_stmt_player_remove, playerDataExists(), Database_SQLite3::sqlite3_vrfy(), and Database_SQLite3::str_to_sqlite().

Here is the call graph for this function:

◆ savePlayer()

void PlayerDatabaseSQLite3::savePlayer ( RemotePlayer * player )

virtual

Implements PlayerDatabase.

References Database_SQLite3::beginSave(), Database_SQLite3::double_to_sqlite(), Database_SQLite3::endSave(), ServerActiveObject::getBasePosition(), PlayerSAO::getBreath(), UnitSAO::getHP(), PlayerSAO::getInventory(), InventoryList::getItem(), Inventory::getLists(), PlayerSAO::getLookPitch(), PlayerSAO::getMeta(), InventoryList::getName(), Player::getName(), RemotePlayer::getPlayerSAO(), UnitSAO::getRotation(), InventoryList::getSize(), SimpleMetadata::getStrings(), InventoryList::getWidth(), Database_SQLite3::int64_to_sqlite(), Database_SQLite3::int_to_sqlite(), m_stmt_player_add, m_stmt_player_add_inventory, m_stmt_player_add_inventory_items, m_stmt_player_metadata_add, m_stmt_player_metadata_remove, m_stmt_player_remove_inventory, m_stmt_player_remove_inventory_items, m_stmt_player_update, RemotePlayer::onSuccessfulSave(), playerDataExists(), sanity_check, ItemStack::serialize(), Database_SQLite3::sqlite3_vrfy(), and Database_SQLite3::str_to_sqlite().

Here is the call graph for this function:

Member Data Documentation

◆ m_stmt_player_add

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_add = nullptr

private

Referenced by savePlayer().

◆ m_stmt_player_add_inventory

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_add_inventory = nullptr

private

Referenced by savePlayer().

◆ m_stmt_player_add_inventory_items

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_add_inventory_items = nullptr

private

Referenced by savePlayer().

◆ m_stmt_player_list

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_list = nullptr

private

Referenced by listPlayers().

◆ m_stmt_player_load

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_load = nullptr

private

Referenced by loadPlayer(), and playerDataExists().

◆ m_stmt_player_load_inventory

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_load_inventory = nullptr

private

Referenced by loadPlayer().

◆ m_stmt_player_load_inventory_items

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_load_inventory_items = nullptr

private

Referenced by loadPlayer().

◆ m_stmt_player_metadata_add

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_metadata_add = nullptr

private

Referenced by savePlayer().

◆ m_stmt_player_metadata_load

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_metadata_load = nullptr

private

Referenced by loadPlayer().

◆ m_stmt_player_metadata_remove

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_metadata_remove = nullptr

private

Referenced by savePlayer().

◆ m_stmt_player_remove

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_remove = nullptr

private

Referenced by removePlayer().

◆ m_stmt_player_remove_inventory

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_remove_inventory = nullptr

private

Referenced by savePlayer().

◆ m_stmt_player_remove_inventory_items

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_remove_inventory_items = nullptr

private

Referenced by savePlayer().

◆ m_stmt_player_update

sqlite3_stmt* PlayerDatabaseSQLite3::m_stmt_player_update = nullptr

private

Referenced by savePlayer().

The documentation for this class was generated from the following files:

database/database-sqlite3.h
database/database-sqlite3.cpp

Public Member Functions

Protected Member Functions

Private Member Functions

Private Attributes

Constructor & Destructor Documentation

◆ PlayerDatabaseSQLite3()

◆ ~PlayerDatabaseSQLite3()

Member Function Documentation

◆ createDatabase()

◆ initStatements()

◆ listPlayers()

◆ loadPlayer()

◆ playerDataExists()

◆ removePlayer()

◆ savePlayer()

Member Data Documentation

◆ m_stmt_player_add

◆ m_stmt_player_add_inventory

◆ m_stmt_player_add_inventory_items

◆ m_stmt_player_list

◆ m_stmt_player_load

◆ m_stmt_player_load_inventory

◆ m_stmt_player_load_inventory_items

◆ m_stmt_player_metadata_add

◆ m_stmt_player_metadata_load

◆ m_stmt_player_metadata_remove

◆ m_stmt_player_remove

◆ m_stmt_player_remove_inventory

◆ m_stmt_player_remove_inventory_items

◆ m_stmt_player_update