Package org.postgresql.util

Class PGInterval

java.lang.Object

org.postgresql.util.PGobject

org.postgresql.util.PGInterval

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable

public class PGInterval
extends PGobject
implements java.io.Serializable, java.lang.Cloneable

This implements a class that handles the PostgreSQL interval type.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
private int	days
private int	hours
private boolean	isNull
private static int	MICROS_IN_SECOND
private int	microSeconds
private int	minutes
private int	months
private int	wholeSeconds
private int	years

Fields inherited from class org.postgresql.util.PGobject

type, value

Constructor Summary

Constructors

Constructor	Description
PGInterval()	required by the driver.
PGInterval(int years, int months, int days, int hours, int minutes, double seconds)	Initializes all values of this interval to the specified values.
PGInterval(java.lang.String value)	Initialize a interval with a given interval string representation.

Method Summary

Modifier and Type	Method	Description
void	add(java.util.Calendar cal)	Rolls this interval on a given calendar.
void	add(java.util.Date date)	Rolls this interval on a given date.
void	add(PGInterval interval)	Add this interval's value to the passed interval.
java.lang.Object	clone()	This must be overridden to allow the object to be cloned.
boolean	equals(java.lang.Object obj)	Returns whether an object is equal to this one or not.
int	getDays()	Returns the days represented by this interval.
int	getHours()	Returns the hours represented by this interval.
int	getMicroSeconds()
int	getMinutes()	Returns the minutes represented by this interval.
int	getMonths()	Returns the months represented by this interval.
double	getSeconds()	Returns the seconds represented by this interval.
java.lang.String	getValue()	Returns the stored interval information as a string.
int	getWholeSeconds()
int	getYears()	Returns the years represented by this interval.
int	hashCode()	Returns a hashCode for this object.
private int	lookAhead(java.lang.String value, int position, java.lang.String find)
private static double	nullSafeDoubleGet(java.lang.String value)	Returns double value of value or 0 if value is null.
private static int	nullSafeIntGet(java.lang.String value)	Returns integer value of value or 0 if value is null.
private void	parseISO8601Format(java.lang.String value)
void	scale(int factor)	Scale this interval by an integer factor.
void	setDays(int days)	Set the days of this interval to the specified value.
void	setHours(int hours)	Set the hours of this interval to the specified value.
void	setMinutes(int minutes)	Set the minutes of this interval to the specified value.
void	setMonths(int months)	Set the months of this interval to the specified value.
void	setSeconds(double seconds)	Set the seconds of this interval to the specified value.
void	setValue(int years, int months, int days, int hours, int minutes, double seconds)	Set all values of this interval to the specified values.
void	setValue(java.lang.String value)	Sets a interval string represented value to this instance.
void	setYears(int years)	Set the years of this interval to the specified value.

Methods inherited from class org.postgresql.util.PGobject

equals, getType, isNull, setType, toString

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

MICROS_IN_SECOND

private static final int MICROS_IN_SECOND

See Also:

Constant Field Values

years

private int years

months

private int months

days

private int days

hours

private int hours

minutes

private int minutes

wholeSeconds

private int wholeSeconds

microSeconds

private int microSeconds

isNull

private boolean isNull

Constructor Detail

PGInterval

public PGInterval()

required by the driver.

PGInterval

public PGInterval(java.lang.String value)
           throws java.sql.SQLException

Initialize a interval with a given interval string representation.

Parameters:

value - String representated interval (e.g. '3 years 2 mons')

Throws:

java.sql.SQLException - Is thrown if the string representation has an unknown format

See Also:

PGobject.setValue(String)

PGInterval

public PGInterval(int years,
                  int months,
                  int days,
                  int hours,
                  int minutes,
                  double seconds)

Initializes all values of this interval to the specified values.

Parameters:

years - years

months - months

days - days

hours - hours

minutes - minutes

seconds - seconds

See Also:

setValue(int, int, int, int, int, double)

Method Detail

lookAhead

private int lookAhead(java.lang.String value,
                      int position,
                      java.lang.String find)

parseISO8601Format

private void parseISO8601Format(java.lang.String value)

setValue

