Package org.opencms.setup.db.update6to7

Class CmsUpdateDBAlterTables

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBAlterTables

All Implemented Interfaces:

I_CmsUpdateDBPart

Direct Known Subclasses:

CmsUpdateDBAlterTables, CmsUpdateDBAlterTables, CmsUpdateDBAlterTables

public class CmsUpdateDBAlterTables
extends A_CmsUpdateDBPart

This class makes the remaining changes to some tables in order to update them.

The following tables will be altered CMS_ONLINE/OFFLINE_PROPERTYDEF Add the TYPE column CMS_ONLINE/OFFLINE_RESOURCES Add the columns DATE_CONTENT and RESOURCE_VERSION CMS_ONLINE/OFFLINE_STRUCTURE Add the column STRUCTURE_VERSION CMS_PROJECTS Drop the column TASK_ID and change the size for the project name

Since:

7.0.0

Field Summary

Fields

Modifier and Type	Field	Description
protected static final String[]	CMS_OFFLINE_CONTENTS_QUERIES	Constant array with the queries for the CMS_ONLINE_CONTENTS table.
protected static final List<String>	CMS_OFFLINE_CONTENTS_QUERIES_LIST	Constant ArrayList of the queries of the CMS_OFFLINE table.
protected static final String[]	CMS_PROPERTYDEF	Constant array with the ONLINE and OFFLINE PROPERTYDEF tables.
protected static final List<String>	CMS_PROPERTYDEF_LIST	Constant ArrayList of the two PROPERTYDEF tables.
protected static final String[]	CMS_RESOURCES	Constant array with the ONLINE and OFFLINE RESOURCES tables.
protected static final List<String>	CMS_RESOURCES_LIST	Constant ArrayList of the two RESOURCES tables.
protected static final String[]	CMS_STRUCTURE	Constant array with the ONLINE and OFFLINE STRUCTURE tables.
protected static final List<String>	CMS_STRUCTURE_LIST	Constant ArrayList of the two PROPERTYDEF tables.
protected static final String	COLUMN_CMS_OFFLINE_CONTENTS_CONTENT_ID	Constant for the column CONTENT_ID of the table CMS_OFFLINE_CONTENTS.
protected static final String	COLUMN_CMS_PROPERTYDEF_TYPE	Constant for the column PROPERTYDEF_TYPE of the PROPERTYDEF tables.
protected static final String	COLUMN_CMS_STRUCTURE_STRUCTURE_VERSION	Constant for the column STRUCTURE_VERSION in the STRUCTURE tables.
protected static final String	COLUMN_PROJECTS_PROJECT_NAME	Constant for the column PROJECT_NAME of the CMS_PROJECTS table.
protected static final String	COLUMN_PROJECTS_TASK_ID	Constant for the column TASK_ID of the CMS_PROJECTS table.
protected static final String	COLUMN_RESOURCES_DATE_CONTENT	Constant for the new column DATE_CONTENT of the CMS_RESOURCES tables.
protected static final String	COLUMN_RESOURCES_RESOURCE_VERSION	Constant for the new column RESOURCE_VERSION of the CMS_RESOURCES tables.
protected static final String	REPLACEMENT_TABLENAME	Constant for the sql replacement of the tablename.
protected static final String	TABLE_CMS_OFFLINE_CONTENTS	Constant for the table name CMS_OFFLINE_CONTENTS.
protected static final String	TABLE_CMS_PROJECTS	Constant for the table name CMS_PROJECTS.

Fields inherited from class org.opencms.setup.db.A_CmsUpdateDBPart

m_poolData, m_queries

Constructor Summary

Constructors

Constructor	Description
CmsUpdateDBAlterTables()	Default constructor.

Method Summary

Modifier and Type	Method	Description
protected void	internalExecute(CmsSetupDb dbCon)	Does the hard work.

Methods inherited from class org.opencms.setup.db.A_CmsUpdateDBPart

execute, getPoolData, getPropertyFileLocation, isKeepHistory, loadQueryProperties, readQuery

Methods inherited from class java.lang.Object

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

Field Details

CMS_OFFLINE_CONTENTS_QUERIES

protected static final String[] CMS_OFFLINE_CONTENTS_QUERIES

