Package org.pgcodekeeper.core.database.ms.schema

Class MsView

java.lang.Object
org.pgcodekeeper.core.database.base.schema.AbstractStatement
org.pgcodekeeper.core.database.ms.schema.MsAbstractStatement
org.pgcodekeeper.core.database.ms.schema.MsAbstractStatementContainer
org.pgcodekeeper.core.database.ms.schema.MsView
All Implemented Interfaces:
IRelation, ISearchPath, IStatement, IStatementContainer, IView, MsSourceStatement, IHashable
public class MsView extends MsAbstractStatementContainer implements MsSourceStatement, IView
Represents a Microsoft SQL view with support for schema binding, ANSI_NULLS and QUOTED_IDENTIFIER settings, and statistics.

  • Constructor Details

    • MsView

      public MsView(String name)
      Creates a new Microsoft SQL view.
      Parameters:
      name - the view 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

    • 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

    • setAnsiNulls

      public void setAnsiNulls(boolean ansiNulls)

    • setQuotedIdentified

      public void setQuotedIdentified(boolean quotedIdentified)

    • getFirstPart

      public String getFirstPart()
      Description copied from interface: MsSourceStatement
      Gets the first part of the source statement (before CREATE/ALTER).
      Specified by:
      getFirstPart in interface MsSourceStatement
      Returns:
      the first part of the source

    • setFirstPart

      public void setFirstPart(String firstPart)
      Description copied from interface: MsSourceStatement
      Sets the first part of the source statement.
      Specified by:
      setFirstPart in interface MsSourceStatement
      Parameters:
      firstPart - the first part to set

    • getSecondPart

      public String getSecondPart()
      Description copied from interface: MsSourceStatement
      Gets the second part of the source statement (after the object name).
      Specified by:
      getSecondPart in interface MsSourceStatement
      Returns:
      the second part of the source

    • setSecondPart

      public void setSecondPart(String secondPart)
      Description copied from interface: MsSourceStatement
      Sets the second part of the source statement.
      Specified by:
      setSecondPart in interface MsSourceStatement
      Parameters:
      secondPart - the second part to set

    • setSchemaBinding

      public void setSchemaBinding(boolean schemaBinding)

    • isSchemaBinding

      public boolean isSchemaBinding()

    • 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

    • 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