libdballe 9.6
Public Member Functions | List of all members
dballe::db::v7::sqlite::SQLiteData Class Reference

Precompiled query to manipulate the data table. More...

#include <data.h>

Inheritance diagram for dballe::db::v7::sqlite::SQLiteData:
dballe::db::v7::sqlite::SQLiteDataCommon< Data > dballe::db::v7::Data dballe::db::v7::DataCommon< DataTraits >

Public Member Functions

 SQLiteData (v7::Transaction &tr, dballe::sql::SQLiteConnection &conn)
 
void query (Tracer<> &trc, int id_station, const Datetime &datetime, std::function< void(int id, int id_levtr, wreport::Varcode code)> dest) override
 Query contents of the data table.
 
void insert (Tracer<> &trc, int id_station, const Datetime &datetime, std::vector< batch::MeasuredDatum > &vars, bool with_attrs) override
 Bulk variable insert.
 
void run_data_query (Tracer<> &trc, const v7::DataQueryBuilder &qb, std::function< void(const dballe::DBStation &station, int id_levtr, const Datetime &datetime, int id_data, std::unique_ptr< wreport::Var > var)>) override
 Run a data query, iterating on the resulting variables.
 
void run_summary_query (Tracer<> &trc, const v7::SummaryQueryBuilder &qb, std::function< void(const dballe::DBStation &station, int id_levtr, wreport::Varcode code, const DatetimeRange &datetime, size_t size)>) override
 Run a summary query, iterating on the resulting variables.
 
void dump (FILE *out) override
 Dump the entire contents of the table to an output stream.
 
void clear_cache () override
 
 SQLiteDataCommon (v7::Transaction &tr, dballe::sql::SQLiteConnection &conn)
 
 SQLiteDataCommon (const SQLiteDataCommon &)=delete
 
 SQLiteDataCommon (const SQLiteDataCommon &&)=delete
 
- Public Member Functions inherited from dballe::db::v7::sqlite::SQLiteDataCommon< Data >
 SQLiteDataCommon (v7::Transaction &tr, dballe::sql::SQLiteConnection &conn)
 
 SQLiteDataCommon (const SQLiteDataCommon &)=delete
 
 SQLiteDataCommon (const SQLiteDataCommon &&)=delete
 
SQLiteDataCommonoperator= (const SQLiteDataCommon &)=delete
 
void update (Tracer<> &trc, std::vector< typename Parent::BatchValue > &vars, bool with_attrs) override
 
void read_attrs (Tracer<> &trc, int id_data, std::function< void(std::unique_ptr< wreport::Var >)> dest) override
 
void write_attrs (Tracer<> &trc, int id_data, const Values &values) override
 
void remove_all_attrs (Tracer<> &trc, int id_data) override
 
void remove (Tracer<> &trc, const v7::IdQueryBuilder &qb) override
 
void remove_by_id (Tracer<> &trc, int id) override
 
virtual void insert (Tracer<> &trc, int id_station, const Datetime &datetime, std::vector< batch::MeasuredDatum > &vars, bool with_attrs)=0
 Bulk variable insert.
 
virtual void query (Tracer<> &trc, int id_station, const Datetime &datetime, std::function< void(int id, int id_levtr, wreport::Varcode code)> dest)=0
 Query contents of the data table.
 
virtual void run_data_query (Tracer<> &trc, const v7::DataQueryBuilder &qb, std::function< void(const dballe::DBStation &station, int id_levtr, const Datetime &datetime, int id_data, std::unique_ptr< wreport::Var > var)>)=0
 Run a data query, iterating on the resulting variables.
 
virtual void run_summary_query (Tracer<> &trc, const v7::SummaryQueryBuilder &qb, std::function< void(const dballe::DBStation &station, int id_levtr, wreport::Varcode code, const DatetimeRange &datetime, size_t size)>)=0
 Run a summary query, iterating on the resulting variables.
 
- Public Member Functions inherited from dballe::db::v7::DataCommon< DataTraits >
 DataCommon (v7::Transaction &tr)
 
virtual void read_attrs (Tracer<> &trc, int id_data, std::function< void(std::unique_ptr< wreport::Var >)> dest)=0
 Load from the database all the attributes for var.
 
void merge_attrs (Tracer<> &trc, int id_data, const Values &attrs)
 Merge the given attributes with the existing attributes of the given variable:
 
