org.opencms.setup.db.update6to7

类 CmsUpdateDBCmsUsers

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBCmsUsers

所有已实现的接口:

I_CmsUpdateDBPart

直接已知子类:

CmsUpdateDBCmsUsers, CmsUpdateDBCmsUsers, CmsUpdateDBCmsUsers

public class CmsUpdateDBCmsUsers
extends A_CmsUpdateDBPart

This class makes an update of the CMS_USERS table splitting it up into CMS_USERS and CMS_USERDATA.

Unnecessary colums from CMS_USERS will be deleted and the new column USER_DATECREATED is added.

从以下版本开始:

7.0.0

字段概要

字段

限定符和类型	字段和说明
protected static java.lang.String	QUERY_CREATE_TABLE_USERDATA Constant for the query to create the user data table.
protected static java.lang.String	QUERY_INSERT_CMS_USERDATA Constant for the query to insert the new user data into the new table CMS_USERDATA.

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

m_poolData, m_queries

构造器概要

构造器

构造器和说明
CmsUpdateDBCmsUsers() Default constructor.

方法概要

方法

限定符和类型	方法和说明
protected void	addUserDateCreated(CmsSetupDb dbCon) Adds the new column USER_DATECREATED to the CMS_USERS table.
protected void	addWebusersToGroup(CmsSetupDb dbCon, CmsUUID id) Adds all webusers to the new previously created webusers group.
protected boolean	checkUserDataTable(CmsSetupDb dbCon) Checks if the CMS_USERDATA table exists.
protected void	createUserDataTable(CmsSetupDb dbCon) Creates the CMS_USERDATA table if it does not exist yet.
protected CmsUUID	createWebusersGroup(CmsSetupDb dbCon) creates a new group for the webusers.
protected void	internalExecute(CmsSetupDb dbCon) Does the hard work.
protected void	removeUnnecessaryColumns(CmsSetupDb dbCon) Removes the columns USER_INFO, USER_ADDRESS, USER_DESCRIPTION and USER_TYPE from the CMS_USERS table.
protected void	writeAdditionalUserInfo(CmsSetupDb dbCon, java.lang.String id, java.util.Map<java.lang.String,java.lang.Object> additionalInfo) Writes the additional user infos to the database.
protected void	writeUserInfo(CmsSetupDb dbCon, java.lang.String id, java.lang.String key, java.lang.Object value) Writes one set of additional user info (key and its value) to the CMS_USERDATA 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

字段详细资料

QUERY_CREATE_TABLE_USERDATA

protected static final java.lang.String QUERY_CREATE_TABLE_USERDATA

Constant for the query to create the user data table.

另请参阅:

常量字段值

QUERY_INSERT_CMS_USERDATA

protected static final java.lang.String QUERY_INSERT_CMS_USERDATA

Constant for the query to insert the new user data into the new table CMS_USERDATA.

另请参阅:

常量字段值

构造器详细资料

CmsUpdateDBCmsUsers

public CmsUpdateDBCmsUsers()
                    throws java.io.IOException

Default constructor.

抛出:

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

方法详细资料

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)

addUserDateCreated

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

Adds the new column USER_DATECREATED to the CMS_USERS table.

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if something goes wrong

addWebusersToGroup

protected void addWebusersToGroup(CmsSetupDb dbCon,
                      CmsUUID id)
                           throws java.sql.SQLException

Adds all webusers to the new previously created webusers group.

参数:

dbCon - the db connection interface

id - the id of the new webusers group

抛出:

java.sql.SQLException - if something goes wrong

checkUserDataTable

protected boolean checkUserDataTable(CmsSetupDb dbCon)

Checks if the CMS_USERDATA table exists.

参数:

dbCon - the db connection interface

返回:

true if it exists, false if not.

createUserDataTable

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

Creates the CMS_USERDATA table if it does not exist yet.

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if soemthing goes wrong

createWebusersGroup

protected CmsUUID createWebusersGroup(CmsSetupDb dbCon)
                               throws java.sql.SQLException

creates a new group for the webusers.

参数:

dbCon - the db connection interface

返回:

the id of the new generated group

抛出:

java.sql.SQLException - if something goes wrong

removeUnnecessaryColumns

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

Removes the columns USER_INFO, USER_ADDRESS, USER_DESCRIPTION and USER_TYPE from the CMS_USERS table.

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if something goes wrong

writeAdditionalUserInfo

protected void writeAdditionalUserInfo(CmsSetupDb dbCon,
                           java.lang.String id,
                           java.util.Map<java.lang.String,java.lang.Object> additionalInfo)

Writes the additional user infos to the database.

参数:

dbCon - the db connection interface

id - the user id

additionalInfo - the additional info of the user

writeUserInfo

protected void writeUserInfo(CmsSetupDb dbCon,
                 java.lang.String id,
                 java.lang.String key,
                 java.lang.Object value)

Writes one set of additional user info (key and its value) to the CMS_USERDATA table.

参数:

dbCon - the db connection interface

id - the user id

key - the data key

value - the data value