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

Class PgView

java.lang.Object

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

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

org.pgcodekeeper.core.database.pg.schema.PgAbstractStatementContainer

org.pgcodekeeper.core.database.pg.schema.PgAbstractView

org.pgcodekeeper.core.database.pg.schema.PgView

All Implemented Interfaces:

IOptionContainer, IRelation, ISearchPath, ISimpleOptionContainer, IStatement, IStatementContainer, IView, IHashable

public class PgView
extends PgAbstractView

PostgreSQL view implementation. Views are virtual tables defined by queries that provide a way to present data from one or more tables in a customized format without storing the data physically.

Field Summary

Fields inherited from class org.pgcodekeeper.core.database.pg.schema.PgAbstractView

CHECK_OPTION

Constructor Summary

Constructors

Constructor	Description
PgView(String name)	Creates a new PostgreSQL view.

Method Summary

Modifier and Type	Method	Description
void	addColumnDefaultValue(String columnName, String defaultValue)	Adds/replaces column default value specification.
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	removeColumnDefaultValue(String columnName)	Removes column default value specification.

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

addColumnComment, addColumnName, addOption, appendAlterComments, appendAlterSQL, appendComments, canDropBeforeCreate, getConstraints, getCreationSQL, getOptions, getRelationColumns, setQuery

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

addChild, compareChildren, computeChildrenHash, fillChildrenList, getChild, getChildrenByType, getIndex, getIndexes, getPolicies, getPolicy, getRule, getTrigger, getTriggers, isClustered

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, appendPrivileges, canDrop, checkComments, clearPrivileges, deepCopy, equals, 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.ISimpleOptionContainer

appendOptions, compareOptions

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

addDependency, appendOwnerSQL, canDrop, 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

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

addChild, getChild, getChildrenByType

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

getStatementType

Constructor Details

PgView

public PgView(String name)

Creates a new PostgreSQL view.

Parameters:

name - view name

Method Details

addColumnDefaultValue

public void addColumnDefaultValue(String columnName,
 String defaultValue)

Adds/replaces column default value specification.

Parameters:

columnName - column name

defaultValue - default value expression

removeColumnDefaultValue

public void removeColumnDefaultValue(String columnName)

Removes column default value specification.

Parameters:

columnName - column name to remove default from

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 PgAbstractView

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 PgAbstractView