MySQLIO.h

Go to the documentation of this file.

// SPDX-License-Identifier: LGPL-3.0-or-later
/***********************************************************************************/
/*  Copyright 2022 WSL Institute for Snow and Avalanche Research    SLF-DAVOS      */
/***********************************************************************************/
/* This file is part of MeteoIO.
    MeteoIO is free software: you can redistribute it and/or modify
    it under the terms of the GNU Lesser General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.
 
    MeteoIO is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU Lesser General Public License for more details.
 
    You should have received a copy of the GNU Lesser General Public License
    along with MeteoIO.  If not, see <http://www.gnu.org/licenses/>.
*/
#ifndef MYSQLIO_H
#define MYSQLIO_H
 
#include <meteoio/IOInterface.h>
 
#include <string>
#include <map>
 
namespace mio {
 
class MYSQLIO : public IOInterface {
        public:
                MYSQLIO(const std::string& configfile);
                MYSQLIO(const Config& cfgreader);
 
                virtual void readStationData(const Date& date, std::vector<StationData>& vecStation) override;
                virtual void readMeteoData(const Date& dateStart, const Date& dateEnd,
                                           std::vector< std::vector<MeteoData> >& vecMeteo) override;
 
        private:
                void readConfig();
                void readStationIDs();
                std::pair<std::string, std::string> parseStationID(const std::string& stationID);
                void readStationMetaData();
                void readData(const Date& dateStart, const Date& dateEnd, std::vector< std::vector<MeteoData> >& vecMeteo,
                              const size_t& stationindex) const;
 
                const Config cfg;
                std::vector<std::string> vecStationIDs;
                std::map<std::string, std::string> stationIDtoIndex; // Maps station abbreviation to index string for composite ID schemas
                std::vector<StationData> vecStationMetaData;
                std::string mysqlhost, mysqldb, mysqluser, mysqlpass;
                std::string coordin, coordinparam, coordout, coordoutparam; //projection parameters
                double in_dflt_TZ, out_dflt_TZ;
                unsigned int mysql_options;
                bool hasCompositeIDs=false; //set to true when the db schema stores the stationID as a string field and an int index field.
};
 
} //namespace
#endif