org.opencms.setup.db.update6to7.postgresql

类 CmsUpdateDBProjectId

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBProjectId

org.opencms.setup.db.update6to7.postgresql.CmsUpdateDBProjectId

所有已实现的接口:

I_CmsUpdateDBPart

public class CmsUpdateDBProjectId
extends CmsUpdateDBProjectId

PostgreSQL implementation to update the project ids to uuids.

从以下版本开始:

7.0.2

字段概要

从类继承的字段 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	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 boolean	needsUpdating(CmsSetupDb dbCon, java.lang.String tablename) Checks if the given table needs an update of the uuids.

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

internalExecute, 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 sql queries properties file could not be read

方法详细资料

addPrimaryKey

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

从类复制的说明: CmsUpdateDBProjectId

Adds a new primary key to the given table.

覆盖:

addPrimaryKey 在类中 CmsUpdateDBProjectId

参数:

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

另请参阅:

CmsUpdateDBProjectId.addPrimaryKey(org.opencms.setup.CmsSetupDb, java.lang.String, java.lang.String)

addUUIDColumnToTable

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

从类复制的说明: CmsUpdateDBProjectId

Adds the new column for the uuids to a table.

覆盖:

addUUIDColumnToTable 在类中 CmsUpdateDBProjectId

参数:

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

另请参阅:

CmsUpdateDBProjectId.addUUIDColumnToTable(org.opencms.setup.CmsSetupDb, java.lang.String, java.lang.String)

checkColumnTypeProjectId

protected boolean checkColumnTypeProjectId(int type)

从类复制的说明: CmsUpdateDBProjectId

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

覆盖:

checkColumnTypeProjectId 在类中 CmsUpdateDBProjectId

参数:

type - the type of the column from the meta data

返回:

true if the type is incorrect

另请参阅:

CmsUpdateDBProjectId.checkColumnTypeProjectId(int)

createHistProjectsTable

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

从类复制的说明: CmsUpdateDBProjectId

Creates the CMS_HISTORY_PROJECTS table if it does not exist yet.

覆盖:

createHistProjectsTable 在类中 CmsUpdateDBProjectId

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if soemthing goes wrong

另请参阅:

CmsUpdateDBProjectId.createHistProjectsTable(org.opencms.setup.CmsSetupDb)

createTempTable

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

从类复制的说明: CmsUpdateDBProjectId

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

覆盖:

createTempTable 在类中 CmsUpdateDBProjectId

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if soemthing goes wrong

另请参阅:

CmsUpdateDBProjectId.createTempTable(org.opencms.setup.CmsSetupDb)

getColumnProjectIdResourcePath

protected java.lang.String getColumnProjectIdResourcePath()

从类复制的说明: CmsUpdateDBProjectId

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

覆盖:

getColumnProjectIdResourcePath 在类中 CmsUpdateDBProjectId

返回:

the columns for the primary key of the project resources table

另请参阅:

CmsUpdateDBProjectId.getColumnProjectIdResourcePath()

needsUpdating

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

从类复制的说明: CmsUpdateDBProjectId

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

覆盖:

needsUpdating 在类中 CmsUpdateDBProjectId

参数:

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

另请参阅:

CmsUpdateDBProjectId.needsUpdating(org.opencms.setup.CmsSetupDb, java.lang.String)