Package org.pgcodekeeper.core.schema.ch

Class ChView

java.lang.Object

org.pgcodekeeper.core.schema.PgStatement

org.pgcodekeeper.core.schema.PgStatementContainer

org.pgcodekeeper.core.schema.AbstractView

org.pgcodekeeper.core.schema.ch.ChView

All Implemented Interfaces:

IHashable, IRelation, ISearchPath, IStatement, IStatementContainer

public final class ChView
extends AbstractView

Represents a ClickHouse view (VIEW, MATERIALIZED VIEW, or LIVE VIEW). Supports various ClickHouse-specific view features like refresh periods, engines, and security settings.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	ChView.ChViewType	Enumeration of ClickHouse view types.

Field Summary

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

GO

Constructor Summary

Constructors

Constructor	Description
ChView(String name)	Creates a new ClickHouse view with the specified name.

Method Summary

Modifier and Type	Method	Description
void	addColumn(ChColumn column)	Adds a column definition to this view.
ObjectState	appendAlterSQL(PgStatement newCondition, SQLScript script)	Fill script with object changes and return change type
void	appendComments(SQLScript script)	Appends comment SQL to the script if this statement has comments.
boolean	compare(PgStatement 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.
DatabaseType	getDbType()
void	setDefiner(String definer)
void	setDestination(String destination)
void	setEngine(ChEngine engine)
void	setQuery(String query, String normalizedQuery)	Sets the query and normalized query for this view.
void	setRefreshPeriod(int refreshPeriod)
void	setSqlSecurity(String sqlSecurity)
void	setType(ChView.ChViewType type)
void	setWithRefresh(boolean isWithRefresh)

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

addConstraint, getConstraint, getConstraints, getRelationColumns, getStatementType

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

addChild, addIndex, addPolicy, addRule, addTrigger, compareChildren, computeChildrenHash, getChild, getContainingSchema, getIndex, getIndexes, getPolicies, getPolicy, getRule, getRules, getTrigger, getTriggers, isClustered, shallowCopy

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

addAllDeps, addDep, addPrivilege, appendAlterComments, appendOwnerSQL, canDrop, canDropBeforeCreate, checkComments, clearPrivileges, deepCopy, equals, getAuthor, getBareName, getChildren, getComment, 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.ISearchPath

getDatabase, getSchemaName

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

getBareName, getComment, getName, getParent, getQualifiedName

Constructor Details

ChView

public ChView(String name)

Creates a new ClickHouse view with the specified name.

Parameters:

name - the name of the view

Method Details

setType

public void setType(ChView.ChViewType type)

setQuery

public void setQuery(String query,
 String normalizedQuery)

Sets the query and normalized query for this view.

Parameters:

query - the original query text

normalizedQuery - the normalized query text for comparison

setRefreshPeriod

public void setRefreshPeriod(int refreshPeriod)

setWithRefresh

public void setWithRefresh(boolean isWithRefresh)

addColumn

public void addColumn(ChColumn column)

Adds a column definition to this view.

Parameters:

column - the column to add

setEngine

public void setEngine(ChEngine engine)

setDefiner

public void setDefiner(String definer)

setSqlSecurity

public void setSqlSecurity(String sqlSecurity)

setDestination

public void setDestination(String destination)

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

getDbType

public DatabaseType getDbType()

Overrides:

getDbType in class PgStatement

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.

Parameters:

hasher - the hasher instance to use for hash computation

compare

public boolean compare(PgStatement obj)

Description copied from class: PgStatement

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

Overrides:

compare in class AbstractView

appendComments

public void appendComments(SQLScript script)

Description copied from class: PgStatement

Appends comment SQL to the script if this statement has comments.

Overrides:

appendComments in class PgStatement

Parameters:

script - the SQL script to append comments to