Class GetAcademyInactivity

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetAcademyInactivity

public class GetAcademyInactivity
extends DAO

A Data Access Object to select dormant Flight Academy courses.

Since:

6.3

Version:

9.0

Author:

Luke

Field Summary

Fields inherited from class DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
Map<Integer,Integer>	getInactiveCourses(int interval, String dbName)	Returns inactive Flight Academy courses from a particular Airline.

Methods inherited from class 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 Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

GetAcademyInactivity

public GetAcademyInactivity(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getInactiveCourses

public Map<Integer,Integer> getInactiveCourses(int interval,
 String dbName)
                                        throws DAOException

Returns inactive Flight Academy courses from a particular Airline. This will return Courses that have had no completed progress, chats or submitted examinations/check rides within the specified interval.

Parameters:

interval - the interval since last activity

dbName - the databasae to query

Returns:

a Map of Course IDs and intervals since last activity in days

Throws:

DAOException - if a JDBC error occurs