22 #ifndef DBALLE_DB_ODBC_STATION_H
23 #define DBALLE_DB_ODBC_STATION_H
36 struct ODBCConnection;
106 void impl_add_station_vars(
const char* query,
int id_station,
Record& rec);
123 int get_id(
int lat,
int lon,
const char* ident=NULL)
override;
133 int obtain_id(
int lat,
int lon,
const char* ident=NULL,
bool* inserted=NULL)
override;
135 void get_station_vars(
int id_station,
int id_report, std::function<
void(std::unique_ptr<wreport::Var>)> dest)
override;
141 void dump(FILE* out)
override;
149 void get_station_vars(
int id_station,
int id_report, std::function<
void(std::unique_ptr<wreport::Var>)> dest)
override;
ODBCStatement * sstm
Precompiled select data by station id query.
Definition: db/odbc/station.h:61
db::Sequence * seq_station
Station ID sequence, when the DB requires it.
Definition: db/odbc/station.h:54
int obtain_id(int lat, int lon, const char *ident=NULL, bool *inserted=NULL) override
Get the station ID given latitude, longitude and mobile identifier.
int id
Station ID SQL parameter.
Definition: db/odbc/station.h:70
ODBCStatement * dstm
Precompiled delete query.
Definition: db/odbc/station.h:67
ODBC statement.
Definition: odbc/internals.h:170
ODBCStatement * ustm
Precompiled update query.
Definition: db/odbc/station.h:65
int get_id(int lat, int lon, const char *ident=NULL) override
Get the station ID given latitude, longitude and mobile identifier.
Precompiled queries to manipulate the station table.
Definition: db/odbc/station.h:45
void get_station_vars(int id_station, int id_report, std::function< void(std::unique_ptr< wreport::Var >)> dest) override
Export station variables.
Key/value store where keys are strings and values are wreport variables.
Definition: record.h:16
Copyright (C) 2008–2010 ARPA-SIM urpsim@smr.arpa.emr.it
Definition: cmdline.h:17
void update()
Update the information about a station entry.
ODBCConnection & conn
DB connection.
Definition: db/odbc/station.h:51
Definition: db/odbc/station.h:145
void add_station_vars(int id_station, Record &rec) override
Add all station variables (without attributes) to rec.
ODBCStatement * smstm
Precompiled select mobile station query.
Definition: db/odbc/station.h:59
Station table management used by the db module.
void add_station_vars(int id_station, Record &rec) override
Add all station variables (without attributes) to rec.
Definition: db/sql/station.h:46
SQLLEN ident_ind
Mobile station identifier indicator.
Definition: db/odbc/station.h:78
Definition: conversion.h:6
void get_data(int id)
Get station information given a station ID.
int lon
Station longitude SQL parameter.
Definition: db/odbc/station.h:74
int lat
Station latitude SQL parameter.
Definition: db/odbc/station.h:72
ODBC statement to read a sequence.
Definition: odbc/internals.h:247
ODBCStatement * sfstm
Precompiled select fixed station query.
Definition: db/odbc/station.h:57
char ident[64]
Mobile station identifier SQL parameter.
Definition: db/odbc/station.h:76
void get_station_vars(int id_station, int id_report, std::function< void(std::unique_ptr< wreport::Var >)> dest) override
Export station variables.
void set_ident(const char *ident)
Set the mobile station identifier input value for this ::dba_db_station.
Database connection.
Definition: odbc/internals.h:87
void dump(FILE *out) override
Dump the entire contents of the table to an output stream.
ODBCStatement * istm
Precompiled insert query.
Definition: db/odbc/station.h:63