1 #ifndef DBA_DB_V7_QBUILDER_H
2 #define DBA_DB_V7_QBUILDER_H
5 #include <dballe/db/v7/db.h>
6 #include <dballe/core/query.h>
31 bool select_station =
false;
33 bool select_varinfo =
false;
36 bool select_data_id =
false;
39 bool select_data =
false;
42 bool select_summary_details =
false;
69 bool add_pa_where(
const char* tbl);
70 bool add_dt_where(
const char* tbl);
71 bool add_ltr_where(
const char* tbl);
72 bool add_varcode_where(
const char* tbl);
73 bool add_repinfo_where(
const char* tbl);
74 bool add_datafilter_where(
const char* tbl);
76 virtual void build_select() = 0;
77 virtual bool build_where() = 0;
78 virtual void build_order_by() = 0;
86 virtual void build_select();
87 virtual bool build_where();
88 virtual void build_order_by();
110 virtual void build_select();
111 virtual bool build_where();
112 virtual void build_order_by();
120 virtual void build_select();
121 virtual void build_order_by();
129 virtual void build_select();
130 virtual void build_order_by();
Definition: v7/qbuilder.h:81
const core::Query & query
Query object.
Definition: v7/qbuilder.h:45
Definition: v7/qbuilder.h:124
Definition: v7/qbuilder.h:115
const unsigned int modifiers
Modifier flags to enable special query behaviours.
Definition: v7/qbuilder.h:57
Standard dballe::Query implementation.
Definition: core/query.h:29
Match a variable code and value.
Definition: varmatch.h:12
Build SQL queries for V7 databases.
Definition: v7/qbuilder.h:16
dballe::sql::Querybuf sql_from
FROM part of the SQL query.
Definition: v7/qbuilder.h:51
Buffer used to build SQL queries.
bool query_attrs
True if we also query attributes of data.
Definition: v7/qbuilder.h:97
DB & db
Database to operate on.
Definition: v7/qbuilder.h:21
const char * bind_in_ident
If defined, it need to point to the identifier to be used as the only bound input parameter...
Definition: v7/qbuilder.h:29
dballe::sql::Querybuf sql_query
Dynamically generated SQL query.
Definition: v7/qbuilder.h:48
DB-ALLe database connection for database format V7.
Definition: v7/db.h:39
bool match_attrs(const wreport::Var &var) const
Match the attributes of var against attr_filter.
bool select_attrs
True if the select includes the attrs field.
Definition: v7/qbuilder.h:100
Varmatch * attr_filter
Attribute filter, if requested.
Definition: v7/qbuilder.h:94
bool query_station_vars
True if we are querying station information, rather than measured data.
Definition: v7/qbuilder.h:60
String buffer for composing database queries.
Definition: querybuf.h:15
Definition: v7/qbuilder.h:91
dballe::sql::Querybuf sql_where
WHERE part of the SQL query.
Definition: v7/qbuilder.h:54