Package org.pgcodekeeper.core.database.ch.schema

Class ChView

java.lang.Object
org.pgcodekeeper.core.database.base.schema.AbstractStatement
org.pgcodekeeper.core.database.ch.schema.ChAbstractStatement
org.pgcodekeeper.core.database.ch.schema.ChView
All Implemented Interfaces:
IRelation, ISearchPath, IStatement, IStatementContainer, IView, IHashable
public class ChView extends ChAbstractStatement implements IView
Represents a ClickHouse view (VIEW, MATERIALIZED VIEW, or LIVE VIEW). Supports various ClickHouse-specific view features like refresh periods, engines, and security settings.

  • 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

    • 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

    • 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)

    • getRelationColumns

      public Stream<Pair<String,String>> getRelationColumns()
      Description copied from interface: IRelation
      Gets the columns of this relation as name-type pairs.
      Specified by:
      getRelationColumns in interface IRelation
      Returns:
      a stream of column name and type pairs

    • addChild

      public void addChild(IStatement stmt)
      Description copied from interface: IStatementContainer
      Adds a child statement to this container.
      Specified by:
      addChild in interface IStatementContainer
      Parameters:
      stmt - the child statement to add

    • getChild

      public IStatement getChild(String name, DbObjType type)
      Description copied from interface: IStatementContainer
      Gets a child statement by name and type.
      Specified by:
      getChild in interface IStatementContainer
      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

    • getChildrenByType

      public Collection<IStatement> getChildrenByType(DbObjType type)
      Description copied from interface: IStatementContainer
      get all children by type
      Specified by:
      getChildrenByType in interface IStatementContainer
      Parameters:
      type - the type of the children
      Returns:
      unmodifiable collection of child statement, or empty list

    • 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)

    • 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