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