com.dpslink.flash.db

Class SiteActivityController

java.lang.Object

com.dpslink.base.obj.MappedAttributesObject

com.dpslink.base.jdbc.JDBCObjectController<SiteActivity>

com.dpslink.flash.db.SiteActivityController

All Implemented Interfaces:

java.io.Serializable

public class SiteActivityController
extends JDBCObjectController<SiteActivity>

The controller for the SiteActivity class. Provides methods for retrieving and persisting site activity table records in the database.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
private static long	serialVersionUID The class' serialization version id.

Fields inherited from class com.dpslink.base.jdbc.JDBCObjectController

ivDBObjCls, ivFieldCount, ivFieldKeyAlt, ivFieldKeyPri, ivFieldResPfx, ivSyncLast, ivSyncType, ivTableName

Fields inherited from class com.dpslink.base.obj.MappedAttributesObject

ivHashCode, ivHashFlds, ivObjAttrs

Constructor Summary

Constructors

Constructor and Description
SiteActivityController() The constructor for the controller.

Method Summary

Modifier and Type	Method and Description
boolean	deleteDate(java.util.Date asof) Deletes the site activity records that were created before the given date.
java.lang.Object[]	getAccessAsRS(java.lang.String type, java.util.Date from, java.util.Date thru) Returns a result set of the site activity access values for the given type and date range.
java.lang.Object[]	getLocationsAsRS(int activity, int location, java.util.Date from, java.util.Date thru) Returns a result set of the site activity location values for the given activity type, location type and date range.
int	getPurgeCount(java.util.Date asof) Returns the number of site activity records that were created before the given date.
java.lang.Object[]	getSummaryAsRS(java.util.Date from, java.util.Date thru) Returns a result set of the site activity summary values for the given date range.
java.lang.Object[]	getTrendsAsRS(int activity, int trend, java.util.Date from, java.util.Date thru) Returns a result set of the site activity trend values for the given activity type, trend type and date range.

Methods inherited from class com.dpslink.base.jdbc.JDBCObjectController

add, add, add, arrayToMap, arrayToMap, countAll, delete, delete, deleteAll, dispose, equals, getAll, getConnection, getConnectionInfo, getController, getFieldNames, getFieldNamesForKey, getFieldNamesForUpdate, getFieldNulls, getFieldNullsForKey, getFieldNullsForUpdate, getFieldsForOrderBy, getFieldsForWhere, getFieldSize, getFieldTypes, getFieldTypesForKey, getFieldTypesForUpdate, getStatementForDelete, getStatementForGet, getStatementForGetAll, getStatementForInsert, getStatementForUpdate, getStatementKey, getStatementString, getTableName, hasFieldNamesForKey, hasFieldNamesForUpdate, isDuplicate, resultSetToArray, resultSetToMap, resultSetToMap, resultSetToObject, setConnectionInfo, setPSDeleteValues, setPSExistsValues, setPSInsertValues, setPSUpdateValues, setPSValue, update, update, valuesToObject

Methods inherited from class com.dpslink.base.obj.MappedAttributesObject

cloneMapAttributes, formatValue, formatValue, getHashFields, getMapArrayList, getMapAttributes, getMapBigDecimal, getMapBoolean, getMapDate, getMapDouble, getMapInteger, getMapLong, getMapMapped, getMapObject, getMapShort, getMapString, getMapString, getMapStringBuffer, getMapStringBuilder, getMapTime, getMapTimestamp, getMapVector, hashCode, setHashFields, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMapAttributes, setMapObject, setMapTime, setMapTimestamp, toStringArray

Methods inherited from class java.lang.Object

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

Field Detail

serialVersionUID

private static final long serialVersionUID

The class' serialization version id.

See Also:

Constant Field Values

Constructor Detail

SiteActivityController

public SiteActivityController()

The constructor for the controller.

Method Detail

deleteDate

public boolean deleteDate(java.util.Date asof)

Deletes the site activity records that were created before the given date.

Parameters:

asof - (java.util.Date) The cutoff date for the desired records.

Returns:

boolean - true if the deletes were successful, otherwise false.

getAccessAsRS

public java.lang.Object[] getAccessAsRS(java.lang.String type,
                                        java.util.Date from,
                                        java.util.Date thru)

Returns a result set of the site activity access values for the given type and date range.

The invoker of this method is responsible for closing the returned result set and prepared statement.

Parameters:

type - (String) The type of access activity to retrieve.

from - (Date) The first date to include in the results.

thru - (Date) The last date to include in the results.

Returns:

Object[] - An object array containing the result set ([0]) and the prepared statement ([1]) used to obtain the result set.

getLocationsAsRS

public java.lang.Object[] getLocationsAsRS(int activity,
                                           int location,
                                           java.util.Date from,
                                           java.util.Date thru)

Returns a result set of the site activity location values for the given activity type, location type and date range.

The invoker of this method is responsible for closing the returned result set and prepared statement.

Parameters:

activity - (int) The activity type to use for selecting records in the site activity table.

location - (int) The location type to use for selecting records in the site activity table.

from - (Date) The first date to include in the results.

thru - (Date) The last date to include in the results.

Returns:

Object[] - An object array containing the result set ([0]) and the prepared statement ([1]) used to obtain the result set.

getPurgeCount

public int getPurgeCount(java.util.Date asof)

Returns the number of site activity records that were created before the given date.

Parameters:

asof - (java.util.Date) The cutoff date for the desired records.

Returns:

int - The number of matching records.

getSummaryAsRS

public java.lang.Object[] getSummaryAsRS(java.util.Date from,
                                         java.util.Date thru)

Returns a result set of the site activity summary values for the given date range.

The invoker of this method is responsible for closing the returned result set and prepared statement.

Parameters:

from - (Date) The first date to include in the results.

thru - (Date) The last date to include in the results.

Returns:

Object[] - An object array containing the result set ([0]) and the prepared statement ([1]) used to obtain the result set.

getTrendsAsRS

public java.lang.Object[] getTrendsAsRS(int activity,
                                        int trend,
                                        java.util.Date from,
                                        java.util.Date thru)

Returns a result set of the site activity trend values for the given activity type, trend type and date range.

The invoker of this method is responsible for closing the returned result set and prepared statement.

Parameters:

activity - (int) The activity type to use for selecting records in the site activity table.

trend - (int) The trend type to use for selecting records in the site activity table.

from - (Date) The first date to include in the results.

thru - (Date) The last date to include in the results.

Returns:

Object[] - An object array containing the result set ([0]) and the prepared statement ([1]) used to obtain the result set.