/usr/include/dballe/db/sqlite/station.h is in libdballe-dev 7.7-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 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 | /*
* db/station - station table management
*
* Copyright (C) 2005--2015 ARPA-SIM <urpsim@smr.arpa.emr.it>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*
* Author: Enrico Zini <enrico@enricozini.com>
*/
#ifndef DBALLE_DB_SQLITE_STATION_H
#define DBALLE_DB_SQLITE_STATION_H
/** @file
* @ingroup db
*
* Station table management used by the db module.
*/
#include <dballe/db/sql/station.h>
#include <functional>
#include <memory>
namespace wreport {
struct Var;
}
namespace dballe {
namespace db {
struct SQLiteConnection;
struct SQLiteStatement;
namespace sqlite {
/**
* Precompiled queries to manipulate the station table
*/
class SQLiteStationBase : public sql::Station
{
protected:
/**
* DB connection.
*/
SQLiteConnection& conn;
/** Precompiled select fixed station query */
SQLiteStatement* sfstm = nullptr;
/** Precompiled select mobile station query */
SQLiteStatement* smstm = nullptr;
/** Precompiled insert query */
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(SQLiteStatement& stm, std::function<void(std::unique_ptr<wreport::Var>)> dest);
public:
SQLiteStationBase(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(SQLiteConnection& conn);
};
}
}
}
#endif
|