Class GetACARSPurge
java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetACARSData
org.deltava.dao.GetACARSPurge
A Data Access Object used to get information for purging the ACARS data tables.
- Since:
- 3.2
- Version:
- 10.1
- Author:
- Luke
-
Field Summary
Fields inherited from class org.deltava.dao.DAO
_queryMax, _queryStart, _queryTimeout, WGS84_SRID
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptiongetPositionFlightIDs
(int hours) Retrieves Flight IDs for position entries older than a particular number of hours.getUnreportedFlights
(int cutoff) Returns all Flight Information entries without an associated Flight Report.Returns the IDs of all ACARS flights marked as archived with unarchived position entries.Returns the IDs of all ACARS flights marked as archived with unarchived position entries.Methods inherited from class org.deltava.dao.GetACARSData
executeConnectionInfo, executeFlightInfo, getArchiveInfo, getConnection, getInfo, getLandingRunway, getRoute, getTakeoffLanding, getTerminalRoutes
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
-
Constructor Details
-
GetACARSPurge
Initializes the Data Access Object.- Parameters:
c
- the JDBC connection to use
-
-
Method Details
-
getUnreportedFlights
Returns all Flight Information entries without an associated Flight Report. A cutoff interval is provided to prevent the accidental inclusion of flights still in progress.- Parameters:
cutoff
- the cutoff interval for flight entries, in hours- Returns:
- a List of InfoEntry beans sorted by date
- Throws:
DAOException
- if a JDBC error occurs
-
getPositionFlightIDs
Retrieves Flight IDs for position entries older than a particular number of hours.- Parameters:
hours
- the number of hours- Returns:
- a Collection of ACARS Flight IDs
- Throws:
DAOException
- if a JDBC error occurs
-
getUnsynchedACARSFlights
Returns the IDs of all ACARS flights marked as archived with unarchived position entries.- Returns:
- a Collection of flight IDs
- Throws:
DAOException
- if a JDBC error occurs
-
getUnsynchedXACARSFlights
Returns the IDs of all ACARS flights marked as archived with unarchived position entries.- Returns:
- a Collection of flight IDs
- Throws:
DAOException
- if a JDBC error occurs
-