Class SpannerPostgreSQLSequenceSupport

java.lang.Object

org.hibernate.dialect.sequence.PostgreSQLSequenceSupport

org.hibernate.dialect.sequence.SpannerPostgreSQLSequenceSupport

All Implemented Interfaces:

SequenceSupport

public class SpannerPostgreSQLSequenceSupport
extends PostgreSQLSequenceSupport

Field Summary

Fields inherited from class PostgreSQLSequenceSupport

INSTANCE

Constructor Summary

Constructors

Constructor	Description
SpannerPostgreSQLSequenceSupport(SpannerPostgreSQLDialect dialect)

Method Summary

Modifier and Type	Method	Description
String	getCreateSequenceString(String sequenceName, int initialValue, int incrementSize)	Typically, dialects which support sequences can create a sequence with a single command.
String	getRestartSequenceString(String sequenceName, long startWith)	A DDL statement to restart a sequence with a given value.
String	getSelectSequenceNextValString(String sequenceName)	Generate the select expression fragment that will retrieve the next value of a sequence as part of another (typically DML) statement.
String	getSelectSequencePreviousValString(String sequenceName)	Generate the select expression fragment that will retrieve the previous value of a sequence as part of another (typically DML) statement.
boolean	supportsPooledSequences()	Does this dialect support "pooled" sequences.

Methods inherited from class PostgreSQLSequenceSupport

getDropSequenceString, sometimesNeedsStartingValue

Methods inherited from class Object

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

Methods inherited from interface SequenceSupport

getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getDropSequenceStrings, getFromDual, getSequenceNextValString, getSequenceNextValString, getSequencePreviousValString, startingValue, supportsSequences

Constructor Details

SpannerPostgreSQLSequenceSupport

public SpannerPostgreSQLSequenceSupport(SpannerPostgreSQLDialect dialect)

Method Details

supportsPooledSequences

public boolean supportsPooledSequences()

Description copied from interface: SequenceSupport

Does this dialect support "pooled" sequences. Not aware of a better name for this. Essentially can we specify the initial and increment values?

Returns:

True if such "pooled" sequences are supported; false otherwise.

See Also:

• SequenceSupport.getCreateSequenceStrings(String, int, int)
• SequenceSupport.getCreateSequenceString(String, int, int)

getCreateSequenceString

public String getCreateSequenceString(String sequenceName,
 int initialValue,
 int incrementSize)
                               throws MappingException

Description copied from interface: SequenceSupport

Typically, dialects which support sequences can create a sequence with a single command. This method is a convenience making it easier to implement SequenceSupport.getCreateSequenceStrings(String,int,int) for these dialects.

Overloaded form of SequenceSupport.getCreateSequenceString(String), additionally taking the initial value and increment size to be applied to the sequence definition.

The default definition is to suffix SequenceSupport.getCreateSequenceString(String) with the string: start with initialValue increment by incrementSize for the arguments initialValue and incrementSize. Dialects need to override this method if different key phrases are used to apply the allocation information.

Parameters:

sequenceName - The name of the sequence

initialValue - The initial value to apply to 'create sequence' statement

incrementSize - The increment value to apply to 'create sequence' statement

Returns:

The sequence creation command

Throws:

MappingException - If sequences are not supported.

getRestartSequenceString

public String getRestartSequenceString(String sequenceName,
 long startWith)

Description copied from interface: SequenceSupport

A DDL statement to restart a sequence with a given value.

Parameters:

sequenceName - The name of the sequence

startWith - The value to restart at

Returns:

The alter sequence ... restart command

getSelectSequenceNextValString

public String getSelectSequenceNextValString(String sequenceName)

Description copied from interface: SequenceSupport

Generate the select expression fragment that will retrieve the next value of a sequence as part of another (typically DML) statement.

This differs from SequenceSupport.getSequenceNextValString(String) in that it must return an expression usable within another statement.

Specified by:

getSelectSequenceNextValString in interface SequenceSupport

Overrides:

getSelectSequenceNextValString in class PostgreSQLSequenceSupport

Parameters:

sequenceName - the name of the sequence

Returns:

The "next value" fragment.

getSelectSequencePreviousValString

public String getSelectSequencePreviousValString(String sequenceName)
                                          throws MappingException

Description copied from interface: SequenceSupport

Generate the select expression fragment that will retrieve the previous value of a sequence as part of another (typically DML) statement.

This differs from SequenceSupport.getSequencePreviousValString(String) in that it must return an expression usable within another statement.

Specified by:

getSelectSequencePreviousValString in interface SequenceSupport

Overrides:

getSelectSequencePreviousValString in class PostgreSQLSequenceSupport

Parameters:

sequenceName - the name of the sequence

Returns:

The "previous value" fragment.

Throws:

MappingException - If sequences are not supported.