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_FIELD >	mio::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_FIELD >	mio::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_FIELD >	mio::metaDataFields
std::vector< SQL_FIELD >	mio::meteoDataFields