org.opencms.setup.db.update6to7

类 CmsUpdateDBProjectId

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBProjectId

所有已实现的接口:

I_CmsUpdateDBPart

直接已知子类:

CmsUpdateDBProjectId, CmsUpdateDBProjectId, CmsUpdateDBProjectId

public class CmsUpdateDBProjectId
extends A_CmsUpdateDBPart

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.

从以下版本开始:

7.0.0

字段概要

字段

限定符和类型	字段和说明
protected static java.lang.String	COLUMN_PROJECT_ID Constant for the sql column PROJECT_ID.
protected static java.lang.String	COLUMN_PROJECT_LASTMODIFIED Constant for the sql query to use the column PROJECT_LASTMODIFIED.
protected static java.lang.String	COLUMN_PROJECT_UUID Constant for the sql column PROJECT_UUID.
protected static java.lang.String	COLUMN_TEMP_PROJECT_UUID Constant for the sql column TEMP_PROJECT_UUID.
protected static java.lang.String	HISTORY_PROJECTS_TABLE Constant for the table name of the CMS_HISTORY_PROJECTS table.
protected static java.lang.String	QUERY_ADD_PRIMARY_KEY Constant for the sql query to add a new primary key.
protected static java.lang.String	QUERY_ADD_TEMP_UUID_COLUMN Constant for the sql query to add a new column to the table.
protected static java.lang.String	QUERY_CREATE_HISTORY_PROJECTS_TABLE Constant for the sql query to create the new CMS_HISTORY_PROJECTS table.
protected static java.lang.String	QUERY_CREATE_TEMP_TABLE_UUIDS Constant for the sql query to create the temporary table.
protected static java.lang.String	QUERY_DESCRIBE_TABLE Constant for the sql query to describe the given table.
protected static java.lang.String	QUERY_READ_MAX_PUBTAG Constant for the sql query to read max publish tag.
protected static java.lang.String	REPLACEMENT_COLUMN Constant for the replacement in the SQL query for the columnname.
protected static java.lang.String	REPLACEMENT_NEW_COLUMN Constant for the replacement in the SQL query for the new columnname.
protected static java.lang.String	REPLACEMENT_OLDID Constant for the replacement in the SQL query for old id to update.
protected static java.lang.String	REPLACEMENT_PRIMARY_KEY Constant for the replacement in the SQL query for the primary key.
protected static java.lang.String	REPLACEMENT_TABLENAME Constant for the replacement in the SQL query for the tablename.
protected static java.lang.String[]	RESOURCE_TABLES Array of the online and offline resources tables.
protected static java.util.List<java.lang.String>	RESOURCES_TABLES_LIST Arraylist for the online and offline resources tables that shall be updated.
protected static java.lang.String[]	TABLES Array of the tables that are to be updated.
protected static java.util.List<java.lang.String>	TABLES_LIST Arraylist for the tables that shall be updated.
protected static java.lang.String	TEMP_UUID_COLUMN Constant for the temporary UUID column in the tables.
protected static java.lang.String	TEMPORARY_TABLE_NAME Constant for the name of temporary table containing the project ids and uuids.

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

m_poolData, m_queries

构造器概要

构造器

构造器和说明
CmsUpdateDBProjectId() Constructor.

方法概要

方法

限定符和类型	方法和说明
protected void	addPrimaryKey(CmsSetupDb dbCon, java.lang.String tablename, java.lang.String primaryKey) Adds a new primary key to the given table.
protected void	addUUIDColumnToTable(CmsSetupDb dbCon, java.lang.String tablename, java.lang.String column) Adds the new column for the uuids to a table.
protected boolean	checkColumnTypeProjectId(int type) Check if the column type of the project id is incorrect.
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.
protected java.lang.String	getColumnProjectIdResourcePath() Returns the columns for the primary key of the project resources table.
protected void	internalExecute(CmsSetupDb dbCon) Does the hard work.
protected boolean	needsUpdating(CmsSetupDb dbCon, java.lang.String tablename) Checks if the given table needs an update of the uuids.
protected void	transferDataToHistoryTable(CmsSetupDb dbCon) Transfers the data from the CMS_BACKUP_PROJECTS to the CMS_HISTORY_PROJECTS table.

从类继承的方法 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

字段详细资料

COLUMN_PROJECT_ID

protected static final java.lang.String COLUMN_PROJECT_ID

Constant for the sql column PROJECT_ID.

另请参阅:

常量字段值

COLUMN_PROJECT_LASTMODIFIED

protected static final java.lang.String COLUMN_PROJECT_LASTMODIFIED

Constant for the sql query to use the column PROJECT_LASTMODIFIED.

另请参阅:

常量字段值

COLUMN_PROJECT_UUID

protected static final java.lang.String COLUMN_PROJECT_UUID

Constant for the sql column PROJECT_UUID.

另请参阅:

常量字段值

COLUMN_TEMP_PROJECT_UUID

protected static final java.lang.String COLUMN_TEMP_PROJECT_UUID

Constant for the sql column TEMP_PROJECT_UUID.

另请参阅:

常量字段值

HISTORY_PROJECTS_TABLE

protected static final java.lang.String HISTORY_PROJECTS_TABLE

Constant for the table name of the CMS_HISTORY_PROJECTS table.

另请参阅:

常量字段值

QUERY_ADD_PRIMARY_KEY

protected static final java.lang.String QUERY_ADD_PRIMARY_KEY

