Class GetACARSPurge


public class GetACARSPurge extends GetACARSData
A Data Access Object used to get information for purging the ACARS data tables.
Since:
3.2
Version:
10.1
Author:
Luke
  • Constructor Details

    • GetACARSPurge

      public GetACARSPurge(Connection c)
      Initializes the Data Access Object.
      Parameters:
      c - the JDBC connection to use
  • Method Details

    • getUnreportedFlights

      public List<FlightInfo> getUnreportedFlights(int cutoff) throws DAOException
      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

      public Collection<Integer> getPositionFlightIDs(int hours) throws DAOException
      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

      public Collection<Integer> getUnsynchedACARSFlights() throws DAOException
      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

      public Collection<Integer> getUnsynchedXACARSFlights() throws DAOException
      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