Constant array with the queries for the CMS_ONLINE_CONTENTS table.

CMS_OFFLINE_CONTENTS_QUERIES_LIST

protected static final List<String> CMS_OFFLINE_CONTENTS_QUERIES_LIST

Constant ArrayList of the queries of the CMS_OFFLINE table.

CMS_PROPERTYDEF

protected static final String[] CMS_PROPERTYDEF

Constant array with the ONLINE and OFFLINE PROPERTYDEF tables.

CMS_PROPERTYDEF_LIST

protected static final List<String> CMS_PROPERTYDEF_LIST

Constant ArrayList of the two PROPERTYDEF tables.

CMS_RESOURCES

protected static final String[] CMS_RESOURCES

Constant array with the ONLINE and OFFLINE RESOURCES tables.

CMS_RESOURCES_LIST

protected static final List<String> CMS_RESOURCES_LIST

Constant ArrayList of the two RESOURCES tables.

CMS_STRUCTURE

protected static final String[] CMS_STRUCTURE

Constant array with the ONLINE and OFFLINE STRUCTURE tables.

CMS_STRUCTURE_LIST

protected static final List<String> CMS_STRUCTURE_LIST

Constant ArrayList of the two PROPERTYDEF tables.

COLUMN_CMS_OFFLINE_CONTENTS_CONTENT_ID

protected static final String COLUMN_CMS_OFFLINE_CONTENTS_CONTENT_ID

Constant for the column CONTENT_ID of the table CMS_OFFLINE_CONTENTS.

See Also:

• Constant Field Values

COLUMN_CMS_PROPERTYDEF_TYPE

protected static final String COLUMN_CMS_PROPERTYDEF_TYPE

Constant for the column PROPERTYDEF_TYPE of the PROPERTYDEF tables.

See Also:

• Constant Field Values

COLUMN_CMS_STRUCTURE_STRUCTURE_VERSION

protected static final String COLUMN_CMS_STRUCTURE_STRUCTURE_VERSION

Constant for the column STRUCTURE_VERSION in the STRUCTURE tables.

See Also:

• Constant Field Values

COLUMN_PROJECTS_PROJECT_NAME

protected static final String COLUMN_PROJECTS_PROJECT_NAME

Constant for the column PROJECT_NAME of the CMS_PROJECTS table.

See Also:

• Constant Field Values

COLUMN_PROJECTS_TASK_ID

protected static final String COLUMN_PROJECTS_TASK_ID

Constant for the column TASK_ID of the CMS_PROJECTS table.

See Also:

• Constant Field Values

COLUMN_RESOURCES_DATE_CONTENT

protected static final String COLUMN_RESOURCES_DATE_CONTENT

Constant for the new column DATE_CONTENT of the CMS_RESOURCES tables.

See Also:

• Constant Field Values

COLUMN_RESOURCES_RESOURCE_VERSION

protected static final String COLUMN_RESOURCES_RESOURCE_VERSION

Constant for the new column RESOURCE_VERSION of the CMS_RESOURCES tables.

See Also:

• Constant Field Values

REPLACEMENT_TABLENAME

protected static final String REPLACEMENT_TABLENAME

Constant for the sql replacement of the tablename.

See Also:

• Constant Field Values

TABLE_CMS_OFFLINE_CONTENTS

protected static final String TABLE_CMS_OFFLINE_CONTENTS

Constant for the table name CMS_OFFLINE_CONTENTS.

See Also:

• Constant Field Values

TABLE_CMS_PROJECTS

protected static final String TABLE_CMS_PROJECTS

Constant for the table name CMS_PROJECTS.

See Also:

• Constant Field Values

Constructor Details

CmsUpdateDBAlterTables

public CmsUpdateDBAlterTables()
                       throws IOException

Default constructor.

Throws:

IOException - if the default sql queries property file could not be read

Method Details

internalExecute

protected void internalExecute(CmsSetupDb dbCon)
                        throws SQLException

Description copied from class: A_CmsUpdateDBPart

Does the hard work.

Specified by:

internalExecute in class A_CmsUpdateDBPart

Parameters:

dbCon - the db connection interface

Throws:

SQLException - if something goes wrong

See Also:

• A_CmsUpdateDBPart.internalExecute(org.opencms.setup.CmsSetupDb)