Package org.pgcodekeeper.core.schema.ms

Class MsAssembly

java.lang.Object
org.pgcodekeeper.core.schema.PgStatement
org.pgcodekeeper.core.schema.ms.MsAssembly
All Implemented Interfaces:
IHashable, IStatement
public final class MsAssembly extends PgStatement
Represents a Microsoft SQL assembly. Assemblies allow running .NET code within SQL Server.

  • Constructor Details

    • MsAssembly

      public MsAssembly(String name)

  • Method Details

    • getStatementType

      public DbObjType getStatementType()
      Description copied from interface: IStatement
      Gets the type of this database object.
      Returns:
      the database object type

    • getDatabase

      public AbstractDatabase getDatabase()
      Description copied from interface: IStatement
      Gets the database that contains this statement.
      Returns:
      the containing database

    • 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

    • getPreview

      public String getPreview(ISettings settings)
      Returns assembly definition without full binaries for preview purposes.
      Parameters:
      settings - the settings for SQL generation
      Returns:
      the preview SQL string with truncated binaries

    • 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

    • 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

    • 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

    • shallowCopy

      public MsAssembly shallowCopy()
      Description copied from class: PgStatement
      Copies all object properties into a new object and leaves all its children empty.
      Specified by:
      shallowCopy in class PgStatement
      Returns:
      shallow copy of a DB object.

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

    • setPermission

      public void setPermission(String permission)

    • addBinary

      public void addBinary(String binary)
      Adds a binary to this assembly.
      Parameters:
      binary - the binary data or file path

    • setVisible

      public void setVisible(boolean isVisible)

    • getDbType

      public DatabaseType getDbType()
      Overrides:
      getDbType in class PgStatement