/usr/include/dballe/db/v6/sqlite/station.h is in libdballe-dev 7.21-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 | #ifndef DBALLE_DB_V6_SQLITE_STATION_H
#define DBALLE_DB_V6_SQLITE_STATION_H
#include <dballe/db/v6/station.h>
#include <functional>
#include <memory>
namespace wreport {
struct Var;
}
namespace dballe {
namespace db {
namespace v6 {
namespace sqlite {
/**
* Precompiled queries to manipulate the station table
*/
class SQLiteStationBase : public v6::Station
{
protected:
/**
* DB connection.
*/
dballe::sql::SQLiteConnection& conn;
/** Precompiled select fixed station query */
dballe::sql::SQLiteStatement* sfstm = nullptr;
/** Precompiled select mobile station query */
dballe::sql::SQLiteStatement* smstm = nullptr;
/** Precompiled insert query */
dballe::sql::SQLiteStatement* istm = nullptr;
/// Lookup the ID of a station, returning true if it was found, false if not
bool maybe_get_id(int lat, int lon, const char* ident, int* id);
/// Run stm, read its output and generate variables to send to dest
void read_station_vars(dballe::sql::SQLiteStatement& stm, std::function<void(std::unique_ptr<wreport::Var>)> dest);
public:
SQLiteStationBase(dballe::sql::SQLiteConnection& conn);
~SQLiteStationBase();
SQLiteStationBase(const SQLiteStationBase&) = delete;
SQLiteStationBase(const SQLiteStationBase&&) = delete;
SQLiteStationBase& operator=(const SQLiteStationBase&) = delete;
/**
* Get the station ID given latitude, longitude and mobile identifier.
*
* It throws an exception if it does not exist.
*
* @return
* Resulting ID of the station
*/
int get_id(int lat, int lon, const char* ident=nullptr) override;
/**
* Get the station ID given latitude, longitude and mobile identifier.
*
* It creates the station record if it does not exist.
*
* @return
* Resulting ID of the station
*/
int obtain_id(int lat, int lon, const char* ident=nullptr, bool* inserted=NULL) override;
void get_station_vars(int id_station, int id_report, std::function<void(std::unique_ptr<wreport::Var>)> dest) override;
void add_station_vars(int id_station, Record& rec) override;
/**
* Dump the entire contents of the table to an output stream
*/
void dump(FILE* out) override;
};
class SQLiteStationV6 : public SQLiteStationBase
{
public:
SQLiteStationV6(dballe::sql::SQLiteConnection& conn);
};
}
}
}
}
#endif
|