AOverallQualitySQLManager.cc

Go to the documentation of this file.

#include <sstream>

#include <atm/AOverallQualitySQLManager.h>
#include <fwk/CentralConfig.h>
#include <det/Detector.h>
#include <utl/ErrorLogger.h>
#include <utl/TimeStamp.h>
#include <utl/Reader.h>
#include <utl/StringCompare.h>

using namespace std;
using namespace atm;
using namespace det;


REGISTER_A_MANAGER("AOverallQualitySQLManager", AOverallQualitySQLManager);


VManager::Status
AOverallQualitySQLManager::GetDBResFundamental(const std::string& tableName,
                                               const std::string& columnName,
                                               const IndexMap&)
  const
{
  const utl::TimeStamp detTime = Detector::GetInstance().GetTime();

  ostringstream query;

  // aerosol table is a special case, as it requires checking software version
  if (tableName == "overall_quality") {

    if (utl::StringEquivalent(fDatabaseSoftwareVersion, "default"))
      // do NOT check software version

      query << "SELECT " << columnName << " "
               "FROM overall_quality "
               "WHERE start_time <= \"" << detTime.GetGPSSecond() << "\" "
               "AND (end_time > \"" << detTime.GetGPSSecond() << "\" "
               "OR end_time IS NULL) ORDER BY last_modified DESC, start_time DESC LIMIT 1";

    else                 // DO check software version

      query << "SELECT " << columnName << " "
               "FROM overall_quality,software "
               "WHERE start_time <= \"" << detTime.GetGPSSecond() << "\" "
               "AND (end_time > \"" << detTime.GetGPSSecond() << "\" "
               "OR end_time IS NULL) AND "
               "overall_quality.software_id = software.software_id "
               "AND software.software_version = \"" << fDatabaseSoftwareVersion << "\" "
               "ORDER BY overall_quality.last_modified DESC, start_time DESC LIMIT 1";

    return Query(query, QueryInfoMessage(tableName, columnName));

  }

  return eNotFound;

}


// Configure (x)emacs for this file ...
// Local Variables:
// mode: c++
// End: