Package org.opencms.setup.db.update6to7

Class CmsUpdateDBContentTables

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBContentTables

All Implemented Interfaces:

I_CmsUpdateDBPart

Direct Known Subclasses:

CmsUpdateDBContentTables, CmsUpdateDBContentTables, CmsUpdateDBContentTables

public class CmsUpdateDBContentTables
extends A_CmsUpdateDBPart

This class creates the table CMS_CONTENTS and fills it with data from the tables CMS_BACKUP_CONTENTS and CMS_ONLINE_CONTENTS.

Since:

7.0.0

Field Summary

Fields

Modifier and Type	Field	Description
protected static final String	QUERY_CREATE_CMS_CONTENTS_TABLE	Constant for the sql query to create the CMS_CONTENTS table.
protected static final String	QUERY_TRANSFER_ONLINE_CONTENTS	Constant for the sql query to transfer the online contents.
protected static final String	TABLE_CMS_CONTENTS	Constant for the table CMS_CONTENTS.

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

m_poolData, m_queries

Constructor Summary

Constructors

Constructor	Description
CmsUpdateDBContentTables()	Constructor.

Method Summary

Modifier and Type	Method	Description
protected void	createContentsTable(CmsSetupDb dbCon)	Creates the CMS_CONTENTS table if it does not exist yet.
protected void	internalExecute(CmsSetupDb dbCon)	Does the hard work.
protected void	transferOnlineContents(CmsSetupDb dbCon, int pubTag)	Transfers the online content.

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

QUERY_CREATE_CMS_CONTENTS_TABLE

protected static final String QUERY_CREATE_CMS_CONTENTS_TABLE

Constant for the sql query to create the CMS_CONTENTS table.

See Also:

• Constant Field Values

QUERY_TRANSFER_ONLINE_CONTENTS

protected static final String QUERY_TRANSFER_ONLINE_CONTENTS

Constant for the sql query to transfer the online contents.

See Also:

• Constant Field Values

TABLE_CMS_CONTENTS

protected static final String TABLE_CMS_CONTENTS

Constant for the table CMS_CONTENTS.

See Also:

• Constant Field Values

Constructor Details

CmsUpdateDBContentTables

public CmsUpdateDBContentTables()
                         throws IOException

Constructor.

Throws:

IOException - if the query properties cannot be read

Method Details

createContentsTable

protected void createContentsTable(CmsSetupDb dbCon)
                            throws SQLException

Creates the CMS_CONTENTS table if it does not exist yet.

Parameters:

dbCon - the db connection interface

Throws:

SQLException - if something goes wrong

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)

transferOnlineContents

protected void transferOnlineContents(CmsSetupDb dbCon,
 int pubTag)
                               throws SQLException

Transfers the online content.

Parameters:

dbCon - the db connection interface

pubTag - the publish tag to use

Throws:

SQLException - if something goes wrong