Package org.pgcodekeeper.core.database.pg.schema

Class PgSequence

java.lang.Object

org.pgcodekeeper.core.database.base.schema.AbstractStatement

org.pgcodekeeper.core.database.pg.schema.PgAbstractStatement

org.pgcodekeeper.core.database.pg.schema.PgSequence

All Implemented Interfaces:

IRelation, ISearchPath, ISequence, IStatement, IHashable

public class PgSequence
extends PgAbstractStatement
implements ISequence

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.

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(IStatement newCondition, SQLScript script)	Fill script with object changes and return change type
boolean	compare(IStatement 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)
void	getCreationSQL(SQLScript script)	Generates the SQL statements needed to create this database object.
String	getDataType()
ObjectReference	getOwnedBy()	Gets the table column that owns this sequence.
void	getOwnedBySQL(SQLScript script)	Creates SQL statement for modification "OWNED BY" parameter.
void	getOwnedBySQL(SQLScript script, SQLActionType type)
Stream<Pair<String,String>>	getRelationColumns()	Gets the columns of this relation as name-type pairs.
boolean	isLogged()	Checks if this sequence is logged (written to WAL).
void	setCache(String cache)
void	setCycle(boolean cycle)
void	setDataType(String dataType)
void	setLogged(boolean isLogged)
void	setMinMaxInc(long inc, Long max, Long min, String dataType, long precision)
void	setOwnedBy(ObjectReference ownedBy)
void	setStartWith(String startWith)

Methods inherited from class org.pgcodekeeper.core.database.pg.schema.PgAbstractStatement

addPrivilege, appendDefaultPrivileges, appendOwnerSQL, formatSql, getQuoter, getRenameCommand, isOwned

Methods inherited from class org.pgcodekeeper.core.database.base.schema.AbstractStatement

addDependency, appendAlterComments, appendComments, appendPrivileges, canDrop, canDropBeforeCreate, checkComments, clearPrivileges, compareChildren, deepCopy, equals, fillChildrenList, fillDescendantsList, getAuthor, getBareName, getChildren, getComment, getDependencies, getDescendants, getDropSQL, getDropSQL, getLibName, getLocation, getName, getObjectState, getObjectState, getOwner, getParent, getPrivileges, getQualifiedName, getSeparator, getSQL, getTwin, hasChildren, hashCode, isLib, setAuthor, setComment, setLibName, setLocation, setOwner, setParent, shallowCopy, toString

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

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

getContainingSchema, getDatabase, getSchemaName, toObjectReference

Methods inherited from interface org.pgcodekeeper.core.database.api.schema.ISequence

getStatementType

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

addDependency, appendOwnerSQL, canDrop, canDropBeforeCreate, clearPrivileges, deepCopy, formatSql, getAuthor, getBareName, getChildren, getComment, getDependencies, getDescendants, getDropSQL, getLibName, getLocation, getName, getOwner, getParent, getPrivileges, getQualifiedName, getQuotedName, getQuoter, getRenameCommand, getSeparator, getSQL, getTwin, getTypeName, hasChildren, isLib, isOwned, quote, setComment, setLibName, setLocation, setOwner, shallowCopy

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 interface: IStatement

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 interface IStatement

Parameters:

script - the SQL script to append creation statements to

fillSequenceBody

public void fillSequenceBody(StringBuilder sbSQL)

getOwnedBySQL

public void getOwnedBySQL(SQLScript script)

Creates SQL statement for modification "OWNED BY" parameter.

getOwnedBySQL

public void getOwnedBySQL(SQLScript script,
 SQLActionType type)

appendAlterSQL

public ObjectState appendAlterSQL(IStatement newCondition,
 SQLScript script)

Description copied from interface: IStatement

Fill script with object changes and return change type

Specified by:

appendAlterSQL in interface IStatement

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)

setStartWith

public void setStartWith(String startWith)

getOwnedBy

public ObjectReference getOwnedBy()

Gets the table column that owns this sequence.

Returns:

column reference or null if not owned

setOwnedBy

public void setOwnedBy(ObjectReference ownedBy)

setDataType

public void setDataType(String dataType)

getDataType

public String getDataType()

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)

setCycle

public void setCycle(boolean cycle)

setCache

public void setCache(String cache)

getRelationColumns

public Stream<Pair<String,String>> getRelationColumns()

Description copied from interface: IRelation

Gets the columns of this relation as name-type pairs.

Specified by:

getRelationColumns in interface IRelation

Returns:

a stream of column name and type pairs

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

Parameters:

hasher - the hasher instance to use for hash computation

compare

public boolean compare(IStatement obj)

Description copied from class: AbstractStatement

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

Specified by:

compare in interface IStatement

Overrides:

compare in class AbstractStatement