dballe::db::sqlite::SQLiteStationBase Class Reference

Precompiled queries to manipulate the station table. More...

#include <station.h>

Inheritance diagram for dballe::db::sqlite::SQLiteStationBase:

Public Member Functions
	SQLiteStationBase (SQLiteConnection &conn)
	SQLiteStationBase (const SQLiteStationBase &)=delete
	SQLiteStationBase (const SQLiteStationBase &&)=delete
SQLiteStationBase &	operator= (const SQLiteStationBase &)=delete
int	get_id (int lat, int lon, const char *ident=nullptr) override
	Get the station ID given latitude, longitude and mobile identifier. More...
int	obtain_id (int lat, int lon, const char *ident=nullptr, bool *inserted=NULL) override
	Get the station ID given latitude, longitude and mobile identifier. More...
void	get_station_vars (int id_station, int id_report, std::function< void(std::unique_ptr< wreport::Var >)> dest) override
	Export station variables.
void	add_station_vars (int id_station, Record &rec) override
	Add all station variables (without attributes) to rec. More...
void	dump (FILE *out) override
	Dump the entire contents of the table to an output stream.
Public Member Functions inherited from dballe::db::sql::Station
virtual	~Station ()
	Instantiate a Station object for this connection.

Protected Member Functions
bool	maybe_get_id (int lat, int lon, const char *ident, int *id)
	Lookup the ID of a station, returning true if it was found, false if not.
void	read_station_vars (SQLiteStatement &stm, std::function< void(std::unique_ptr< wreport::Var >)> dest)
	Run stm, read its output and generate variables to send to dest.

Protected Attributes
SQLiteConnection &	conn
	DB connection.
SQLiteStatement *	sfstm = nullptr
	Precompiled select fixed station query.
SQLiteStatement *	smstm = nullptr
	Precompiled select mobile station query.
SQLiteStatement *	istm = nullptr
	Precompiled insert query.

Detailed Description

Precompiled queries to manipulate the station table.

Member Function Documentation

void dballe::db::sqlite::SQLiteStationBase::add_station_vars ( int  id_station, Record &  rec  )

overridevirtual

Add all station variables (without attributes) to rec.

If the same variable exists in many different networks, the one with the highest priority will be used.

Implements dballe::db::sql::Station.

int dballe::db::sqlite::SQLiteStationBase::get_id ( int  lat, int  lon, const char *  ident = nullptr  )

overridevirtual

Get the station ID given latitude, longitude and mobile identifier.

It throws an exception if it does not exist.

Returns

Resulting ID of the station

Implements dballe::db::sql::Station.

int dballe::db::sqlite::SQLiteStationBase::obtain_id ( int  lat, int  lon, const char *  ident = nullptr, bool *  inserted = NULL  )

overridevirtual

Get the station ID given latitude, longitude and mobile identifier.

It creates the station record if it does not exist.

Returns

Resulting ID of the station

Implements dballe::db::sql::Station.

---

The documentation for this class was generated from the following file:

• db/sqlite/station.h