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

Class PgConstraintNotNull

java.lang.Object

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

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

org.pgcodekeeper.core.database.pg.schema.PgConstraint

org.pgcodekeeper.core.database.pg.schema.PgConstraintNotNull

All Implemented Interfaces:

IConstraint, ISearchPath, IStatement, ISubElement, IHashable

public class PgConstraintNotNull
extends PgConstraint

PostgreSQL NOT NULL constraint implementation. NOT NULL constraints ensure that a column cannot contain NULL values. Since PostgreSQL 18, NOT NULL constraints can be named and support NO INHERIT option.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	NO_INHERIT

Constructor Summary

Constructors

Constructor	Description
PgConstraintNotNull(String name)
PgConstraintNotNull(String tableName, String columnName)

Method Summary

Modifier and Type	Method	Description
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.
String	getDefinition()	Gets the SQL definition of this constraint.
void	getDefinitionForColumn(StringBuilder sb)
String	getErrorCode()
String	getRenameCommand(String newName)	Returns sql command to rename the given object.
String	getTableName()	Gets the name of the table this constraint belongs to.
boolean	isComplexNotNull()
void	setNoInherit(boolean noInherit)

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

appendAlterSQL, appendOptions, containsColumn, getColumns, getCreationSQL, getDropSQL, isNotValid, setDeferrable, setInitially, setNotEnforced, setNotValid

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

addPrivilege, appendDefaultPrivileges, appendOwnerSQL, formatSql, getQuoter, 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, 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.IConstraint

getStatementType, isPrimaryKey

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

getDatabase, getSchemaName

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

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

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

getContainingSchema, toObjectReference

Field Details

NO_INHERIT

public static final String NO_INHERIT

See Also:

• Constant Field Values

Constructor Details

PgConstraintNotNull

public PgConstraintNotNull(String name)

PgConstraintNotNull

public PgConstraintNotNull(String tableName,
 String columnName)

Method Details

getDefinition

public String getDefinition()

Description copied from interface: IConstraint

Gets the SQL definition of this constraint.

Returns:

the constraint definition

getDefinitionForColumn

public void getDefinitionForColumn(StringBuilder sb)

getRenameCommand

public String getRenameCommand(String newName)

Description copied from interface: IStatement

Returns sql command to rename the given object.

Specified by:

getRenameCommand in interface IStatement

Overrides:

getRenameCommand in class PgAbstractStatement

Parameters:

newName - the new name for given object

Returns:

sql command to rename the given object

getErrorCode

public String getErrorCode()

setNoInherit

public void setNoInherit(boolean noInherit)

getTableName

public String getTableName()

Description copied from interface: IConstraint

Gets the name of the table this constraint belongs to.

Specified by:

getTableName in interface IConstraint

Overrides:

getTableName in class PgConstraint

Returns:

the table name

isComplexNotNull

public boolean isComplexNotNull()

Returns:

true if the constraint can only be written via ALTER TABLE

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 PgConstraint

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 PgConstraint