| java.lang.Object
 org.opencms.setup.update6to7.A_CmsUpdateDBPart
org.opencms.setup.update6to7.generic.CmsUpdateDBUpdateOU
All known Subclasses: org.opencms.setup.update6to7.mysql.CmsUpdateDBUpdateOU, org.opencms.setup.update6to7.postgresql.CmsUpdateDBUpdateOU, org.opencms.setup.update6to7.oracle.CmsUpdateDBUpdateOU,
| CmsUpdateDBUpdateOU | | public class CmsUpdateDBUpdateOU extends A_CmsUpdateDBPart (Code) | | 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
author:
Roland Metzler
version:
$Revision: 1.2 $
since:
7.0.0 |
| GROUP_OU_COLUMN | | final protected static String GROUP_OU_COLUMN(Code) | | Constant for the GROUP_OU column.
|
| PROJECT_OU_COLUMN | | final protected static String PROJECT_OU_COLUMN(Code) | | Constant for the PROJECT_OU column.
|
| QUERY_ADD_OUS_TO_TABLE | | final protected static String QUERY_ADD_OUS_TO_TABLE(Code) | | Constant for the query that adds the ous to the table.
|
| QUERY_KEY_ALTER_TABLE | | final protected static String QUERY_KEY_ALTER_TABLE(Code) | | Constant for the alteration of the table.
|
| REPLACEMENT_COLUMNNAME | | final protected static String REPLACEMENT_COLUMNNAME(Code) | | Constant for the replacement in the SQL query for the columnname.
|
| REPLACEMENT_TABLENAME | | final protected static String REPLACEMENT_TABLENAME(Code) | | Constant for the replacement in the SQL query for the tablename.
|
| TABLE_BACKUP_PROJECTS | | final protected static String TABLE_BACKUP_PROJECTS(Code) | | Constant for the CMS_BACKUP_PROJECTS table.
|
| TABLE_CMS_GROUPS | | final protected static String TABLE_CMS_GROUPS(Code) | | Constant for the CMS_GROUPS table.
|
| TABLE_CMS_USERS | | final protected static String TABLE_CMS_USERS(Code) | | Constant for the CMS_USERS table.
|
| TABLE_PROJECTS | | final protected static String TABLE_PROJECTS(Code) | | Constant for the CMS_PROJECTS table.
|
| USER_OU_COLUMN | | final protected static String USER_OU_COLUMN(Code) | | Constant for the USER_OU column.
|
| CmsUpdateDBUpdateOU | | public CmsUpdateDBUpdateOU() throws IOException(Code) | | Constructor.
throws:
IOException - if the sql queries properties file could not be read |
| findOUColumn | | protected boolean findOUColumn(CmsSetupDb dbCon, String table, String ouColumn)(Code) | | Checks if the column USER_OU is found in the resultset.
Parameters:
dbCon - the db connection interface
Parameters:
table - the table to check
Parameters:
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 |
| updateOUs | | protected int updateOUs(CmsSetupDb dbCon, String table, String ouColumn)(Code) | | Updates the database tables with the new OUs if necessary for the given table.
Parameters:
dbCon - the db connection interface
Parameters:
table - the table to update
Parameters:
ouColumn - the column to insert true if everything worked fine, false if not |
|
|