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

Class MsColumn

java.lang.Object
org.pgcodekeeper.core.database.base.schema.AbstractStatement
org.pgcodekeeper.core.database.ms.schema.MsAbstractStatement
org.pgcodekeeper.core.database.ms.schema.MsColumn
All Implemented Interfaces:
IColumn, ISearchPath, IStatement, ISubElement, IHashable
public class MsColumn extends MsAbstractStatement implements IColumn
Represents a Microsoft SQL table column with its properties and constraints. Handles column-specific features like SPARSE, ROWGUIDCOL, PERSISTED, identity columns, generated columns, and data masking functions.

  • Constructor Details

    • MsColumn

      public MsColumn(String name)
      Creates a new Microsoft SQL column with the specified name.
      Parameters:
      name - the column 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

    • getFullDefinition

      public String getFullDefinition()

    • 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

    • getDropSQL

      public void getDropSQL(SQLScript script, boolean optionExists)
      Description copied from interface: IStatement
      Generates DROP SQL for this statement.
      Specified by:
      getDropSQL in interface IStatement
      Overrides:
      getDropSQL in class AbstractStatement
      Parameters:
      script - the SQL script to append the DROP statement to
      optionExists - whether to include "IF EXISTS" in the DROP statement

    • setSparse

      public void setSparse(boolean isSparse)

    • setRowGuidCol

      public void setRowGuidCol(boolean isRowGuidCol)

    • setPersisted

      public void setPersisted(boolean isPersisted)

    • setNotForRep

      public void setNotForRep(boolean isNotForRep)

    • getDefaultName

      public String getDefaultName()

    • setDefaultName

      public void setDefaultName(String defaultName)

    • getExpression

      public String getExpression()

    • setExpression

      public void setExpression(String expression)

    • setMaskingFunction

      public void setMaskingFunction(String maskingFunction)

    • isIdentity

      public boolean isIdentity()

    • setIdentity

      public void setIdentity(String seed, String increment)
      Configures this column as an identity column with the specified seed and increment values.
      Parameters:
      seed - the starting value for the identity
      increment - the increment value for each new identity value

    • getGenerated

      public MsGeneratedType getGenerated()

    • setGenerated

      public void setGenerated(MsGeneratedType generated)

    • setHidden

      public void setHidden(boolean isHidden)

    • setDefaultValue

      public void setDefaultValue(String defaultValue)

    • setNotNull

      public void setNotNull(boolean notNull)

    • setCollation

      public void setCollation(String collation)

    • setType

      public void setType(String type)

    • getType

      public String getType()
      Specified by:
      getType in interface IColumn

    • isNotNull

      public boolean isNotNull()
      Specified by:
      isNotNull in interface IColumn

    • 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