Class GetRawScheduleInfo

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetRawScheduleInfo

public class GetRawScheduleInfo
extends DAO

A Data Access Object to load raw flight schedule information.

Since:

9.0

Version:

10.2

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
List<Airport>	getArrivalAirports(ScheduleSource src, Airport aD)	Returns arrival Airports for a particular raw schedule source.
Collection<Integer>	getFlightNumbers(Airline a, int start, int end)	Returns all flight numbers in a particular range.
int	getNextLeg(Airline a, int flightNumber)	Returns the next available Leg number for a Flight.
int	getNextManualEntryLine()	Returns the first available "line number" for manually entered raw schedule entries.
List<Airport>	getOriginAirports(ScheduleSource src, Airport aA)	Returns departure Airports for a particular raw schedule source.

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

GetRawScheduleInfo

public GetRawScheduleInfo(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getNextManualEntryLine

public int getNextManualEntryLine()
                           throws DAOException

Returns the first available "line number" for manually entered raw schedule entries.

Returns:

the next line number

Throws:

DAOException - if a JDBC error occurs

getNextLeg

public int getNextLeg(Airline a,
 int flightNumber)
               throws DAOException

Returns the next available Leg number for a Flight.

Parameters:

a - the Airline bean

flightNumber - the flight number

Returns:

the next available leg number

Throws:

DAOException - if a JDBC error occurs

getOriginAirports

public List<Airport> getOriginAirports(ScheduleSource src,
 Airport aA)
                                throws DAOException

Returns departure Airports for a particular raw schedule source.

Parameters:

src - the ScheduleSource, or null for all sources

aA - the arrival Airport, or null for all flights

Returns:

a List of Airport beans

Throws:

DAOException - if a JDBC error occurs

getArrivalAirports

public List<Airport> getArrivalAirports(ScheduleSource src,
 Airport aD)
                                 throws DAOException

Returns arrival Airports for a particular raw schedule source.

Parameters:

src - the ScheduleSource, or null for all sources

aD - the departure Airport, or null for all flights

Returns:

a List of Airport beans

Throws:

DAOException - if a JDBC error occurs

getFlightNumbers

public Collection<Integer> getFlightNumbers(Airline a,
 int start,
 int end)
                                     throws DAOException

Returns all flight numbers in a particular range.

Parameters:

a - the Airline bean

start - the start of the range, or zero if none specified

end - the end of the range, or zero if none specified

Returns:

a Collection of Integers with flight numbers

Throws:

DAOException - if a JDBC error occurs