com.atlassian.confluence.security.denormalisedpermissions.impl.setup.sqlserver

Class BaseSqlServerDdlHelper

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 Summary

Constructors

Constructor and Description
BaseSqlServerDdlHelper(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate)

Method Summary

Modifier and Type	Method and Description
void	createTriggersAndFunctions()
void	disableService()
void	dropIndex(String indexName, String tableName)
void	dropTriggersAndFunctions()
void	enableService()
protected String	getCreateFunction(boolean isServiceEnabled)
protected abstract String	getCreateTriggerDdl()
protected String	getDropFunctionName()
protected String	getDropTriggerDdl()
protected String	getFullFunctionName()
protected String	getFullTableName()
protected String	getFullTriggerName()
protected abstract String	getFunctionName()
protected abstract String	getTableName()
protected abstract String	getTriggerName()
boolean	indexExist(String indexName, String tableName)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

BaseSqlServerDdlHelper

public BaseSqlServerDdlHelper(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate)

Method Detail

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)