Package org.pgcodekeeper.core.schema.pg

Class PgSequence

java.lang.Object

org.pgcodekeeper.core.schema.PgStatement

org.pgcodekeeper.core.schema.AbstractSequence

org.pgcodekeeper.core.schema.pg.PgSequence

All Implemented Interfaces:

IHashable, IRelation, ISearchPath, IStatement

public final class PgSequence
extends AbstractSequence

PostgreSQL sequence implementation. Sequences generate unique numeric identifiers, commonly used for auto-incrementing primary keys. Supports various data types, caching, cycling, and ownership by table columns.

Field Summary

Fields inherited from class org.pgcodekeeper.core.schema.PgStatement

GO

Constructor Summary

Constructors

Constructor	Description
PgSequence(String name)	Creates a new PostgreSQL sequence with default cache value of 1.

Method Summary

Modifier and Type	Method	Description
ObjectState	appendAlterSQL(PgStatement newCondition, SQLScript script)	Fill script with object changes and return change type
boolean	compare(PgStatement obj)	This method does not account for nested child PgStatements.
void	computeHash(Hasher hasher)	Computes the hash of the implementing object using the provided hasher.
void	fillSequenceBody(StringBuilder sbSQL)	Fills the sequence body SQL definition.
void	getCreationSQL(SQLScript script)	Generates the SQL statements needed to create this database object.
GenericColumn	getOwnedBy()	Gets the table column that owns this sequence.
boolean	isLogged()	Checks if this sequence is logged (written to WAL).
void	setDataType(String dataType)
void	setLogged(boolean isLogged)
void	setMinMaxInc(long inc, Long max, Long min, String dataType, long precision)	Sets the minimum, maximum, and increment values for this sequence.
void	setOwnedBy(GenericColumn ownedBy)
AbstractSequence	shallowCopy()	Copies all object properties into a new object and leaves all its children empty.

Methods inherited from class org.pgcodekeeper.core.schema.AbstractSequence

getContainingSchema, getDataType, getRelationColumns, getStatementType, setCache, setCycle, setStartWith

Methods inherited from class org.pgcodekeeper.core.schema.PgStatement

addAllDeps, addDep, addPrivilege, appendAlterComments, appendComments, appendOwnerSQL, canDrop, canDropBeforeCreate, checkComments, clearPrivileges, compareChildren, deepCopy, equals, getAuthor, getBareName, getChildren, getComment, getDbType, getDeps, getDescendants, getDropSQL, getDropSQL, getLibName, getLocation, getName, getObjectState, getObjectState, getOwner, getParent, getPrivileges, getQualifiedName, getSQL, getTwin, getTypeName, hasChildren, hashCode, isLib, isOwned, isSubElement, setAuthor, setComment, setLibName, setLocation, setOwner, setParent, toString

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.pgcodekeeper.core.schema.ISearchPath

getDatabase, getSchemaName

Methods inherited from interface org.pgcodekeeper.core.schema.IStatement

getBareName, getComment, getName, getParent, getQualifiedName

Constructor Details

PgSequence

public PgSequence(String name)

Creates a new PostgreSQL sequence with default cache value of 1.

Parameters:

name - sequence name

Method Details

getCreationSQL

public void getCreationSQL(SQLScript script)

Description copied from class: PgStatement

Generates the SQL statements needed to create this database object. This is an abstract method that must be implemented by subclasses to provide the specific CREATE SQL for each object type.

Specified by:

getCreationSQL in class PgStatement

Parameters:

script - the SQL script to append creation statements to

fillSequenceBody

public void fillSequenceBody(StringBuilder sbSQL)

Description copied from class: AbstractSequence

Fills the sequence body SQL definition.

Specified by:

fillSequenceBody in class AbstractSequence

Parameters:

sbSQL - the StringBuilder to append the sequence body to

appendAlterSQL

public ObjectState appendAlterSQL(PgStatement newCondition,
 SQLScript script)

Description copied from class: PgStatement

Fill script with object changes and return change type

Specified by:

appendAlterSQL in class PgStatement

Parameters:

newCondition - new object state

script - script to collect changes

Returns:

object change type

setMinMaxInc

public void setMinMaxInc(long inc,
 Long max,
 Long min,
 String dataType,
 long precision)

Description copied from class: AbstractSequence

Sets the minimum, maximum, and increment values for this sequence.

Specified by:

setMinMaxInc in class AbstractSequence

Parameters:

inc - the increment value

max - the maximum value

min - the minimum value

dataType - the data type of the sequence

precision - the precision for numeric types

compare

public boolean compare(PgStatement obj)

Description copied from class: PgStatement

This method does not account for nested child PgStatements. Shallow version of PgStatement.equals(Object)

Overrides:

compare in class AbstractSequence

getOwnedBy

public GenericColumn getOwnedBy()

Gets the table column that owns this sequence.

Returns:

column reference or null if not owned

setOwnedBy

public void setOwnedBy(GenericColumn ownedBy)

setDataType

public void setDataType(String dataType)

Overrides:

setDataType in class AbstractSequence

isLogged

public boolean isLogged()

Checks if this sequence is logged (written to WAL).

Returns:

true if logged, false if unlogged

setLogged

public void setLogged(boolean isLogged)

computeHash

public void computeHash(Hasher hasher)

Description copied from interface: IHashable

Computes the hash of the implementing object using the provided hasher. The implementation should call appropriate put methods on the hasher for all fields that should contribute to the hash value.

Specified by:

computeHash in interface IHashable

Overrides:

computeHash in class AbstractSequence

Parameters:

hasher - the hasher instance to use for hash computation

shallowCopy

public AbstractSequence shallowCopy()

Description copied from class: PgStatement

Copies all object properties into a new object and leaves all its children empty.

Overrides:

shallowCopy in class AbstractSequence

Returns:

shallow copy of a DB object.