1#ifndef __OPENTREP_CMD_DBMANAGER_HPP
2#define __OPENTREP_CMD_DBMANAGER_HPP
158 const bool iUniqueEntry);
200 const bool iUniqueEntry);
269 const double& iLatitude,
270 const double& iLongitude);
295 prepareSelectBlobOnIataCodeStatement (soci::session&, soci::statement&,
296 const std::string& iIataCode,
297 std::string& ioSerialisedPlaceStr);
307 prepareSelectBlobOnIcaoCodeStatement (soci::session&, soci::statement&,
308 const std::string& iIcaoCode,
309 std::string& ioSerialisedPlaceStr);
319 prepareSelectBlobOnFaaCodeStatement (soci::session&, soci::statement&,
320 const std::string& iFaaCode,
321 std::string& ioSerialisedPlaceStr);
331 prepareSelectBlobOnUNLOCodeStatement (soci::session&, soci::statement&,
332 const std::string& iUNLOCode,
333 std::string& ioSerialisedPlaceStr);
343 prepareSelectBlobOnUICCodeStatement (soci::session&, soci::statement&,
345 std::string& ioSerialisedPlaceStr);
355 prepareSelectBlobOnPlaceGeoIDStatement (soci::session&, soci::statement&,
357 std::string& ioSerialisedPlaceStr);
Class wrapping the access to an underlying SQL database.
static void terminateSQLDBSession(const DBType &, const SQLDBConnectionString_T &, soci::session &)
static void createSQLDBTables(soci::session &)
static std::string prepareSelectAllBlobStatement(soci::session &, soci::statement &)
static NbOfDBEntries_T getPORByUICCode(soci::session &, const UICCode_T &, LocationList_T &)
static NbOfDBEntries_T getPORByICAOCode(soci::session &, const ICAOCode_T &, LocationList_T &)
static soci::session * initSQLDBSession(const DBType &, const SQLDBConnectionString_T &)
static NbOfDBEntries_T getPORByFAACode(soci::session &, const FAACode_T &, LocationList_T &)
static void createSQLDBIndexes(soci::session &)
static void prepareSelectFromCoordStatement(soci::session &, soci::statement &, const double &iLatitude, const double &iLongitude)
static NbOfDBEntries_T displayCount(soci::session &)
static NbOfDBEntries_T displayAll(soci::session &)
static NbOfDBEntries_T getPORByUNLOCode(soci::session &, const UNLOCode_T &, LocationList_T &, const bool iUniqueEntry)
static NbOfDBEntries_T getPORByGeonameID(soci::session &, const GeonamesID_T &, LocationList_T &)
static NbOfDBEntries_T getPORByIATACode(soci::session &, const IATACode_T &, LocationList_T &, const bool iUniqueEntry)
static void updatePlaceInDB(soci::session &, const Place &)
static bool iterateOnStatement(soci::statement &, const std::string &)
static bool createSQLDBUser(const DBType &, const SQLDBConnectionString_T &, const DeploymentNumber_T &)
static void insertPlaceInDB(soci::session &, const Place &)
Class modelling a place/POR (point of reference).
unsigned int NbOfDBEntries_T
std::list< Location > LocationList_T
unsigned short DeploymentNumber_T
unsigned int GeonamesID_T
Enumeration of database types.