Package org.opencms.setup.db.update6to7.postgresql

Class CmsUpdateDBContentTables

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBContentTables

org.opencms.setup.db.update6to7.postgresql.CmsUpdateDBContentTables

All Implemented Interfaces:

I_CmsUpdateDBPart

public class CmsUpdateDBContentTables
extends CmsUpdateDBContentTables

PostgreSQL implementation of the generic update of the contents tables.

Since:

7.0.2

Field Summary

Fields

Modifier and Type	Field	Description
protected static final String	QUERY_UPDATE_ONLINE_CONTENTS_PUBLISH_TAG_FROM	Constant for the sql query to transfer the online contents.
protected static final String	QUERY_UPDATE_ONLINE_CONTENTS_PUBLISH_TAG_TO	Constant for the sql query to transfer the online contents.

Fields inherited from class org.opencms.setup.db.update6to7.CmsUpdateDBContentTables

QUERY_CREATE_CMS_CONTENTS_TABLE, QUERY_TRANSFER_ONLINE_CONTENTS, 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	transferOnlineContents(CmsSetupDb dbCon, int pubTag)	Transfers the online content.

Methods inherited from class org.opencms.setup.db.update6to7.CmsUpdateDBContentTables

internalExecute

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_UPDATE_ONLINE_CONTENTS_PUBLISH_TAG_FROM

protected static final String QUERY_UPDATE_ONLINE_CONTENTS_PUBLISH_TAG_FROM

Constant for the sql query to transfer the online contents.

See Also:

• Constant Field Values

QUERY_UPDATE_ONLINE_CONTENTS_PUBLISH_TAG_TO

protected static final String QUERY_UPDATE_ONLINE_CONTENTS_PUBLISH_TAG_TO

Constant for the sql query to transfer the online contents.

See Also:

• Constant Field Values

Constructor Details

CmsUpdateDBContentTables

public CmsUpdateDBContentTables()
                         throws IOException

Constructor.

Throws:

IOException - if the sql queries properties file could not be read

Method Details

createContentsTable

protected void createContentsTable(CmsSetupDb dbCon)
                            throws SQLException

Description copied from class: CmsUpdateDBContentTables

Creates the CMS_CONTENTS table if it does not exist yet.

Overrides:

createContentsTable in class CmsUpdateDBContentTables

Parameters:

dbCon - the db connection interface

Throws:

SQLException - if something goes wrong

See Also:

• CmsUpdateDBContentTables.createContentsTable(org.opencms.setup.CmsSetupDb)

transferOnlineContents

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

Description copied from class: CmsUpdateDBContentTables

Transfers the online content.

Overrides:

transferOnlineContents in class CmsUpdateDBContentTables

Parameters:

dbCon - the db connection interface

pubTag - the publish tag to use

Throws:

SQLException - if something goes wrong

See Also:

• CmsUpdateDBContentTables.transferOnlineContents(org.opencms.setup.CmsSetupDb, int)