java.lang.Object
com.atlassian.confluence.security.denormalisedpermissions.impl.setup.sqlserver.BaseSqlServerDdlHelper
Direct Known Subclasses:
SqlServerContentDdlHelper, SqlServerContentPermissionDdlHelper, SqlServerContentPermissionSetDdlHelper, SqlServerSpaceDdlHelper, SqlServerSpacePermissionDdlHelper

public abstract class BaseSqlServerDdlHelper extends Object
Abstract class for MSSQL operations
Since:
7.11.0
  • Constructor Details

    • BaseSqlServerDdlHelper

      public BaseSqlServerDdlHelper(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate)
  • Method Details

    • createTriggersAndFunctions

      public void createTriggersAndFunctions()
    • enableService

      public void enableService()
    • disableService

      public void disableService()
    • dropTriggersAndFunctions

      public void dropTriggersAndFunctions()
    • getFullTriggerName

      protected String getFullTriggerName()
    • getFullFunctionName

      protected String getFullFunctionName()
    • getFullTableName

      protected String getFullTableName()
    • getDropTriggerDdl

      protected String getDropTriggerDdl()
    • getTriggerName

      protected abstract String getTriggerName()
    • getFunctionName

      protected abstract String getFunctionName()
    • getTableName

      protected abstract String getTableName()
    • getCreateTriggerDdl

      protected abstract String getCreateTriggerDdl()
    • getDropFunctionName

      protected String getDropFunctionName()
    • getCreateFunction

      protected String getCreateFunction(boolean isServiceEnabled)
    • dropIndex

      public void dropIndex(String indexName, String tableName)
    • indexExist

      public boolean indexExist(String indexName, String tableName)