Class SetCachedRoutes

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.SetCachedRoutes

public class SetCachedRoutes
extends DAO

A Data Access Object to saved cached flight routes to the database.

Since:

2.6

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
SetCachedRoutes(Connection c)	Initializes the Data Access Object.

Method Summary

Modifier and Type	Method	Description
int	purge(int days)	Purges routes older than a certain date.
void	purge(RoutePair rp)	Purges all saved routes between two airports from the database.
void	write(Collection<? extends FlightRoute> routes)	Writes a number of Flight routes to the database.

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

SetCachedRoutes

public SetCachedRoutes(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

write

public void write(Collection<? extends FlightRoute> routes)
           throws DAOException

Writes a number of Flight routes to the database.

Parameters:

routes -

Throws:

DAOException

purge

public void purge(RoutePair rp)
           throws DAOException

Purges all saved routes between two airports from the database.

Parameters:

rp - the RoutePair

Throws:

DAOException - if a JDBC error occurs

purge

public int purge(int days)
          throws DAOException

Purges routes older than a certain date.

Parameters:

days - the number of days old to purge

Returns:

the number of routes purged

Throws:

DAOException - if a JDBC error occurs