org.opencms.setup.db.update6to7

类 CmsUpdateDBUpdateOU

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBUpdateOU

所有已实现的接口:

I_CmsUpdateDBPart

直接已知子类:

CmsUpdateDBUpdateOU, CmsUpdateDBUpdateOU, CmsUpdateDBUpdateOU

public class CmsUpdateDBUpdateOU
extends A_CmsUpdateDBPart

This class upgrades the database tables containing new OU columns.

These tables are cms_groups cms_history_principals cms_history_projects cms_projects cms_users

从以下版本开始:

7.0.0

字段概要

字段

限定符和类型	字段和说明
protected static java.lang.String	GROUP_OU_COLUMN Constant for the GROUP_OU column.
protected static java.lang.String	PROJECT_OU_COLUMN Constant for the PROJECT_OU column.
protected static java.lang.String	QUERY_ADD_OUS_TO_TABLE Constant for the query that adds the ous to the table.
protected static java.lang.String	QUERY_KEY_ALTER_TABLE Constant for the alteration of the table.
protected static java.lang.String	REPLACEMENT_COLUMNNAME Constant for the replacement in the SQL query for the columnname.
protected static java.lang.String	REPLACEMENT_TABLENAME Constant for the replacement in the SQL query for the tablename.
protected static java.lang.String	TABLE_BACKUP_PROJECTS Constant for the CMS_BACKUP_PROJECTS table.
protected static java.lang.String	TABLE_CMS_GROUPS Constant for the CMS_GROUPS table.
protected static java.lang.String	TABLE_CMS_USERS Constant for the CMS_USERS table.
protected static java.lang.String	TABLE_PROJECTS Constant for the CMS_PROJECTS table.
protected static java.lang.String	USER_OU_COLUMN Constant for the USER_OU column.

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

m_poolData, m_queries

构造器概要

构造器

构造器和说明
CmsUpdateDBUpdateOU() Constructor.

方法概要

方法

限定符和类型	方法和说明
protected boolean	findOUColumn(CmsSetupDb dbCon, java.lang.String table, java.lang.String ouColumn) Checks if the column USER_OU is found in the resultset.
protected void	internalExecute(CmsSetupDb dbCon) Does the hard work.
protected int	updateOUs(CmsSetupDb dbCon, java.lang.String table, java.lang.String ouColumn) Updates the database tables with the new OUs if necessary for the given 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

字段详细资料

GROUP_OU_COLUMN

protected static final java.lang.String GROUP_OU_COLUMN

Constant for the GROUP_OU column.

另请参阅:

常量字段值

PROJECT_OU_COLUMN

protected static final java.lang.String PROJECT_OU_COLUMN

Constant for the PROJECT_OU column.

另请参阅:

常量字段值

QUERY_ADD_OUS_TO_TABLE

protected static final java.lang.String QUERY_ADD_OUS_TO_TABLE

Constant for the query that adds the ous to the table.

另请参阅:

常量字段值

QUERY_KEY_ALTER_TABLE

protected static final java.lang.String QUERY_KEY_ALTER_TABLE

Constant for the alteration of the table.

另请参阅:

常量字段值

REPLACEMENT_COLUMNNAME

protected static final java.lang.String REPLACEMENT_COLUMNNAME

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

另请参阅:

常量字段值

REPLACEMENT_TABLENAME

protected static final java.lang.String REPLACEMENT_TABLENAME

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

另请参阅:

常量字段值

TABLE_BACKUP_PROJECTS

protected static final java.lang.String TABLE_BACKUP_PROJECTS

Constant for the CMS_BACKUP_PROJECTS table.

另请参阅:

常量字段值

TABLE_CMS_GROUPS

protected static final java.lang.String TABLE_CMS_GROUPS

Constant for the CMS_GROUPS table.

另请参阅:

常量字段值

TABLE_CMS_USERS

protected static final java.lang.String TABLE_CMS_USERS

Constant for the CMS_USERS table.

另请参阅:

常量字段值

TABLE_PROJECTS

protected static final java.lang.String TABLE_PROJECTS

Constant for the CMS_PROJECTS table.

另请参阅:

常量字段值

USER_OU_COLUMN

protected static final java.lang.String USER_OU_COLUMN

Constant for the USER_OU column.

另请参阅:

常量字段值

构造器详细资料

CmsUpdateDBUpdateOU

public CmsUpdateDBUpdateOU()
                    throws java.io.IOException

Constructor.

抛出:

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

方法详细资料

findOUColumn

protected boolean findOUColumn(CmsSetupDb dbCon,
                   java.lang.String table,
                   java.lang.String ouColumn)

Checks if the column USER_OU is found in the resultset.

参数:

dbCon - the db connection interface

table - the table to check

ouColumn - the type of OU to find (e.g. USER_OU or GROUP_OU)

返回:

true if the column is in the result set, false if not

internalExecute

protected void internalExecute(CmsSetupDb dbCon)

从类复制的说明: A_CmsUpdateDBPart

Does the hard work.

指定者:

internalExecute 在类中 A_CmsUpdateDBPart

参数:

dbCon - the db connection interface

另请参阅:

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

updateOUs

protected int updateOUs(CmsSetupDb dbCon,
            java.lang.String table,
            java.lang.String ouColumn)

Updates the database tables with the new OUs if necessary for the given table.

参数:

dbCon - the db connection interface

table - the table to update

ouColumn - the column to insert

返回:

true if everything worked fine, false if not