1 #ifndef __OPENTREP_CMD_DBMANAGER_HPP 2 #define __OPENTREP_CMD_DBMANAGER_HPP 158 const bool iUniqueEntry);
267 const double& iLatitude,
268 const double& iLongitude);
293 prepareSelectBlobOnIataCodeStatement (soci::session&, soci::statement&,
295 std::string& ioSerialisedPlaceStr);
305 prepareSelectBlobOnIcaoCodeStatement (soci::session&, soci::statement&,
307 std::string& ioSerialisedPlaceStr);
317 prepareSelectBlobOnFaaCodeStatement (soci::session&, soci::statement&,
319 std::string& ioSerialisedPlaceStr);
329 prepareSelectBlobOnUNLOCodeStatement (soci::session&, soci::statement&,
331 std::string& ioSerialisedPlaceStr);
341 prepareSelectBlobOnUICCodeStatement (soci::session&, soci::statement&,
343 std::string& ioSerialisedPlaceStr);
353 prepareSelectBlobOnPlaceGeoIDStatement (soci::session&, soci::statement&,
355 std::string& ioSerialisedPlaceStr);
374 #endif // __OPENTREP_CMD_DBMANAGER_HPP
unsigned int GeonamesID_T
static void updatePlaceInDB(soci::session &, const Place &)
static NbOfDBEntries_T getPORByFAACode(soci::session &, const FAACode_T &, LocationList_T &)
unsigned int NbOfDBEntries_T
static bool createSQLDBUser(const DBType &, const SQLDBConnectionString_T &, const DeploymentNumber_T &)
static std::string prepareSelectAllBlobStatement(soci::session &, soci::statement &)
static void createSQLDBTables(soci::session &)
static void terminateSQLDBSession(const DBType &, const SQLDBConnectionString_T &, soci::session &)
static NbOfDBEntries_T getPORByUICCode(soci::session &, const UICCode_T &, LocationList_T &)
Enumeration of database types.
static NbOfDBEntries_T getPORByIATACode(soci::session &, const IATACode_T &, LocationList_T &, const bool iUniqueEntry)
static NbOfDBEntries_T displayCount(soci::session &)
Class modelling a place/POR (point of reference).
std::list< Location > LocationList_T
static NbOfDBEntries_T getPORByUNLOCode(soci::session &, const UNLOCode_T &, LocationList_T &)
static bool iterateOnStatement(soci::statement &, const std::string &)
static NbOfDBEntries_T displayAll(soci::session &)
static NbOfDBEntries_T getPORByGeonameID(soci::session &, const GeonamesID_T &, LocationList_T &)
static void prepareSelectFromCoordStatement(soci::session &, soci::statement &, const double &iLatitude, const double &iLongitude)
static NbOfDBEntries_T getPORByICAOCode(soci::session &, const ICAOCode_T &, LocationList_T &)
static void createSQLDBIndexes(soci::session &)
static soci::session * initSQLDBSession(const DBType &, const SQLDBConnectionString_T &)
unsigned short DeploymentNumber_T
static void insertPlaceInDB(soci::session &, const Place &)
Class wrapping the access to an underlying SQL database.