org.opencms.setup.db.update6to7.mysql

类 CmsUpdateDBProjectId

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBProjectId

org.opencms.setup.db.update6to7.mysql.CmsUpdateDBProjectId

所有已实现的接口:

I_CmsUpdateDBPart

public class CmsUpdateDBProjectId
extends CmsUpdateDBProjectId

This class updates the project ids from integer values to CmsUUIDs in all existing database tables.

It creates new UUIDs for each existing project and stores it into a temporary table.

For each table using a project id a new column for the UUID is added and the according data is transferred.

After that the original indexes and the column for the project id index is dropped and the new column with the project uuid becomes the primary key.

字段概要

从类继承的字段 org.opencms.setup.db.update6to7.CmsUpdateDBProjectId

COLUMN_PROJECT_ID, COLUMN_PROJECT_LASTMODIFIED, COLUMN_PROJECT_UUID, COLUMN_TEMP_PROJECT_UUID, HISTORY_PROJECTS_TABLE, QUERY_ADD_PRIMARY_KEY, QUERY_ADD_TEMP_UUID_COLUMN, QUERY_CREATE_HISTORY_PROJECTS_TABLE, QUERY_CREATE_TEMP_TABLE_UUIDS, QUERY_DESCRIBE_TABLE, QUERY_READ_MAX_PUBTAG, REPLACEMENT_COLUMN, REPLACEMENT_NEW_COLUMN, REPLACEMENT_OLDID, REPLACEMENT_PRIMARY_KEY, REPLACEMENT_TABLENAME, RESOURCE_TABLES, RESOURCES_TABLES_LIST, TABLES, TABLES_LIST, TEMP_UUID_COLUMN, TEMPORARY_TABLE_NAME

从类继承的字段 org.opencms.setup.db.A_CmsUpdateDBPart

m_poolData, m_queries

构造器概要

构造器

构造器和说明
CmsUpdateDBProjectId() Constructor.

方法概要

方法

限定符和类型	方法和说明
protected void	createHistProjectsTable(CmsSetupDb dbCon) Creates the CMS_HISTORY_PROJECTS table if it does not exist yet.
protected void	createTempTable(CmsSetupDb dbCon) Creates the temp table for project ids if it does not exist yet.

从类继承的方法 org.opencms.setup.db.update6to7.CmsUpdateDBProjectId

addPrimaryKey, addUUIDColumnToTable, checkColumnTypeProjectId, getColumnProjectIdResourcePath, internalExecute, needsUpdating, transferDataToHistoryTable

从类继承的方法 org.opencms.setup.db.A_CmsUpdateDBPart

execute, getPoolData, getPropertyFileLocation, isKeepHistory, loadQueryProperties, readQuery

从类继承的方法 java.lang.Object

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

构造器详细资料

CmsUpdateDBProjectId

public CmsUpdateDBProjectId()
                     throws java.io.IOException

Constructor.

抛出:

java.io.IOException - if the query properties cannot be read

方法详细资料

createHistProjectsTable

protected void createHistProjectsTable(CmsSetupDb dbCon)
                                throws java.sql.SQLException

Creates the CMS_HISTORY_PROJECTS table if it does not exist yet.

覆盖:

createHistProjectsTable 在类中 CmsUpdateDBProjectId

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if something goes wrong

createTempTable

protected void createTempTable(CmsSetupDb dbCon)
                        throws java.sql.SQLException

Creates the temp table for project ids if it does not exist yet.

覆盖:

createTempTable 在类中 CmsUpdateDBProjectId

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if something goes wrong