Class GetScheduleInfo

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetScheduleInfo

public class GetScheduleInfo
extends DAO

A Data Access Object to extract Flight Schedule data.

Since:

1.0

Version:

10.5

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
Map<Airline,Integer>	getAirlineCounts(String dbName)	Returns the number of flights in the schedule per Airline.
Collection<Country>	getCountries()	Returns the Countries served by Airports in the Flight Schedule.
int	getFlightCount()	Returns the size of the Flight Schedule.
Collection<ScheduleSourceHistory>	getHistory()	Returns schedule filter history.

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

GetScheduleInfo

public GetScheduleInfo(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getFlightCount

public int getFlightCount()
                   throws DAOException

Returns the size of the Flight Schedule.

Returns:

the number of legs

Throws:

DAOException - if a JDBC error occurs

getCountries

public Collection<Country> getCountries()
                                 throws DAOException

Returns the Countries served by Airports in the Flight Schedule.

Returns:

a Collection of Country beans

Throws:

DAOException - if a JDBC error occurs

getAirlineCounts

public Map<Airline,Integer> getAirlineCounts(String dbName)
                                      throws DAOException

Returns the number of flights in the schedule per Airline.

Parameters:

dbName - the database name

Returns:

a Map of Integers, keyed by Airline

Throws:

DAOException - if a JDBC error occurs

getHistory

public Collection<ScheduleSourceHistory> getHistory()
                                             throws DAOException

Returns schedule filter history.

Returns:

a Collection of ScheduleSourceHistory beans

Throws:

DAOException - if a JDBC error occurs