22 #ifndef DBALLE_DB_V6_DATA_H
23 #define DBALLE_DB_V6_DATA_H
32 #include <wreport/var.h>
65 DBALLE_SQL_C_SINT_TYPE
id;
103 void set(
const wreport::Var& var);
140 void dump(FILE* out);
void set_date(const Record &rec)
Set the date from the date information in the record.
db::Statement * ustm
Precompiled update statement.
Definition: v6/data.h:56
char value[255]
Variable value SQL parameter.
Definition: v6/data.h:78
void set(const wreport::Var &var)
Set the value input fields using a wreport::Var.
void set_value(const char *value)
Set the value input fields using a string value.
DBALLE_SQL_C_SINT_TYPE id
data ID SQL parameter
Definition: v6/data.h:65
db::Statement * iistm
Precompiled insert or ignore statement.
Definition: v6/data.h:60
The ODBC specification is imperfect with regards to integer sizes on 64bit platforms, and different ODBC drivers are currently interpreting it differently.
DB-All.E record.
Definition: record.h:102
void set_id_lev_tr(int id)
Set id_lev_tr to a valid value.
void insert_or_overwrite(bool want_id=false)
Insert an entry into the data table, overwriting on conflicts.
DBALLE_SQL_C_SINT_TYPE id_lev_tr
Context ID SQL parameter.
Definition: v6/data.h:72
DBALLE_SQL_C_SINT_TYPE id_report
Report ID SQL parameter.
Definition: v6/data.h:70
void dump(FILE *out)
Dump the entire contents of the table to an output stream.
DBALLE_SQL_C_SINT_TYPE id_station
Station ID SQL parameter.
Definition: v6/data.h:68
void set_station_info()
Set id_lev_tr and datetime to mean 'station information'.
wreport::Varcode id_var
Variable type SQL parameter.
Definition: v6/data.h:76
ODBC statement.
Definition: internals.h:220
v6::DB & db
DB connection.
Definition: v6/data.h:51
void insert_or_fail(bool want_id=false)
Insert an entry into the data table, failing on conflicts.
SQL_TIMESTAMP_STRUCT date
Date SQL parameter.
Definition: v6/data.h:74
DB-ALLe database connection.
Definition: v6/db.h:87
SQLLEN value_ind
Variable value indicator.
Definition: v6/data.h:80
db::Statement * ioustm
Precompiled insert or update statement, for DBs where it is available.
Definition: v6/data.h:58
db::Statement * sidstm
Precompiled select ID statement.
Definition: v6/data.h:62
bool insert_or_ignore(bool want_id=false)
Insert an entry into the data table, ignoring conflicts.
db::Statement * istm
Precompiled insert statement.
Definition: v6/data.h:54
Precompiled query to manipulate the data table.
Definition: v6/data.h:48