Package org.pgcodekeeper.core.schema.ms

Class MsColumn

java.lang.Object
org.pgcodekeeper.core.schema.PgStatement
org.pgcodekeeper.core.schema.AbstractColumn
org.pgcodekeeper.core.schema.ms.MsColumn
All Implemented Interfaces:
IHashable, ISearchPath, IStatement
public final class MsColumn extends AbstractColumn
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

    • getFullDefinition

      public String getFullDefinition()
      Description copied from class: AbstractColumn
      Returns the complete column definition including type, constraints, and other attributes.
      Specified by:
      getFullDefinition in class AbstractColumn
      Returns:
      the full column definition as SQL string

    • 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

    • getDropSQL

      public void getDropSQL(SQLScript script, boolean optionExists)
      Description copied from class: PgStatement
      Generates DROP SQL for this statement.
      Overrides:
      getDropSQL in class PgStatement
      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 GeneratedType getGenerated()

    • setGenerated

      public void setGenerated(GeneratedType generated)

    • setHidden

      public void setHidden(boolean isHidden)

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

    • 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
      Overrides:
      computeHash in class AbstractColumn
      Parameters:
      hasher - the hasher instance to use for hash computation

    • getDbType

      public DatabaseType getDbType()
      Overrides:
      getDbType in class PgStatement