DatabaseManager.hpp

Go to the documentation of this file.

#pragma once
 
#include <pqxx/pqxx>
 
class PlayerCharacter;
 
struct Coordinates;
 
struct PlayerTable
{
    int id;
    std::string username;
    std::string password;
    int position_x;
    int position_y;
    int hp;
};
 
class DatabaseManager
{
public:
    DatabaseManager();
 
    ~DatabaseManager() = default;
 
    int createConnection();
 
    PlayerTable loadPlayerDataFromDb(std::string username, std::string password, Coordinates spawnCoordinate);
 
    std::vector<int> loadInventoryDataFromDb(int playerId);
 
    std::vector<int> loadEquipmentDataFromDb(int playerId);
 
    std::vector<std::pair<int, int>> loadSkillDataFromDb(int playerId);
 
    bool savePlayerToDb(std::shared_ptr<PlayerCharacter> player);
 
private:
    pqxx::work getTransaction();
 
    std::unique_ptr<pqxx::connection> pConnectionM;
};