Recast/html/_s_q_lite_8hpp_source.html

 #ifndef RECAST_SERVER_SQLITE_H

 #define RECAST_SERVER_SQLITE_H


 #include <sqlite_orm/sqlite_orm.h>

 #include "models/Player.hpp"

 #include "models/User.hpp"


 inline auto create_db() {

     using namespace sqlite_orm;

     return make_storage("db.sqlite",

                         make_table("players",

                                    make_column("id",

                                                &Player::id,

                                                autoincrement(),

                                                primary_key()),

                                    make_column("user_id",

                                                &Player::userId),

                                    make_column("pos_x",

                                                &Player::setPosX,

                                                &Player::getPosX),

                                    make_column("pos_y",

                                                &Player::setPosY,

                                                &Player::getPosY),

                                    make_column("pos_z",

                                                &Player::setPosZ,

                                                &Player::getPosZ)),

                         make_table("users",

                                    make_column("id",

                                                &User::id,

                                                autoincrement(),

                                                primary_key()),

                                    make_column("login",

                                                &User::login,

                                                unique()),

                                    make_column("password",

                                                &User::password),

                                    make_column("player_id",

                                                &User::playerId)));

 }


 class SQLite {

 public:

     SQLite() { storage.sync_schema(); }


     User registerUser(std::string login, std::string password);


     User authUser(std::string login, std::string password);


     void update(Player player);


 private:

     decltype(create_db()) storage = create_db();

 };


 #endif //RECAST_SERVER_SQLITE_H

Player.hpp
Player file.

User::id
int id
Definition: User.hpp:20

Player::setPosY
void setPosY(double y)
Definition: Player.hpp:31

Player::getPosX
const double & getPosX() const
Definition: Player.hpp:28

Player::getPosY
const double & getPosY() const
Definition: Player.hpp:30

create_db
auto create_db()
Definition: SQLite.hpp:19

User.hpp

Player::setPosX
void setPosX(double x)
Definition: Player.hpp:29

User::playerId
int playerId
Definition: User.hpp:21

SQLite::registerUser
User registerUser(std::string login, std::string password)
Definition: SQLite.cpp:17

Player::id
int id
Definition: Player.hpp:23

User::login
std::string login
Definition: User.hpp:22

SQLite
This class helps to easily put or get var from DB. Using sqlite_orm and sqlite.
Definition: SQLite.hpp:55

User::password
std::string password
Definition: User.hpp:23

Player::setPosZ
void setPosZ(double z)
Definition: Player.hpp:33

SQLite::SQLite
SQLite()
Definition: SQLite.hpp:57

Player::getPosZ
const double & getPosZ() const
Definition: Player.hpp:32

SQLite::update
void update(Player player)
Definition: SQLite.cpp:43

User
User - technical data of a player (login, password and other)
Definition: User.hpp:18

SQLite::authUser
User authUser(std::string login, std::string password)
Definition: SQLite.cpp:32

Player::userId
int userId
Definition: Player.hpp:26

Player
Player class. XP, Life points and other.
Definition: Player.hpp:19