void remove_attrs (Tracer<> &trc, int data_id, const db::AttrList &attrs)
 Remove the given attributes from the given variable, if they exist.
 
virtual void update (Tracer<> &trc, std::vector< typename Traits::BatchValue > &vars, bool with_attrs)=0
 Bulk variable update.
 
virtual void remove (Tracer<> &trc, const v7::IdQueryBuilder &qb)=0
 Run the query to delete all records selected by the given QueryBuilder.
 
virtual void remove_by_id (Tracer<> &trc, int id)=0
 Run the query to delete the record with the given ID.
 
virtual void dump (FILE *out)=0
 Dump the entire contents of the table to an output stream.
 
virtual void clear_cache ()=0
 

Additional Inherited Members

- Protected Types inherited from dballe::db::v7::DataCommon< DataTraits >
typedef Traits::BatchValue BatchValue
 
- Protected Member Functions inherited from dballe::db::v7::DataCommon< DataTraits >
void read_attrs_into_values (Tracer<> &trc, int id_data, Values &values)
 Load attributes from the database into a Values.
 
void read_attrs_into_values (Tracer<> &trc, int id_data, Values &values, const db::AttrList &exclude)
 Load attributes from the database into a Values, except those whose Varcode is in exclude
 
virtual void write_attrs (Tracer<> &trc, int id_data, const Values &values)=0
 Replace the attributes of a variable with those in Values.
 
virtual void remove_all_attrs (Tracer<> &trc, int id_data)=0
 Remove all attributes from a variable.
 
- Protected Attributes inherited from dballe::db::v7::sqlite::SQLiteDataCommon< Data >
dballe::sql::SQLiteConnectionconn
 DB connection.
 
dballe::sql::SQLiteStatementread_attrs_stm
 Precompiled read attributes statement.
 
dballe::sql::SQLiteStatementwrite_attrs_stm
 Precompiled write attributes statement.
 
dballe::sql::SQLiteStatementremove_attrs_stm
 Precompiled remove attributes statement.
 
dballe::sql::SQLiteStatementsstm
 Precompiled select statement.
 
dballe::sql::SQLiteStatementistm
 Precompiled insert statement.
 
dballe::sql::SQLiteStatementustm
 Precompiled update statement.
 
- Protected Attributes inherited from dballe::db::v7::DataCommon< DataTraits >
v7::Transactiontr
 
- Static Protected Attributes inherited from dballe::db::v7::DataCommon< DataTraits >
static const char * table_name
 

Detailed Description

Precompiled query to manipulate the data table.

Member Function Documentation

◆ clear_cache()

void dballe::db::v7::sqlite::SQLiteData::clear_cache ( )
inlineoverridevirtual

◆ dump()

void dballe::db::v7::sqlite::SQLiteData::dump ( FILE *  out)
overridevirtual

Dump the entire contents of the table to an output stream.

Implements dballe::db::v7::DataCommon< DataTraits >.

◆ insert()

void dballe::db::v7::sqlite::SQLiteData::insert ( Tracer<> &  trc,
int  id_station,
const Datetime datetime,
std::vector< batch::MeasuredDatum > &  vars,
bool  with_attrs 
)
overridevirtual

Bulk variable insert.

Implements dballe::db::v7::Data.

◆ query()

void dballe::db::v7::sqlite::SQLiteData::query ( Tracer<> &  trc,
int  id_station,
const Datetime datetime,
std::function< void(int id, int id_levtr, wreport::Varcode code)>  dest 
)
overridevirtual

Query contents of the data table.

Implements dballe::db::v7::Data.

◆ run_data_query()

void dballe::db::v7::sqlite::SQLiteData::run_data_query ( Tracer<> &  trc,
const v7::DataQueryBuilder qb,
std::function< void(const dballe::DBStation &station, int id_levtr, const Datetime &datetime, int id_data, std::unique_ptr< wreport::Var > var)>   
)
overridevirtual

Run a data query, iterating on the resulting variables.

Implements dballe::db::v7::Data.

◆ run_summary_query()

void dballe::db::v7::sqlite::SQLiteData::run_summary_query ( Tracer<> &  trc,
const v7::SummaryQueryBuilder qb,
std::function< void(const dballe::DBStation &station, int id_levtr, wreport::Varcode code, const DatetimeRange &datetime, size_t size)>   
)
overridevirtual

Run a summary query, iterating on the resulting variables.

Implements dballe::db::v7::Data.


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