DBManager.hpp

Go to the documentation of this file.

#ifndef __OPENTREP_CMD_DBMANAGER_HPP
#define __OPENTREP_CMD_DBMANAGER_HPP

// //////////////////////////////////////////////////////////////////////
// Import section
// //////////////////////////////////////////////////////////////////////
// OpenTrep
#include <opentrep/OPENTREP_Types.hpp>
#include <opentrep/LocationKey.hpp>
#include <opentrep/bom/PlaceList.hpp>

// Forward declarations
namespace soci {
  class session;
  class statement;
}

namespace OPENTREP {

  // Forward declarations
  struct PlaceKey;


  class DBManager {
  public:
    static NbOfDBEntries_T buildSQLDB (const PORFilePath_T&,
                                       const SQLiteDBFilePath_T&);

    static void updatePlaceInDB (soci::session&, const Place&);

    static bool retrievePlace (soci::session&, const LocationKey&, Place&);

    static bool retrieveClosestPlaces (soci::session&, const double& iLatitude,
                                       const double& iLongitude,
                                       PlaceOrderedList_T&);

    
  public:
    static void prepareSelectAllStatement (soci::session&, soci::statement&,
                                           Place&);
    static void prepareSelectFromCodeStatement (soci::session&,
                                                soci::statement&, Place&);

    static void prepareSelectFromCoordStatement (soci::session&,
                                                 soci::statement&,
                                                 const double& iLatitude,
                                                 const double& iLongitude);

    static bool iterateOnStatement (soci::statement&, Place&);

    
  private:
    static void prepareSelectOnPlaceCodeStatement(soci::session&,
                                                  soci::statement&,
                                                  const std::string& iPlaceCode,
                                                  const std::string& iIcaoCode,
                                                  const GeonamesID_T&, Place&);
    
    static void prepareSelectOnDocIDStatement (soci::session&, soci::statement&,
                                               const XapianDocID_T&, Place&);


  private:
    DBManager() {}
    DBManager (const DBManager&) {}
    ~DBManager() {}
  };
  
}
#endif // __OPENTREP_CMD_DBMANAGER_HPP