26 #include <meteoio/MeteoIO.h>
37 virtual bool snowCoverExists(
const std::string& i_snowfile,
const std::string& stationID)
const;
39 virtual void readSnowCover(
const std::string& i_snowfile,
const std::string& stationID,
46 const ProcessDat& Hdata,
const double wind_trans24);
50 virtual bool writeHazardData(
const std::string& stationID,
const std::vector<ProcessDat>& Hdata,
51 const std::vector<ProcessInd>& Hdata_ind,
const size_t& num);
56 static void parseStationName(
const std::string& stationName, std::string& stName, std::string& stNumber);
62 void deleteProfile(
const std::string& stationName,
const unsigned char& stationNumber,
63 const mio::Date& dateStart,
const mio::Date& dateEnd);
64 void deleteHdata(
const std::string& stationName,
const std::string& stationNumber,
65 const mio::Date& dateStart,
const mio::Date& dateEnd);
66 void insertProfile(
const std::vector<SnowProfileLayer> &Pdata);
67 void insertHdata(
const std::string& stationName,
const std::string& stationNumber,
68 const std::vector<ProcessDat>& Hdata,
const std::vector<ProcessInd>& Hdata_ind,
71 oracle::occi::Date OracleDate(mio::Date in_date)
const;
72 static std::string getKey(
const SnowpackConfig& i_cfg,
const std::string& key,
const std::string& section);
77 oracle::occi::Environment *env;
78 oracle::occi::Connection *conn;
79 oracle::occi::Statement *stmt;
81 const std::string oracleDB, oracleUser, oraclePassword;
84 static const double time_zone;
85 static double hoar_density_surf, hoar_min_size_surf;
87 static const std::string sqlDeleteHdata;
88 static const std::string sqlDeleteProfile;
89 static const std::string sqlInsertHdata;
90 static const std::string sqlInsertProfile;
virtual void writeProfile(const mio::Date &date, const SnowStation &Xdata)
Dump aggregated profile to database.
Definition: ImisDBIO.cc:235
ZwischenData contains "memory" information mainly for operational use It is used to prepare some para...
Definition: DataClasses.h:63
virtual void writeSnowCover(const mio::Date &date, const SnowStation &Xdata, const ZwischenData &Zdata, const bool &forbackup=false)
Definition: ImisDBIO.cc:136
SN_SNOWSOIL_DATA includes all important station parameters as well as LayerData This data structure ...
Definition: DataClasses.h:212
Definition: SnowpackConfig.h:28
ImisDBIO(const SnowpackConfig &i_cfg, const RunInfo &run_info)
Definition: ImisDBIO.cc:63
Definition: ImisDBIO.h:30
class to collect the information about the current simulation (version, date)
Definition: DataClasses.h:690
Definition: SnowpackIOInterface.h:27
Definition: DataClasses.h:580
virtual bool writeHazardData(const std::string &stationID, const std::vector< ProcessDat > &Hdata, const std::vector< ProcessInd > &Hdata_ind, const size_t &num)
Definition: ImisDBIO.cc:257
CurrentMeteo is the class of interpolated meteo data for the current calculation time step It contai...
Definition: DataClasses.h:81
virtual void readSnowCover(const std::string &i_snowfile, const std::string &stationID, SN_SNOWSOIL_DATA &SSdata, ZwischenData &Zdata)
Definition: ImisDBIO.cc:130
virtual void writeTimeSeries(const SnowStation &Xdata, const SurfaceFluxes &Sdata, const CurrentMeteo &Mdata, const ProcessDat &Hdata, const double wind_trans24)
Definition: ImisDBIO.cc:142
virtual bool snowCoverExists(const std::string &i_snowfile, const std::string &stationID) const
This routine checks if the specified snow cover data exists.
Definition: ImisDBIO.cc:125
ImisDBIO & operator=(const ImisDBIO &in)
Definition: ImisDBIO.cc:88
Structure of double values for output to SDB.
Definition: DataClasses.h:707
Station data including all information on snowpack layers (elements and nodes) and on canopy This is...
Definition: DataClasses.h:463
~ImisDBIO()
Definition: ImisDBIO.cc:97
Defines structure for snow profile layers.
Definition: DataClasses.h:651
Definition: DataClasses.h:771