MeteoIODoc 2.11.0
MySQLIO.cc File Reference
#include <meteoio/plugins/MySQLIO.h>
#include <meteoio/plugins/libMysqlWrapper.h>
#include <stdio.h>
#include <algorithm>

Namespaces

namespace  mio
 

Variables

const std::string mio::WWCS_metaDataQuery = "SELECT stationName, latitude, longitude, altitude, slope, azimuth FROM sites WHERE StationID=?"
 
const std::vector< SQL_FIELDmio::WWCS_metaDataFields { SQL_FIELD("STATNAME", MYSQL_TYPE_STRING), SQL_FIELD("LAT", MYSQL_TYPE_DOUBLE), SQL_FIELD("LON", MYSQL_TYPE_DOUBLE), SQL_FIELD("ALT", MYSQL_TYPE_DOUBLE), SQL_FIELD("SLOPE", MYSQL_TYPE_DOUBLE), SQL_FIELD("AZI", MYSQL_TYPE_DOUBLE) }
 
const std::string mio::WWCS_meteoDataQuery = "SELECT timestamp, ta, rh, p, logger_ta, logger_rh FROM v_meteoseries WHERE stationID=? and timestamp>=? AND timestamp<=? ORDER BY timestamp ASC"
 
const std::vector< SQL_FIELDmio::WWCS_meteoDataFields { SQL_FIELD("DATETIME", MYSQL_TYPE_DATETIME), SQL_FIELD("TA", MYSQL_TYPE_DOUBLE, SQL_FIELD::C_TO_K), SQL_FIELD("RH", MYSQL_TYPE_DOUBLE, SQL_FIELD::NORMALIZE_PC), SQL_FIELD("P", MYSQL_TYPE_DOUBLE, SQL_FIELD::HPA_TO_PA), SQL_FIELD("LOGGER_TA", MYSQL_TYPE_DOUBLE, SQL_FIELD::C_TO_K), SQL_FIELD("LOGGER_RH", MYSQL_TYPE_DOUBLE, SQL_FIELD::NORMALIZE_PC) }
 
std::string mio::metaDataQuery
 
std::string mio::meteoDataQuery
 
std::vector< SQL_FIELDmio::metaDataFields
 
std::vector< SQL_FIELDmio::meteoDataFields