libdballe
5.18
|
Functions used to connect to DB-All.e and insert, query and delete data. More...
#include <dballe/db/odbcworkarounds.h>
#include <dballe/db/cursor.h>
#include <wreport/varinfo.h>
#include <string>
#include <vector>
#include <memory>
Go to the source code of this file.
Data Structures | |
class | dballe::DB |
DB-ALLe database connection. More... |
Macros | |
#define | DBA_DB_WANT_COORDS (1 << 0) |
Constants used to define what values we should retrieve from a query. | |
#define | DBA_DB_WANT_IDENT (1 << 1) |
Retrieve the mobile station identifier. | |
#define | DBA_DB_WANT_LEVEL (1 << 2) |
Retrieve the level information. | |
#define | DBA_DB_WANT_TIMERANGE (1 << 3) |
Retrieve the time range information. | |
#define | DBA_DB_WANT_DATETIME (1 << 4) |
Retrieve the date and time information. | |
#define | DBA_DB_WANT_VAR_NAME (1 << 5) |
Retrieve the variable name. | |
#define | DBA_DB_WANT_VAR_VALUE (1 << 6) |
Retrieve the variable value. | |
#define | DBA_DB_WANT_REPCOD (1 << 7) |
Retrieve the report code. | |
#define | DBA_DB_WANT_ANA_ID (1 << 8) |
Retrieve the station ID. | |
#define | DBA_DB_WANT_CONTEXT_ID (1 << 9) |
Retrieve the context ID. | |
#define | DBA_DB_MODIFIER_BEST (1 << 0) |
Values for query modifier flags. | |
#define | DBA_DB_MODIFIER_BIGANA (1 << 1) |
Tell the database optimizer that this is a query on a database with a big pseudoana table (this serves to hint the MySQL optimizer, which would not otherwise apply the correct strategy. | |
#define | DBA_DB_MODIFIER_DISTINCT (1 << 2) |
Remove duplicates in the results. | |
#define | DBA_DB_MODIFIER_ANAEXTRA (1 << 3) |
Include the extra anagraphical data in the results. | |
#define | DBA_DB_MODIFIER_NOANAEXTRA (1 << 4) |
Do not include the extra anagraphical data in the results. | |
#define | DBA_DB_MODIFIER_UNSORTED (1 << 5) |
Do not bother sorting the results. | |
#define | DBA_DB_MODIFIER_STREAM (1 << 6) |
Start geting the results as soon as they are available, without waiting for the database to finish building the result set. | |
#define | DBA_DB_MODIFIER_SORT_FOR_EXPORT (1 << 7) |
Sort by rep_cod after ana_id, to ease reconstructing messages on export. | |
#define | DBA_IMPORT_ATTRS 1 |
Flags controlling message import. | |
#define | DBA_IMPORT_FULL_PSEUDOANA 2 |
Flags controlling message import. | |
#define | DBA_IMPORT_DATETIME_ATTRS 4 |
Flags controlling message import. | |
#define | DBA_IMPORT_OVERWRITE 8 |
Flags controlling message import. | |
#define | DBA_IMPORT_NO_TRANSACTIONS 16 |
Flags controlling message import. |
Functions used to connect to DB-All.e and insert, query and delete data.
#define DBA_DB_MODIFIER_BEST (1 << 0) |
Values for query modifier flags.
When values from different reports exist on the same point, only report the one from the report with the highest priority
#define DBA_DB_MODIFIER_STREAM (1 << 6) |
Start geting the results as soon as they are available, without waiting for the database to finish building the result set.
As a side effect, it is impossible to know in advance the number of results. Currently, it does not work with the MySQL ODBC driver
#define DBA_DB_WANT_COORDS (1 << 0) |
Constants used to define what values we should retrieve from a query.
Retrieve latitude and longitude