Package edu.ucsb.nceas.metacat.dataone.quota

Class QuotaDBManager

java.lang.Object

edu.ucsb.nceas.metacat.dataone.quota.QuotaDBManager

public class QuotaDBManager
extends Object

Represents a class to manipulate the usages table for the quota service in the postgresql database

Author:

tao

Field Summary

Fields

Modifier and Type	Field	Description
static final String	DATEREPORTED
static final String	INSTANCEID
static final String	NODEID
static final String	OBJECT
static final String	QUANTITY
static final String	QUOTAID
static final String	QUOTASUBJECT
static final String	QUOTATYPE
static final String	REQUESTOR
static final String	STATUS
static final String	TABLE
static final String	USAGELOCALID
static final String	USAGEREMOTEID

Constructor Summary

Constructors

Constructor	Description
QuotaDBManager()

Method Summary

Modifier and Type	Method	Description
static void	createUsage(org.dataone.bookkeeper.api.Usage usage, Date date)	Create a usage record in the usages table with the given date as the reported date If the date is null, it will create a usage record without the reported date
static ResultSet	getUnReportedUsages()	Get the result set from the table which haven't been reported to the bookkeeper server.
static int	lookupRemoteUsageId(int quotaId, String instanceId)	Find the remote usage id in the local database for the given quota id and instance id
static void	setReportedDateAndRemoteId(int localId, Date date, int remoteId)	Set the reported date and remote id for a given usage local id

Methods inherited from class java.lang.Object

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

Field Details

TABLE

public static final String TABLE

See Also:

• Constant Field Values

USAGELOCALID

public static final String USAGELOCALID

See Also:

• Constant Field Values

USAGEREMOTEID

public static final String USAGEREMOTEID

See Also:

• Constant Field Values

QUOTAID

public static final String QUOTAID

See Also:

• Constant Field Values

INSTANCEID

public static final String INSTANCEID

See Also:

• Constant Field Values

QUANTITY

public static final String QUANTITY

See Also:

• Constant Field Values

STATUS

public static final String STATUS

See Also:

• Constant Field Values

DATEREPORTED

public static final String DATEREPORTED

See Also:

• Constant Field Values

OBJECT

public static final String OBJECT

See Also:

• Constant Field Values

NODEID

public static final String NODEID

See Also:

• Constant Field Values

QUOTASUBJECT

public static final String QUOTASUBJECT

See Also:

• Constant Field Values

QUOTATYPE

public static final String QUOTATYPE

See Also:

• Constant Field Values

REQUESTOR

public static final String REQUESTOR

See Also:

• Constant Field Values

Constructor Details

QuotaDBManager

public QuotaDBManager()

Method Details

createUsage

public static void createUsage(org.dataone.bookkeeper.api.Usage usage,
 Date date)
                        throws SQLException

Create a usage record in the usages table with the given date as the reported date If the date is null, it will create a usage record without the reported date

Parameters:

usage - the usage will be record into the db table

date - the reported date associated with the usage. If it is null, the reported date will be blank in the table

Throws:

SQLException

setReportedDateAndRemoteId

public static void setReportedDateAndRemoteId(int localId,
 Date date,
 int remoteId)
                                       throws SQLException

Set the reported date and remote id for a given usage local id

Parameters:

localId - the local id of the usage will be set

date - the date to report to the bookkeeper server

remoteId - the remote id will be set

Throws:

SQLException

getUnReportedUsages

public static ResultSet getUnReportedUsages()
                                     throws SQLException

Get the result set from the table which haven't been reported to the bookkeeper server. The indication is the reported date is null in the usages table

Returns:

the result set which usages which haven't been reported to the bookkeeper server

Throws:

SQLException

lookupRemoteUsageId

public static int lookupRemoteUsageId(int quotaId,
 String instanceId)
                               throws SQLException

Find the remote usage id in the local database for the given quota id and instance id

Parameters:

quotaId - the quota id associated with the usage

instanceId - the instance id associated with the usage

Returns:

the remote usage id. If it is -1, which means there is no remote usage id found.

Throws:

SQLException