Class SetInactivity

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.SetInactivity

public class SetInactivity
extends DAO

A Data Access Object to update the Inactivity Purge table.

Since:

1.0

Version:

9.0

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
void	delete(int pilotID)	Removes a Pilot's inactivity purge entry.
void	purge()	Purge all inactivity entries with a purge date in the past.
void	setInactivity(int pilotID, int days, boolean isNotified)	Sets the inactivity purge entry for a Pilot.

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

SetInactivity

public SetInactivity(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

setInactivity

public void setInactivity(int pilotID,
 int days,
 boolean isNotified)
                   throws DAOException

Sets the inactivity purge entry for a Pilot.

Parameters:

pilotID - the Pilot's database ID

days - the number of days from today to purge

isNotified - TRUE if the warning message has been sent, otherwise FALSE

Throws:

DAOException - if a JDBC error occurs

delete

public void delete(int pilotID)
            throws DAOException

Removes a Pilot's inactivity purge entry.

Parameters:

pilotID - the Pilot's database ID

Throws:

DAOException - if a JDBC error occurs

purge

public void purge()
           throws DAOException

Purge all inactivity entries with a purge date in the past.

Throws:

DAOException - if a JDBC error occurs