SqlClient.h

Go to the documentation of this file.

#ifndef SPATIAL_TEMPORAL_LEARNING_WORLDLIB_REMOTE_SQL_CLIENT_H_
#define SPATIAL_TEMPORAL_LEARNING_WORLDLIB_REMOTE_SQL_CLIENT_H_

// worldlib
#include "Client.h"

// MySQL
#include <mysql/mysql.h>

namespace rail
{
namespace spatial_temporal_learning
{
namespace worldlib
{
namespace remote
{

class SqlClient : public Client
{
public:
  static const unsigned int DEFAULT_PORT = 3306;

  SqlClient(const SqlClient &client);

  SqlClient(const std::string &host, const uint16_t port, const std::string &user, const std::string &password,
      const std::string &database);

  virtual ~SqlClient();

  const std::string &getUser() const;

  const std::string &getPassword() const;

  const std::string &getDatabase() const;

  bool connected() const;

  virtual bool connect();

  virtual void disconnect();

protected:
  MYSQL_RES *query(const std::string &query) const;

  void printSqlError() const;

private:
  const std::string user_, password_, database_;
  bool connected_;
  MYSQL *connection_;
};

}
}
}
}

#endif