com.atlassian.jira.upgrade

Class DropIndexHelper

java.lang.Object

com.atlassian.jira.upgrade.DropIndexHelper

public class DropIndexHelper
extends Object

Used to drop old indexes as ofBiz don't drop it automatically.

pre-8.0 was called 'DropIndexTask'. The new implementation looses DropIndexTask from extending DelayedUpgradeTask.

Since:

8.0

Constructor Summary

Constructors

Constructor and Description
DropIndexHelper(AbstractUpgradeTask abstractUpgradeTask)

Method Summary

Modifier and Type	Method and Description
protected String	buildDropIndexSql(String tableName, String index)
boolean	checkIndexExists(String tableName, String indexName) Used to identify if index does indeed exist.
void	dropIndex(String tableName, String indexName) Drops the index IF it exists.

Methods inherited from class java.lang.Object

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

Constructor Detail

DropIndexHelper

public DropIndexHelper(AbstractUpgradeTask abstractUpgradeTask)

Method Detail

buildDropIndexSql

protected String buildDropIndexSql(String tableName,
                                   String index)

dropIndex

public void dropIndex(String tableName,
                      String indexName)
               throws SQLException

Drops the index IF it exists.

HINT: Remember to remove index declaration from entitymodel.xml so it won't get recreated later. CAUTION: Indexes are created before upgrade tasks are run - do not use same index name with modified structure.

Parameters:

tableName - of index to drop.

indexName - of index to drop.

Throws:

SQLException - if drop index sql doesn't fit database anymore.

IllegalArgumentException - if table doesn't exist

DataAccessException - is internal ofBiz problem

RuntimeException - wrapping GenericEntityException if entity name doesn't exist anymore

checkIndexExists

public boolean checkIndexExists(String tableName,
                                String indexName)

Used to identify if index does indeed exist.

Parameters:

tableName - is table name NOT entityName.

indexName - to check existence.

Returns:

True if index exists

Throws:

IllegalArgumentException - if table doesn't exist

DataAccessException - is internal ofBiz problem

RuntimeException - wrapping GenericEntityException if entity name doesn't exist anymore