oracle.ifs.core.util

Class CrawlerUtilities

java.lang.Object

oracle.ifs.core.util.CrawlerUtilities

public class CrawlerUtilities
extends Object

CralwerUtilities exposes utility methods used to primarily support CrawlerHandler in invoking DDL and batch JDBC DML against the ECM schema.

Author:

Matt Shannon

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	CrawlerUtilities.AlertType
static class	CrawlerUtilities.BatchAlertInserter

Field Summary

Fields

Modifier and Type	Field and Description
static String	ALERT_SEQUENCE_NAME Sequence name used for populating seq column of alert tables when performing inserts.
static String	ATTRIBUTE_DATATYPE_TABLE_NAME Table name for attribute data type mapping table
static String	CRAWLER_ALERTTYPE_TABLE_NAME Table name for crawler alert type mapping table
static String	DOCUMENTCATEGORYTYPE_VIEWNAME_SELECT_STATEMENT Select statement to retrieve adhoc category view names from odmzv_document_category_type view.
static String	VIEW_NAME_CANDIDATEACLS View name for odmzv_candidateacls.
static String	VIEW_NAME_CRAWLERPROPERTY View name for odmzv_crawler_property.
static String	VIEW_NAME_DOCUMENTCATEGORYATTR View name for odmzv_document_category_attr.
static String	VIEW_NAME_DOCUMENTCATEGORYINFO View name for odmzv_document_category_info.
static String	VIEW_NAME_DOCUMENTCATEGORYTYPE View name for odmzv_document_category_type.
static String	VIEW_NAME_DOCUMENTINFO View name for odmzv_document_info.
static String	VIEW_NAME_DOMAINPROPERTIES View name for odmzv_domain_properties.
static String	VIEW_NAME_FOLDERHIERARCHY View name for odmzv_folder_hierarchy.
static String	VIEW_NAME_RESOLVEDGRANTEE View name for odmzv_resolved_grantee.
static String	VIEW_NAME_RESOLVEDUSER View name for odmzv_resolved_user.
static String	VIEW_NAME_SECUREDDOCUMENT View name for odmzv_secured_document.
static String	VIEW_NAME_SECURITYDEFINITION View name for odmzv_security_definition.
static String	VIEW_NAME_USERINFO View name for odmzv_user_info.
static String[]	VIEW_NAMES The ordered array of View names to which access must be granted.

Method Summary

Modifier and Type	Method and Description
static void	createAlertTable(LibrarySession session, String tableName, String grantee) Create alert table for crawler instance, and grant all privileges to specified grantee.
static void	grantAccessToObjects(LibrarySession session, String grantee, boolean categoriesOnly) Grant select access to grantee on adhoc category views, and potentially map tables and crawler views should categoriesOnly parameter be set to false.
static DirectoryGroup[]	selectDirectoryGroups(LibrarySession session, long id) Selects the set of DirectoryGroups affected by the specified Group member change

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ATTRIBUTE_DATATYPE_TABLE_NAME

public static final String ATTRIBUTE_DATATYPE_TABLE_NAME

Table name for attribute data type mapping table

See Also:

Constant Field Values

CRAWLER_ALERTTYPE_TABLE_NAME

public static final String CRAWLER_ALERTTYPE_TABLE_NAME

Table name for crawler alert type mapping table

See Also:

Constant Field Values

ALERT_SEQUENCE_NAME

public static final String ALERT_SEQUENCE_NAME

Sequence name used for populating seq column of alert tables when performing inserts.

See Also:

Constant Field Values

VIEW_NAME_DOMAINPROPERTIES

public static final String VIEW_NAME_DOMAINPROPERTIES

View name for odmzv_domain_properties.

See Also:

Constant Field Values

VIEW_NAME_CANDIDATEACLS

public static final String VIEW_NAME_CANDIDATEACLS

View name for odmzv_candidateacls.

See Also:

Constant Field Values

VIEW_NAME_RESOLVEDUSER

public static final String VIEW_NAME_RESOLVEDUSER

View name for odmzv_resolved_user.

See Also:

Constant Field Values

VIEW_NAME_SECUREDDOCUMENT

public static final String VIEW_NAME_SECUREDDOCUMENT

View name for odmzv_secured_document.

See Also:

Constant Field Values

VIEW_NAME_SECURITYDEFINITION

public static final String VIEW_NAME_SECURITYDEFINITION

View name for odmzv_security_definition.

See Also:

Constant Field Values

VIEW_NAME_RESOLVEDGRANTEE

public static final String VIEW_NAME_RESOLVEDGRANTEE

View name for odmzv_resolved_grantee.

See Also:

Constant Field Values

VIEW_NAME_USERINFO

public static final String VIEW_NAME_USERINFO

View name for odmzv_user_info.

See Also:

Constant Field Values

VIEW_NAME_DOCUMENTINFO

public static final String VIEW_NAME_DOCUMENTINFO

View name for odmzv_document_info.

See Also:

Constant Field Values

VIEW_NAME_FOLDERHIERARCHY

public static final String VIEW_NAME_FOLDERHIERARCHY

View name for odmzv_folder_hierarchy.

See Also:

Constant Field Values

VIEW_NAME_DOCUMENTCATEGORYINFO

public static final String VIEW_NAME_DOCUMENTCATEGORYINFO

View name for odmzv_document_category_info.

See Also:

Constant Field Values

VIEW_NAME_DOCUMENTCATEGORYTYPE

public static final String VIEW_NAME_DOCUMENTCATEGORYTYPE

View name for odmzv_document_category_type.

See Also:

Constant Field Values

DOCUMENTCATEGORYTYPE_VIEWNAME_SELECT_STATEMENT

public static final String DOCUMENTCATEGORYTYPE_VIEWNAME_SELECT_STATEMENT

Select statement to retrieve adhoc category view names from odmzv_document_category_type view.

See Also:

Constant Field Values

VIEW_NAME_DOCUMENTCATEGORYATTR

public static final String VIEW_NAME_DOCUMENTCATEGORYATTR

View name for odmzv_document_category_attr.

See Also:

Constant Field Values

VIEW_NAME_CRAWLERPROPERTY

public static final String VIEW_NAME_CRAWLERPROPERTY

View name for odmzv_crawler_property.

See Also:

Constant Field Values

VIEW_NAMES

public static final String[] VIEW_NAMES

The ordered array of View names to which access must be granted.

Method Detail

grantAccessToObjects

public static void grantAccessToObjects(LibrarySession session,
                                        String grantee,
                                        boolean categoriesOnly)
                                 throws IfsException

Grant select access to grantee on adhoc category views, and potentially map tables and crawler views should categoriesOnly parameter be set to false.

Parameters:

session - the session context

grantee - the schema/user for whom to grant access

categoriesOnly - boolean - If true, only grants to adhoc category views are performed. If false, grants to all crawler views, map tables, and adhoc category views are made.

Throws:

IfsException - if the operation fails

createAlertTable

public static void createAlertTable(LibrarySession session,
                                    String tableName,
                                    String grantee)
                             throws IfsException

Create alert table for crawler instance, and grant all privileges to specified grantee.

Parameters:

session - the session context

tableName - the name of alert table to be created

grantee - the schema/user for whom to grant all privileges

Throws:

IfsException - if the operation fails

selectDirectoryGroups

public static DirectoryGroup[] selectDirectoryGroups(LibrarySession session,
                                                     long id)
                                              throws IfsException

Selects the set of DirectoryGroups affected by the specified Group member change

Parameters:

session - the session context

id - the ID of the Group where member change occurred

Returns:

array of DirectoryGroups

Throws:

IfsException - if the operation fails