22 #ifndef DBALLE_DB_V5_CONTEXT_H
23 #define DBALLE_DB_V5_CONTEXT_H
63 DBALLE_SQL_C_SINT_TYPE
id;
74 DBALLE_SQL_C_SINT_TYPE
l1;
78 DBALLE_SQL_C_SINT_TYPE
l2;
80 DBALLE_SQL_C_SINT_TYPE
pind;
82 DBALLE_SQL_C_SINT_TYPE
p1;
84 DBALLE_SQL_C_SINT_TYPE
p2;
131 void dump(FILE* out);
v5::DB & db
DB connection.
Definition: db/v5/context.h:51
DB-ALLe database connection.
Definition: v5/db.h:83
db::Statement * sdstm
Precompiled select data statement.
Definition: db/v5/context.h:56
DBALLE_SQL_C_SINT_TYPE pind
Time range type SQL parameter.
Definition: db/v5/context.h:80
void get_data(int id)
Get context information given a context ID.
int obtain_station_info()
Get the context id for a station info context.
Precompiled queries to manipulate the context table.
Definition: db/v5/context.h:46
The ODBC specification is imperfect with regards to integer sizes on 64bit platforms, and different ODBC drivers are currently interpreting it differently.
DBALLE_SQL_C_SINT_TYPE ltype1
First level type SQL parameter.
Definition: db/v5/context.h:72
DBALLE_SQL_C_SINT_TYPE l1
Level L1 SQL parameter.
Definition: db/v5/context.h:74
DBALLE_SQL_C_SINT_TYPE ltype2
Second level type SQL parameter.
Definition: db/v5/context.h:76
DBALLE_SQL_C_SINT_TYPE p1
Time range P1 SQL parameter.
Definition: db/v5/context.h:82
int insert()
Insert a new context in the database.
DBALLE_SQL_C_SINT_TYPE id_station
Station ID SQL parameter.
Definition: db/v5/context.h:66
DBALLE_SQL_C_SINT_TYPE id_report
Report ID SQL parameter.
Definition: db/v5/context.h:68
db::Statement * istm
Precompiled insert statement.
Definition: db/v5/context.h:58
DBALLE_SQL_C_SINT_TYPE id
Context ID SQL parameter.
Definition: db/v5/context.h:63
DBALLE_SQL_C_SINT_TYPE l2
Level L2 SQL parameter.
Definition: db/v5/context.h:78
int get_id()
Get the context id for the current context data.
ODBC statement.
Definition: internals.h:220
DBALLE_SQL_C_SINT_TYPE p2
Time range P2 SQL parameter.
Definition: db/v5/context.h:84
db::Statement * dstm
Precompiled delete statement.
Definition: db/v5/context.h:60
void dump(FILE *out)
Dump the entire contents of the table to an output stream.
db::Statement * sstm
Precompiled select statement.
Definition: db/v5/context.h:54
SQL_TIMESTAMP_STRUCT date
Date SQL parameter.
Definition: db/v5/context.h:70