com.atlassian.confluence.upgrade.upgradetask

Class RelationConstraintsPostSchemaUpgradeTask

java.lang.Object

com.atlassian.confluence.upgrade.AbstractUpgradeTask

com.atlassian.confluence.upgrade.upgradetask.RelationConstraintsPostSchemaUpgradeTask

All Implemented Interfaces:

BackupSupport, DatabaseUpgradeTask, UpgradeTask, UpgradeTaskInfo, org.springframework.beans.factory.Aware, org.springframework.beans.factory.BeanNameAware

public class RelationConstraintsPostSchemaUpgradeTask
extends AbstractUpgradeTask
implements DatabaseUpgradeTask

This is upgrade task to fix issue with multi-column unique constraints, caused by https://hibernate.atlassian.net/browse/HB-1245. The main idea behind this fix is to create multi-column constraints programmatically (not declaratively via xml), which allows to generate correct name for multi-column constraint. More details at https://jira.atlassian.com/browse/CONF-40174

Since:

5.9.3

Constructor Summary

Constructors

Constructor and Description
RelationConstraintsPostSchemaUpgradeTask(AlterTableExecutor alterTableExecutor, org.hibernate.SessionFactory sessionFactory, com.atlassian.config.db.HibernateConfig hibernateConfig, DdlExecutor ddlExecutor, org.springframework.transaction.PlatformTransactionManager transactionManager)

Method Summary

Modifier and Type	Method and Description
boolean	breaksBackwardCompatibility() Returns true if a new export can't be imported in an older instance.
void	doUpgrade() Perform the upgrade.
String	getBuildNumber()
static List<String>	getUniqueConstraintSqlStatements() As upgrade tasks don't run on Confluence set-up, this method allows to generate appropriate DDL statements to create correct multi-column constrains on RelationEntity tables.
boolean	runOnSpaceImport() Returns true if an older Space can't be imported in a new instance without running this task.

Methods inherited from class com.atlassian.confluence.upgrade.AbstractUpgradeTask

addAllErrors, addError, addError, getConstraint, getErrors, getName, getShortDescription, isDatabaseUpgrade, setBeanName, setBuildNumber, validate

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.atlassian.confluence.upgrade.UpgradeTask

getConstraint, getErrors, validate

Methods inherited from interface com.atlassian.confluence.upgrade.UpgradeTaskInfo

getName, getShortDescription, isDatabaseUpgrade

Constructor Detail

RelationConstraintsPostSchemaUpgradeTask

public RelationConstraintsPostSchemaUpgradeTask(AlterTableExecutor alterTableExecutor,
                                                org.hibernate.SessionFactory sessionFactory,
                                                com.atlassian.config.db.HibernateConfig hibernateConfig,
                                                DdlExecutor ddlExecutor,
                                                org.springframework.transaction.PlatformTransactionManager transactionManager)

Method Detail

getBuildNumber

public String getBuildNumber()

Specified by:

getBuildNumber in interface UpgradeTaskInfo

Overrides:

getBuildNumber in class AbstractUpgradeTask

Returns:

The build number that this upgrade is applicable to

runOnSpaceImport

public boolean runOnSpaceImport()

Description copied from interface: BackupSupport

Returns true if an older Space can't be imported in a new instance without running this task. For example:

• A task updating macro names in the BodyContent table would be blocking.
• Tasks which updates data related to the space would be blocking.
• A task upgrading the user table wouldn't be blocking.
• Adding a mandatory column on space-related content breaks space import

Note that tasks don't run on space import yet, so we just reject the import in this case.

Specified by:

runOnSpaceImport in interface BackupSupport

breaksBackwardCompatibility

public boolean breaksBackwardCompatibility()

Description copied from interface: BackupSupport

Returns true if a new export can't be imported in an older instance.

Breaking compatibility means a snapshot of the new version will not work at all with the previous version. For example:

• A destructive operation (Some data is replaced by another) breaks backwards compatibility
• Adding a optional column does NOT break backwards compatibility
• Data is copied to another column doesn't breaks backwards compatibility
• A build number incrementation doesn't breaks backwards compatibility

The best way to test is whether a newer export can be imported (with fully working features) in an older instance.

Specified by:

breaksBackwardCompatibility in interface BackupSupport

doUpgrade

public void doUpgrade()
               throws Exception

Description copied from interface: UpgradeTask

Perform the upgrade.

Specified by:

doUpgrade in interface UpgradeTask

Throws:

Exception

getUniqueConstraintSqlStatements

public static List<String> getUniqueConstraintSqlStatements()

As upgrade tasks don't run on Confluence set-up, this method allows to generate appropriate DDL statements to create correct multi-column constrains on RelationEntity tables.

Returns:

list of ddl statements to be executed in ConfluenceSchemaCreator.createAdditionalDatabaseConstraints()