Class GetAggregateStatistics

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetAggregateStatistics

public class GetAggregateStatistics
extends DAO

A Data Access Object to read aggregated Flight Report statistics.

Since:

6.2

Version:

11.4

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

Constructor	Description
GetAggregateStatistics(Connection c)	Initializes the Data Access Object.

Method Summary

Modifier and Type	Method	Description
Collection<Integer>	getAggregateQueue()	Retrieves entries from the Flight Report aggregation queue.
Collection<FlightStatsEntry>	getAirportStatistics(FlightStatsSort s, int apType)	Retrieves aggregated approved Flight Report statistics.
Collection<OnlineStatsEntry>	getOnlineStatistics(FlightStatsSort srt, FlightStatsGroup grp)	Returns online network flight statstics by date.
Collection<FlightStatsEntry>	getPIREPStatistics(FlightStatsSort s, FlightStatsGroup grp)	Retrieves aggregated Flight Report statistics.
Collection<FlightStatsEntry>	getSimStatistics(FlightStatsSort s, FlightStatsGroup grp)	Retrieves aggregated approved Flight Report statistics.

Methods inherited from class org.deltava.dao.DAO

commitTransaction, createTimestamp, executeIDs, executeUpdate, executeUpdate, expandDate, formatDBName, formatLocation, getNewID, getQueryCount, prepare, prepareWithoutLimits, rollbackTransaction, setQueryMax, setQueryStart, setQueryTimeout, startTransaction, toID, toID, toInstant

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

GetAggregateStatistics

public GetAggregateStatistics(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getAggregateQueue

public Collection<Integer> getAggregateQueue()
                                      throws DAOException

Retrieves entries from the Flight Report aggregation queue.

Returns:

a Collection of Flight Report database IDs

Throws:

DAOException - if a JDBC error occurs

getSimStatistics

public Collection<FlightStatsEntry> getSimStatistics(FlightStatsSort s,
 FlightStatsGroup grp)
                                              throws DAOException

Retrieves aggregated approved Flight Report statistics.

Parameters:

s - the statistics sorting option

grp - the statistics grouping option

Returns:

a Collection of FlightStatsEntry beans

Throws:

DAOException - if a JDBC error occurs

getAirportStatistics

public Collection<FlightStatsEntry> getAirportStatistics(FlightStatsSort s,
 int apType)
                                                  throws DAOException

Retrieves aggregated approved Flight Report statistics.

Parameters:

s - the sorting option

apType - the airport type, 1 for departure and 2 for arrival, 0 for all

Returns:

a Collection of FlightStatsEntry beans

Throws:

DAOException - if a JDBC error occurs

getOnlineStatistics

public Collection<OnlineStatsEntry> getOnlineStatistics(FlightStatsSort srt,
 FlightStatsGroup grp)
                                                 throws DAOException

Returns online network flight statstics by date.

Parameters:

srt - the FlightStatsSort option

grp - the FlightStatsGroup option

Returns:

a Collection of OnlineStatsEntry beans

Throws:

DAOException - if a JDBC error occurs

getPIREPStatistics

public Collection<FlightStatsEntry> getPIREPStatistics(FlightStatsSort s,
 FlightStatsGroup grp)
                                                throws DAOException

Retrieves aggregated Flight Report statistics.

Parameters:

s - the statistics sorting option

grp - the statistics grouping option

Returns:

a Collection of FlightStatsEntry beans

Throws:

DAOException - if a JDBC error occurs