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/Location.hpp>
#include <opentrep/DBType.hpp>
#include <opentrep/bom/PlaceList.hpp>
 
// Forward declarations
namespace soci {
  class session;
  class statement;
}
 
namespace OPENTREP {
 
  // Forward declarations
  struct PlaceKey;
 

  class DBManager {
  public:
    static bool createSQLDBUser (const DBType&, const SQLDBConnectionString_T&,
                                 const DeploymentNumber_T&);

    static soci::session* initSQLDBSession (const DBType&,
                                            const SQLDBConnectionString_T&);
 

    static void terminateSQLDBSession (const DBType&,
                                       const SQLDBConnectionString_T&,
                                       soci::session&);

    static void createSQLDBTables (soci::session&);

    static void createSQLDBIndexes (soci::session&);

    static NbOfDBEntries_T displayCount (soci::session&);

    static NbOfDBEntries_T displayAll (soci::session&);

    static NbOfDBEntries_T getPORByIATACode (soci::session&, const IATACode_T&,
                                             LocationList_T&,
                                             const bool iUniqueEntry);

    static NbOfDBEntries_T getPORByICAOCode (soci::session&, const ICAOCode_T&,
                                             LocationList_T&);

    static NbOfDBEntries_T getPORByFAACode (soci::session&, const FAACode_T&,
                                            LocationList_T&);

    static NbOfDBEntries_T getPORByUNLOCode (soci::session&, const UNLOCode_T&,
                                             LocationList_T&,
                                             const bool iUniqueEntry);

    static NbOfDBEntries_T getPORByUICCode (soci::session&, const UICCode_T&,
                                            LocationList_T&);

    static NbOfDBEntries_T getPORByGeonameID (soci::session&,
                                              const GeonamesID_T&,
                                              LocationList_T&);

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

    static void updatePlaceInDB (soci::session&, const Place&);
 
    
  public:
    static std::string prepareSelectAllBlobStatement (soci::session&,
                                                      soci::statement&);

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

    static bool iterateOnStatement (soci::statement&, const std::string&);
 
    
  private:
    static void
    prepareSelectBlobOnIataCodeStatement (soci::session&, soci::statement&,
                                          const std::string& iIataCode,
                                          std::string& ioSerialisedPlaceStr);
    static void
    prepareSelectBlobOnIcaoCodeStatement (soci::session&, soci::statement&,
                                          const std::string& iIcaoCode,
                                          std::string& ioSerialisedPlaceStr);
    static void
    prepareSelectBlobOnFaaCodeStatement (soci::session&, soci::statement&,
                                         const std::string& iFaaCode,
                                         std::string& ioSerialisedPlaceStr);
    static void
    prepareSelectBlobOnUNLOCodeStatement (soci::session&, soci::statement&,
                                          const std::string& iUNLOCode,
                                          std::string& ioSerialisedPlaceStr);
    static void
    prepareSelectBlobOnUICCodeStatement (soci::session&, soci::statement&,
                                         const UICCode_T&,
                                         std::string& ioSerialisedPlaceStr);
    static void
    prepareSelectBlobOnPlaceGeoIDStatement (soci::session&, soci::statement&,
                                            const GeonamesID_T&,
                                            std::string& ioSerialisedPlaceStr);
 
 
  private:
    DBManager() {}
    DBManager (const DBManager&) {}
    ~DBManager() {}
  };
  
}
#endif // __OPENTREP_CMD_DBMANAGER_HPP