public void setValue(java.lang.String value)
              throws java.sql.SQLException

Sets a interval string represented value to this instance. This method only recognize the format, that Postgres returns - not all input formats are supported (e.g. '1 yr 2 m 3 s').

Overrides:

setValue in class PGobject

Parameters:

value - String representated interval (e.g. '3 years 2 mons')

Throws:

java.sql.SQLException - Is thrown if the string representation has an unknown format

setValue

public void setValue(int years,
                     int months,
                     int days,
                     int hours,
                     int minutes,
                     double seconds)

Set all values of this interval to the specified values.

Parameters:

years - years

months - months

days - days

hours - hours

minutes - minutes

seconds - seconds

getValue

public java.lang.String getValue()

Returns the stored interval information as a string.

Overrides:

getValue in class PGobject

Returns:

String represented interval

getYears

public int getYears()

Returns the years represented by this interval.

Returns:

years represented by this interval

setYears

public void setYears(int years)

Set the years of this interval to the specified value.

Parameters:

years - years to set

getMonths

public int getMonths()

Returns the months represented by this interval.

Returns:

months represented by this interval

setMonths

public void setMonths(int months)

Set the months of this interval to the specified value.

Parameters:

months - months to set

getDays

public int getDays()

Returns the days represented by this interval.

Returns:

days represented by this interval

setDays

public void setDays(int days)

Set the days of this interval to the specified value.

Parameters:

days - days to set

getHours

public int getHours()

Returns the hours represented by this interval.

Returns:

hours represented by this interval

setHours

public void setHours(int hours)

Set the hours of this interval to the specified value.

Parameters:

hours - hours to set

getMinutes

public int getMinutes()

Returns the minutes represented by this interval.

Returns:

minutes represented by this interval

setMinutes

public void setMinutes(int minutes)

Set the minutes of this interval to the specified value.

Parameters:

minutes - minutes to set

getSeconds

public double getSeconds()

Returns the seconds represented by this interval.

Returns:

seconds represented by this interval

getWholeSeconds

public int getWholeSeconds()

getMicroSeconds

public int getMicroSeconds()

setSeconds

public void setSeconds(double seconds)

Set the seconds of this interval to the specified value.

Parameters:

seconds - seconds to set

add

public void add(java.util.Calendar cal)

Rolls this interval on a given calendar.

Parameters:

cal - Calendar instance to add to

add

public void add(java.util.Date date)

Rolls this interval on a given date.

Parameters:

date - Date instance to add to

add

public void add(PGInterval interval)

Add this interval's value to the passed interval. This is backwards to what I would expect, but this makes it match the other existing add methods.

Parameters:

interval - intval to add

scale

public void scale(int factor)

Scale this interval by an integer factor. The server can scale by arbitrary factors, but that would require adjusting the call signatures for all the existing methods like getDays() or providing our own justification of fractional intervals. Neither of these seem like a good idea without a strong use case.

Parameters:

factor - scale factor

nullSafeIntGet

private static int nullSafeIntGet(java.lang.String value)
                           throws java.lang.NumberFormatException

Returns integer value of value or 0 if value is null.

Parameters:

value - integer as string value

Returns:

integer parsed from string value

Throws:

java.lang.NumberFormatException - if the string contains invalid chars

nullSafeDoubleGet

private static double nullSafeDoubleGet(java.lang.String value)
                                 throws java.lang.NumberFormatException

Returns double value of value or 0 if value is null.

Parameters:

value - double as string value

Returns:

double parsed from string value

Throws:

java.lang.NumberFormatException - if the string contains invalid chars

equals

public boolean equals(java.lang.Object obj)

Returns whether an object is equal to this one or not.

Overrides:

equals in class PGobject

Parameters:

obj - Object to compare with

Returns:

true if the two intervals are identical

hashCode

public int hashCode()

Returns a hashCode for this object.

Overrides:

hashCode in class PGobject

Returns:

hashCode

clone

public java.lang.Object clone()
                       throws java.lang.CloneNotSupportedException

Description copied from class: PGobject

This must be overridden to allow the object to be cloned.

Overrides:

clone in class PGobject

Throws:

java.lang.CloneNotSupportedException