GetPilotOnline

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.PilotReadDAO

org.deltava.dao.GetPilotOnline

public class GetPilotOnline extends PilotReadDAO

A Data Access Object to load Pilot data for Online Network operations.

Since:: 1.0
Version:: 10.3
Author:: Luke

Field Summary

Fields inherited from class org.deltava.dao.PilotReadDAO
_cache

Fields inherited from class org.deltava.dao.DAO
_queryMax, _queryStart, _queryTimeout, WGS84_SRID
Constructor Summary

Constructors

Constructor

Description

GetPilotOnline(Connection c)

Initializes the Data Access Object.
Method Summary

Modifier and Type

Method

Description

Map<String,Integer>

getIDs(OnlineNetwork network)

Returns the network IDs for all Active/On leave pilots.

Collection<Pilot>

getPilots(OnlineNetwork network)

Returns all Pilots registered with an ID in a particular online network.

Methods inherited from class org.deltava.dao.PilotReadDAO
execute, get, get, get, getByID, getByName, loadAccomplishments, loadChildRows, loadIMAddrs, loadPushEndpoints, loadRatings, loadRoles, updatePilotCodes

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
- GetPilotOnline
  
  public GetPilotOnline(Connection c)
  
  Initializes the Data Access Object.
  
  Parameters:
  
  c - the JDBC connection to use
Method Details
- getIDs
  
  public Map<String,Integer> getIDs(OnlineNetwork network) throws DAOException
  
  Returns the network IDs for all Active/On leave pilots. This will return a Map with the network ID as the key, and the database ID of the Pilot as the value, allowing easy lookups of Pilots based on network ID.
  
  Parameters:
  
  network - the network
  
  Returns:
  
  a Map of network ID/database ID pairs
  
  Throws:
  
  DAOException - if a JDBC error occurs
- getPilots
  
  public Collection<Pilot> getPilots(OnlineNetwork network) throws DAOException
  
  Returns all Pilots registered with an ID in a particular online network. Flight Totals will not be populated.
  
  Parameters:
  
  network - the online network
  
  Returns:
  
  a List of Pilots
  
  Throws:
  
  DAOException - if a JDBC error occurs