libdballe  5.18
Data Structures | Defines
db.h File Reference

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...

Defines

#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.

Detailed Description

Functions used to connect to DB-All.e and insert, query and delete data.


Define Documentation

#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