#ifndef _atm_AOverallQualitySQLManager_h_
#define _atm_AOverallQualitySQLManager_h_

#include <utl/ErrorLogger.h>
#include <utl/config.h>

#ifdef AUGER_SQLITE_ENABLED
#include <det/VSQLManager_SQLite.h>
#else
#include <det/VSQLManager_MySQL.h>
#endif

namespace atm {

  /**
    \brief
    Manager for aerosol portion of atmospheric monitoring database

    \author Tom Paul
    \author Darko Veberic
    \version $Id: AOverallQualitySQLManager.h 18230 2011-01-03 17:15:30Z dembinski $
    \date 22 Jan 2004
    \date 27 Oct 2005
    \date 12 Jan 2007 DV update
    \ingroup managers
  */

  class AOverallQualitySQLManager : public det::VSQLManager {

  public:
    VSQLMANAGER_GETDATA_GETDBDATA(double)
    VSQLMANAGER_GETDATA_GETDBDATA(int)
    VSQLMANAGER_GETDATA_GETDBDATA(std::string)

    VMANAGER_GETDATA_NOTFOUND(utl::TabulatedFunction)
    VMANAGER_GETDATA_NOTFOUND(utl::TabulatedFunctionComplexLgAmpPhase)
    VMANAGER_GETDATA_NOTFOUND(std::vector<double>)
    VMANAGER_GETDATA_NOTFOUND(std::vector<int>)
    VMANAGER_GETDATA_NOTFOUND(std::vector<std::string>)
    VMANAGER_GETDATA_NOTFOUND(std::vector<bool>)
    VMANAGER_GETDATA_NOTFOUND(std::list<std::pair<int, int> >)
    VMANAGER_GETDATA_NOTFOUND(std::list<double>)
    VMANAGER_GETDATA_NOTFOUND(std::list<int>)
    VMANAGER_GETDATA_NOTFOUND(std::list<std::string>)
    VMANAGER_GETDATA_NOTFOUND(std::map<int, utl::TabulatedFunction>)
    VMANAGER_GETDATA_DENIED(std::map<std::string, double>)

  private:
    // Helper methods that sends the DB query and retrieves a MYSQL_RES*.
    // This method is present mainly to separate the comparitively verbose
    // query code from the shorter bit of code which uses the templated type.

    // for fundamental types
    virtual Status GetDBResFundamental(const std::string& tableName,
                                       const std::string& columnName,
                                       const IndexMap& componentIndex) const;

  };

}


#endif

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