Constant for the sql query to add a new primary key.

另请参阅:

常量字段值

QUERY_ADD_TEMP_UUID_COLUMN

protected static final java.lang.String QUERY_ADD_TEMP_UUID_COLUMN

Constant for the sql query to add a new column to the table.

另请参阅:

常量字段值

QUERY_CREATE_HISTORY_PROJECTS_TABLE

protected static final java.lang.String QUERY_CREATE_HISTORY_PROJECTS_TABLE

Constant for the sql query to create the new CMS_HISTORY_PROJECTS table.

另请参阅:

常量字段值

QUERY_CREATE_TEMP_TABLE_UUIDS

protected static final java.lang.String QUERY_CREATE_TEMP_TABLE_UUIDS

Constant for the sql query to create the temporary table.

另请参阅:

常量字段值

QUERY_DESCRIBE_TABLE

protected static final java.lang.String QUERY_DESCRIBE_TABLE

Constant for the sql query to describe the given table.

另请参阅:

常量字段值

QUERY_READ_MAX_PUBTAG

protected static final java.lang.String QUERY_READ_MAX_PUBTAG

Constant for the sql query to read max publish tag.

另请参阅:

常量字段值

REPLACEMENT_COLUMN

protected static final java.lang.String REPLACEMENT_COLUMN

Constant for the replacement in the SQL query for the columnname.

另请参阅:

常量字段值

REPLACEMENT_NEW_COLUMN

protected static final java.lang.String REPLACEMENT_NEW_COLUMN

Constant for the replacement in the SQL query for the new columnname.

另请参阅:

常量字段值

REPLACEMENT_OLDID

protected static final java.lang.String REPLACEMENT_OLDID

Constant for the replacement in the SQL query for old id to update.

另请参阅:

常量字段值

REPLACEMENT_PRIMARY_KEY

protected static final java.lang.String REPLACEMENT_PRIMARY_KEY

Constant for the replacement in the SQL query for the primary key.

另请参阅:

常量字段值

REPLACEMENT_TABLENAME

protected static final java.lang.String REPLACEMENT_TABLENAME

Constant for the replacement in the SQL query for the tablename.

另请参阅:

常量字段值

RESOURCE_TABLES

protected static final java.lang.String[] RESOURCE_TABLES

Array of the online and offline resources tables.

RESOURCES_TABLES_LIST

protected static final java.util.List<java.lang.String> RESOURCES_TABLES_LIST

Arraylist for the online and offline resources tables that shall be updated.

TABLES

protected static final java.lang.String[] TABLES

Array of the tables that are to be updated.

TABLES_LIST

protected static final java.util.List<java.lang.String> TABLES_LIST

Arraylist for the tables that shall be updated.

TEMP_UUID_COLUMN

protected static final java.lang.String TEMP_UUID_COLUMN

Constant for the temporary UUID column in the tables.

另请参阅:

常量字段值

TEMPORARY_TABLE_NAME

protected static final java.lang.String TEMPORARY_TABLE_NAME

Constant for the name of temporary table containing the project ids and uuids.

另请参阅:

常量字段值

构造器详细资料

CmsUpdateDBProjectId

public CmsUpdateDBProjectId()
                     throws java.io.IOException

Constructor.

抛出:

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

方法详细资料

addPrimaryKey

protected void addPrimaryKey(CmsSetupDb dbCon,
                 java.lang.String tablename,
                 java.lang.String primaryKey)
                      throws java.sql.SQLException

Adds a new primary key to the given table.

参数:

dbCon - the db connection interface

tablename - the table to add the primary key to

primaryKey - the new primary key

抛出:

java.sql.SQLException - if something goes wrong

addUUIDColumnToTable

protected void addUUIDColumnToTable(CmsSetupDb dbCon,
                        java.lang.String tablename,
                        java.lang.String column)
                             throws java.sql.SQLException

Adds the new column for the uuids to a table.

参数:

dbCon - the db connection interface

tablename - the table to add the column to

column - the new colum to add

抛出:

java.sql.SQLException - if something goes wrong

checkColumnTypeProjectId

protected boolean checkColumnTypeProjectId(int type)

Check if the column type of the project id is incorrect.

参数:

type - the type of the column from the meta data

返回:

true if the type is incorrect

createHistProjectsTable

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

Creates the CMS_HISTORY_PROJECTS table if it does not exist yet.

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if soemthing 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.

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if soemthing goes wrong

getColumnProjectIdResourcePath

protected java.lang.String getColumnProjectIdResourcePath()

Returns the columns for the primary key of the project resources table.

返回:

the columns for the primary key of the project resources table

internalExecute

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

从类复制的说明: A_CmsUpdateDBPart

Does the hard work.

指定者:

internalExecute 在类中 A_CmsUpdateDBPart

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if something goes wrong

另请参阅:

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

needsUpdating

protected boolean needsUpdating(CmsSetupDb dbCon,
                    java.lang.String tablename)
                         throws java.sql.SQLException

Checks if the given table needs an update of the uuids.

参数:

dbCon - the db connection interface

tablename - the table to check

返回:

true if the project ids are not yet updated, false if nothing needs to be done

抛出:

java.sql.SQLException - if something goes wrong

transferDataToHistoryTable

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

Transfers the data from the CMS_BACKUP_PROJECTS to the CMS_HISTORY_PROJECTS table.

The datetime type for the column PROJECT_PUBLISHDATE is converted to the new long value.

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if something goes wrong