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

Class PgRule

java.lang.Object

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

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

org.pgcodekeeper.core.database.pg.schema.PgRule

All Implemented Interfaces:

IRule, ISearchPath, IStatement, ISubElement, IHashable

public class PgRule
extends PgAbstractStatement
implements IRule

PostgreSQL table rule implementation. Rules define actions to be performed when certain operations (INSERT, UPDATE, DELETE) are executed on a table, effectively implementing view-like behavior and query rewriting.

Constructor Summary

Constructors

Constructor	Description
PgRule(String name)	Creates a new PostgreSQL rule.

Method Summary

Modifier and Type	Method	Description
void	addCommand(String command)	Adds an action command to be executed when this rule fires.
ObjectState	appendAlterSQL(IStatement newCondition, SQLScript script)	Fill script with object changes and return change type
void	appendFullName(StringBuilder sb)
boolean	canDropBeforeCreate()	Checks if this statement can be dropped before being recreated.
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	getCreationSQL(SQLScript script)	Generates the SQL statements needed to create this database object.
void	setCondition(String condition)
void	setEnabledState(String enabledState)
void	setEvent(EventType event)
void	setInstead(boolean instead)

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, 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.IRule

getStatementType

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, 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.ISubElement

getContainingSchema, toObjectReference

Constructor Details

PgRule

public PgRule(String name)

Creates a new PostgreSQL rule.

Parameters:

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

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

appendFullName

public void appendFullName(StringBuilder sb)

canDropBeforeCreate

public boolean canDropBeforeCreate()

Description copied from interface: IStatement

Checks if this statement can be dropped before being recreated. Override in subclasses that support drop-before-create behavior.

Specified by:

canDropBeforeCreate in interface IStatement

Overrides:

canDropBeforeCreate in class AbstractStatement

Returns:

true if the statement can be dropped before recreation

setEvent

public void setEvent(EventType event)

setCondition

public void setCondition(String condition)

setInstead

public void setInstead(boolean instead)

addCommand

public void addCommand(String command)

Adds an action command to be executed when this rule fires.

Parameters:

command - SQL command to execute

setEnabledState

public void setEnabledState(String enabledState)

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