Precompiled queries to manipulate the station table. More...

#include <station.h>

Public Member Functions
	Station (db::Connection &conn)

void	set_ident (const char *ident)
	Set the mobile station identifier input value for this ::dba_db_station. More...

int	get_id ()
	Get the station ID given latitude, longitude and mobile identifier. More...

void	get_data (int id)
	Get station information given a station ID. More...

int	insert ()
	Insert a new station entry. More...

void	update ()
	Update the information about a station entry.

void	remove ()
	Remove a station record.

void	dump (FILE *out)
	Dump the entire contents of the table to an output stream.

Static Public Member Functions
static void	reset_db (db::Connection &conn)
	Clear (if applicable) and recreate the table structure in the database.

Data Fields
db::Connection &	conn
	DB connection.

db::Sequence *	seq_station
	Station ID sequence, when the DB requires it.

db::Statement *	sfstm
	Precompiled select fixed station query.

db::Statement *	smstm
	Precompiled select mobile station query.

db::Statement *	sstm
	Precompiled select data by station id query.

db::Statement *	istm
	Precompiled insert query.

db::Statement *	ustm
	Precompiled update query.

db::Statement *	dstm
	Precompiled delete query.

DBALLE_SQL_C_SINT_TYPE	id
	Station ID SQL parameter.

DBALLE_SQL_C_SINT_TYPE	lat
	Station latitude SQL parameter.

DBALLE_SQL_C_SINT_TYPE	lon
	Station longitude SQL parameter.

char	ident [64]
	Mobile station identifier SQL parameter.

SQLLEN	ident_ind
	Mobile station identifier indicator.

Detailed Description

Precompiled queries to manipulate the station table.

Member Function Documentation

void dballe::db::v5::Station::get_data ( int id )

Get station information given a station ID.

Parameters

id	ID of the station to query

int dballe::db::v5::Station::get_id ( )

Get the station ID given latitude, longitude and mobile identifier.

int dballe::db::v5::Station::insert ( )

Insert a new station entry.

Return values

id	ID of the newly inserted station

void dballe::db::v5::Station::set_ident ( const char * ident )

Set the mobile station identifier input value for this ::dba_db_station.

Parameters

ident Value to use for ident. NULL can be used to unset ident.

The documentation for this struct was generated from the following file: