Package org.pgcodekeeper.core.schema.pg

Class PgSchema

java.lang.Object

org.pgcodekeeper.core.schema.PgStatement

org.pgcodekeeper.core.schema.AbstractSchema

org.pgcodekeeper.core.schema.pg.PgSchema

All Implemented Interfaces:

IHashable, ISchema, IStatement, IStatementContainer

public final class PgSchema
extends AbstractSchema

PostgreSQL schema implementation. Schemas are namespaces that contain database objects like tables, functions, types, and operators. Each schema can have its own set of permissions and provides object organization.

Field Summary

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

GO

Constructor Summary

Constructors

Constructor	Description
PgSchema(String name)	Creates a new PostgreSQL schema.

Method Summary

Modifier and Type	Method	Description
void	addChild(IStatement st)	Adds a child statement to this container.
void	addType(AbstractType type)	Adds a type to this schema.
ObjectState	appendAlterSQL(PgStatement newCondition, SQLScript script)	Fill script with object changes and return change type
boolean	compareChildren(PgStatement obj)	Deep part of PgStatement.equals(Object).
PgStatement	getChild(String name, DbObjType type)	Gets a child statement by name and type.
PgCollation	getCollation(String name)
void	getCreationSQL(SQLScript script)	Generates the SQL statements needed to create this database object.
PgDomain	getDomain(String name)
PgFtsConfiguration	getFtsConfiguration(String name)
PgFtsDictionary	getFtsDictionary(String name)
PgFtsParser	getFtsParser(String name)
PgFtsTemplate	getFtsTemplate(String name)
PgOperator	getOperator(String signature)	Gets an operator by its signature.
Collection<IOperator>	getOperators()	Gets all operators in this schema.
PgStatistics	getStatistics(String name)

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

addFunction, addSequence, addTable, addView, compare, computeHash, getConstraintByName, getDatabase, getFunction, getFunctions, getIndexByName, getRelation, getRelations, getSequence, getSequences, getStatementContainer, getStatementContainers, getStatementType, getTable, getTables, getType, getView, getViews, shallowCopy

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

addAllDeps, addDep, addPrivilege, appendAlterComments, appendComments, appendOwnerSQL, canDrop, canDropBeforeCreate, checkComments, clearPrivileges, 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.IStatement

getBareName, getComment, getName, getParent, getQualifiedName

Constructor Details

PgSchema

public PgSchema(String name)

Creates a new PostgreSQL schema.

Parameters:

name - schema 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

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

getDomain

public PgDomain getDomain(String name)

getCollation

public PgCollation getCollation(String name)

getFtsParser

public PgFtsParser getFtsParser(String name)

getFtsTemplate

public PgFtsTemplate getFtsTemplate(String name)

getFtsDictionary

public PgFtsDictionary getFtsDictionary(String name)

getFtsConfiguration

public PgFtsConfiguration getFtsConfiguration(String name)

getOperator

public PgOperator getOperator(String signature)

Gets an operator by its signature.

Parameters:

signature - operator signature including arguments

Returns:

operator or null if not found

getStatistics

public PgStatistics getStatistics(String name)

getOperators

public Collection<IOperator> getOperators()

Gets all operators in this schema.

Returns:

unmodifiable collection of operators

addType

public void addType(AbstractType type)

Description copied from class: AbstractSchema

Adds a type to this schema.

Overrides:

addType in class AbstractSchema

Parameters:

type - the table to add

getChild

public PgStatement getChild(String name,
 DbObjType type)

Description copied from interface: IStatementContainer

Gets a child statement by name and type.

Specified by:

getChild in interface IStatementContainer

Overrides:

getChild in class AbstractSchema

Parameters:

name - the name of the child to find

type - the type of the child to find

Returns:

the child statement, or null if not found

addChild

public void addChild(IStatement st)

Description copied from interface: IStatementContainer

Adds a child statement to this container.

Specified by:

addChild in interface IStatementContainer

Overrides:

addChild in class AbstractSchema

Parameters:

st - the child statement to add

compareChildren

public boolean compareChildren(PgStatement obj)

Description copied from class: PgStatement

Deep part of PgStatement.equals(Object). Compares all object's child PgStatements for equality.

Overrides:

compareChildren in class AbstractSchema