er.extensions.eof

Class ERXEOAccessUtilities

java.lang.Object

er.extensions.eof.ERXEOAccessUtilities

public class ERXEOAccessUtilities
extends Object

Collection of EOAccess related utilities. EOAccess provides the data access mechanisms for the Enterprise Objects technology.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	ERXEOAccessUtilities.AdaptorChannelOperation<T> Implemented by any adaptor channel operation that needs to run with an open adaptor channel.
static class	ERXEOAccessUtilities.ChannelAction Deals with the nitty-gritty of direct row manipulation by correctly opening, closing, locking and unlocking the needed EOF objects for direct row manipulation.
static interface	ERXEOAccessUtilities.DatabaseContextOperation<T> Implemented by any database operation that needs to run inside of a database context lock.

Field Summary

Fields

Modifier and Type	Field and Description
static org.apache.log4j.Logger	log logging support

Constructor Summary

Constructors

Constructor and Description
ERXEOAccessUtilities()

Method Summary

Modifier and Type	Method and Description
static NSArray<EOEntity>	allSubEntitiesForEntity(EOEntity rootEntity, boolean includeAbstracts) Utility method used to find all of the sub entities for a given entity.
static NSArray<EOProperty>	attributePathForKeyPath(EOEntity entity, String keyPath) Creates an array of relationships and attributes from the given keypath to give to the EOSQLExpression method sqlStringForAttributePath.
static EOAttribute	attributeWithColumnNameFromEntity(String columnName, EOEntity entity)
static void	batchFetchRelationship(EODatabaseContext databaseContext, EORelationship relationship, NSArray objects, EOEditingContext editingContext, boolean skipFaultedRelationships) Batch fetch a relationship, optionally skipping any relationship that has already faulted in its to-many relationship.
static void	batchFetchRelationship(EODatabaseContext databaseContext, String entityName, String relationshipName, NSArray objects, EOEditingContext editingContext, boolean skipFaultedRelationships) Batch fetch a relationship, optionally skipping any relationship that has already faulted in its to-many relationship.
static NSArray	classPropertiesNotInParent(EOEntity entity, boolean includeAttributes, boolean includeToOneRelationships, boolean includeToManyRelationships)
static boolean	closeDatabaseConnections(EOObjectStoreCoordinator osc) Closes the (JDBC) Connection from all database channels for the specified EOObjectStoreCoordinator
static EOAttribute	createAggregateAttribute(EOEditingContext ec, String function, String attributeName, String entityName) Creates an aggregate integer attribute for a given function name.
static EOAttribute	createAggregateAttribute(EOEditingContext ec, String function, String attributeName, String entityName, Class valueClass, String valueType) Creates an aggregate attribute for a given function name.
static EOAttribute	createAggregateAttribute(EOEditingContext ec, String function, String attributeName, String entityName, Class valueClass, String valueType, String aggregateName) Creates an aggregate attribute for a given function name.
static EOAttribute	createAggregateAttribute(EOEditingContext ec, String function, String attributeName, String entityName, Class valueClass, String valueType, String aggregateName, String entityTableAlias) Creates an aggregate attribute for a given function name.
static EOAttribute	createAggregateAttribute(EOEditingContext ec, String function, String attributeName, String entityName, Class valueClass, String valueType, String aggregateName, String entityTableAlias, boolean usesDistinct) Creates an aggregate attribute for a given function name.
static EORelationship	createFlattenedRelationship(String relationshipName, String sourceEntityName, String definition, int deleteRule, boolean isMandatory, boolean isClassProperty) Programatically adds a flattened relationship to an entity at runtime.
static String	createIndexSQLForEntities(NSArray entities) Deprecated.
static String	createIndexSQLForEntities(NSArray entities, NSArray externalTypesToIgnore) Deprecated.
static String	createIndexSQLForEntitiesForOracle(NSArray entities) Deprecated.
static String	createLogString(EOAdaptorChannel channel, EOSQLExpression expression, long millisecondsNeeded)
static EORelationship	createRelationship(String relationshipName, String sourceEntityName, String sourceAttributeName, String destinationEntityName, String destinationAttributeName, boolean toMany, int deleteRule, boolean isMandatory, boolean isClassProperty, boolean shouldPropagatePrimaryKey) Programatically adds a toOne or toMany relationship to an entity at runtime.
static String	createSchemaSQLForEntitiesInDatabaseContext(NSArray entities, EODatabaseContext databaseContext, boolean create, boolean drop) Deprecated.
static String	createSchemaSQLForEntitiesInModelWithName(NSArray entities, String modelName) Deprecated.
static String	createSchemaSQLForEntitiesInModelWithNameAndOptions(NSArray entities, String modelName, NSDictionary optionsCreate) Deprecated.
static String	createSchemaSQLForEntitiesInModelWithNameAndOptionsForOracle9(NSArray entities, String modelName, NSDictionary optionsCreate) Oracle 9 has a maximum length of 30 characters for table names, column names and constraint names.
static String	createSchemaSQLForEntitiesWithOptions(NSArray entities, EODatabaseContext databaseContext, NSDictionary optionsCreate) Deprecated.
static EODatabaseContext	databaseContextForEntityNamed(EOObjectStoreCoordinator osc, String entityName) Returns the database context for the given entity in the given EOObjectStoreCoordinator
static EODatabaseContext	databaseContextForObject(EOEnterpriseObject eo) Returns the database context for an EO.
static int	deleteRowsDescribedByQualifier(EOEditingContext ec, String entityName, EOQualifier qualifier) Deletes rows described by the qualifier.
static EOEntity	destinationEntityForKeyPath(EOEntity entity, String keyPath) Returns the last entity for the given key path.
static EOEntity	entityForEo(EOEnterpriseObject eo) Returns the EOEntity for the provided EOEnterpriseObject if one exists
static NSArray<EOEntity>	entityHierarchyForEntity(EOEditingContext ec, EOEntity rootEntity) Utility method used to find all of the non-abstract sub entities for a given entity including itself.
static NSArray<String>	entityHierarchyNamesForEntityNamed(EOEditingContext ec, String rootEntityName) Utility method used to find all of the non-abstract sub entity names for a given entity including itself.
static EOEntity	entityMatchingString(EOEditingContext ec, String string) Finds an entity that is contained in a string.
static EOEntity	entityNamed(EOEditingContext ec, String entityName) Similar to the helper in EOUtilities, but allows for null editingContext.
static boolean	entityUsesSeparateTable(EOEntity entity)
static EOEntity	entityUsingTable(EOEditingContext ec, String tableName) Finds an entity that is associated with the table name.
static boolean	entityWithNamedIsShared(EOEditingContext ec, String entityName) Method used to determine if a given entity is a shared entity.
static void	evaluateSQLWithEntity(EOEditingContext ec, EOEntity entity, String exp) Utility method used to execute arbitrary SQL.
static void	evaluateSQLWithEntityNamed(EOEditingContext ec, String entityName, String exp) Utility method used to execute arbitrary SQL.
static <T> T	executeAdaptorChannelOperation(EODatabaseContext databaseContext, int maxAttempts, ERXEOAccessUtilities.AdaptorChannelOperation<T> operation) Executes the given adaptor channel operation within a database context lock and with a requested open channel, retrying up to maxRetryCount times if the database connection dropped.
static <T> T	executeAdaptorChannelOperation(String modelName, int maxAttempts, ERXEOAccessUtilities.AdaptorChannelOperation<T> operation) Executes the given adaptor channel operation within a database context lock and with a requested open channel, retrying up to maxRetryCount times if the database connection dropped.
static <T> T	executeDatabaseContextOperation(EODatabaseContext databaseContext, int maxAttempts, ERXEOAccessUtilities.DatabaseContextOperation<T> operation) Executes the given database context operation within a database context lock, retrying up to maxRetryCount times if the database connection dropped.
static NSArray	externalNamesForEntity(EOEntity entity, boolean includeParentEntities)
static NSArray	externalNamesForEntityNamed(String entityName, boolean includeParentEntities)
static Number	getNextValFromSequenceNamed(EOEditingContext ec, String modelName, String sequenceName) Deprecated.
static String	guessPluginName(EOModel model) Tries to get the plugin name for a JDBC based model.
static String	guessPluginNameForConnectionDictionary(NSDictionary connectionDictionary) Tries to get the plugin name for a connection dictionary.
static int	insertRow(EOEditingContext ec, String entityName, NSDictionary newValues) Insert row described dictionary.
static int	insertRows(EOEditingContext ec, String entityName, Collection<? extends NSDictionary<String,?>> newValues) Insert rows described the array of dictionaries.
static boolean	isOptimisticLockingFailure(EOGeneralAdaptorException e) Returns true if the exception is an optimistic locking exception.
static boolean	isUniqueFailure(EOGeneralAdaptorException e) 例外エラーが重複エラーの場合は true を戻します。
static EORelationship	lastRelationship(EORelationship relationship) Crude hack to get at the end of a relationship path.
static EOFetchSpecification	localizeFetchSpecification(EOEditingContext ec, EOFetchSpecification fetchSpecification) Returns a new fetch spec by morphing sort orderings containing the keys foo.name returning foo.name_de where appropriate.
static void	logExpression(EOAdaptorChannel channel, EOSQLExpression expression, long startTime)
static void	makeEditableSharedEntityNamed(String entityName) Utility method to make a shared entity editable.
static EOModelGroup	modelGroup(EOEditingContext ec) Similar to the helper in EOUtilities, but allows for null editingContext.
static NSDictionary	primaryKeyDictionaryForEntity(EOEditingContext ec, String entityName) Utility method to generate a new primary key dictionary using the adaptor for a given entity.
static NSArray	primaryKeysForNewRows(EOEditingContext ec, String entityName, int count) Creates count new primary keys for the entity.
static NSArray	primaryKeysForObjects(NSArray<? extends EOEnterpriseObject> eos) Creates an array containing all of the primary keys of the given objects.
static EOQualifier	qualifierFromAttributes(NSArray<EOAttribute> attributes, NSDictionary values) Creates an AND qualifier of EOKeyValueQualifiers for every keypath in the given array of attributes.
static NSArray	rawRowsForSQLExpression(EOEditingContext ec, EOModel model, EOSQLExpression expression, NSArray<EOAttribute> attributes) Returns the raw rows for the given EOSQLExpression.
static NSArray<NSDictionary>	rawRowsForSQLExpression(EOEditingContext ec, String modelName, EOSQLExpression expression) Returns the raw rows for the given EOSQLExpression.
static void	reapplyChanges(EOEnterpriseObject eo, EOGeneralAdaptorException e) Method used to apply a set of changes to a re-fetched eo.
static EOEnterpriseObject	refetchFailedObject(EOEditingContext ec, EOGeneralAdaptorException e)
static NSArray<EORelationship>	relationshipsForAttribute(EOEntity entity, EOAttribute attrib) Filters a list of relationships for only the ones that have a given EOAttribute as a source attribute.
static EOEntity	rootEntityForEntity(EOEntity entity) Walks all of the parentEntity relationships to find the root entity.
static EOEntity	rootEntityForEntityNamed(String entityName) Walks all of the parentEntity relationships to find the root entity.
static int	rowCountForFetchSpecification(EOEditingContext ec, EOFetchSpecification spec) Returns the number of rows the supplied EOFetchSpecification would return.
static void	setIsAttributeUsedForLocking(EOAttribute attr, boolean isUsedForLocking) Add or remove an attribute from the entities list of attributes used for locking
static void	setIsClassProperty(EOProperty property, boolean isClassProperty) Add or remove a class property from its entity.
static void	setListener(IERXEOExecutionListener aListener)
static NSArray	snapshotsForObjectsFromRelationshipNamed(NSArray eos, String relKey) Given an array of EOs, returns snapshot dictionaries for the given related objects.
static EOAttribute	sourceAttributeForRelationship(EOEntity entity, String relationshipName) Returns the source attribute for the relationship named relationshipName on entity.
static EOAttribute	sourceAttributeForRelationship(EORelationship relationship) Returns the source attribute for the relationship.
static String	sourceColumnForRelationship(EOEntity entity, String relationshipName) Returns the external column name for the source attribute for the relationship named relationshipName on entity.
static String	sourceColumnForRelationship(EORelationship relationship) Returns the external column name for the source attribute for the relationship named relationshipName on entity.
static EOSQLExpression	sqlExpressionForFetchSpecification(EOEditingContext ec, EOFetchSpecification spec, long start, long end) Creates the SQL which is used by the provided EOFetchSpecification, limited by the given range.
static String	sqlForFetchSpecification(EOEditingContext ec, EOFetchSpecification spec) Creates the SQL which is used by the provides EOFetchSpecification.
static String	sqlWhereClauseStringForKey(EOSQLExpression e, String key, NSArray valueArray) Deprecated.
static int	updateRowsDescribedByQualifier(EOEditingContext ec, String entityName, EOQualifier qualifier, NSDictionary newValues) Updates rows described by the qualifier.
static NSSet	verifyAllSnapshots() In a multi-OSC or multi-instance scenario, when there are bugs, it is possible for the snapshots to become out of sync with the database.

Methods inherited from class java.lang.Object

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

Field Detail

log

public static final org.apache.log4j.Logger log

logging support

Constructor Detail

ERXEOAccessUtilities

public ERXEOAccessUtilities()

Method Detail

setListener

public static void setListener(IERXEOExecutionListener aListener)

entityMatchingString

public static EOEntity entityMatchingString(EOEditingContext ec,
                                            String string)

Finds an entity that is contained in a string. This is used a lot in DirectToWeb. Example: "ListAllStudios" => Studio

Parameters:

ec - editing context

string - string to look into

Returns:

found entity or null

entityUsingTable

public static EOEntity entityUsingTable(EOEditingContext ec,
                                        String tableName)

Finds an entity that is associated with the table name. When inheritance is used, will return the least derived entity using that table. This can be used to deal with database exceptions where you only have the table name to go on. As multiple entities can map to a single table, the results of this method are inexact.

Parameters:

ec - editing context

tableName - table (external) name to find an entity for

Returns:

found entity or null

entityWithNamedIsShared

public static boolean entityWithNamedIsShared(EOEditingContext ec,
                                              String entityName)

Method used to determine if a given entity is a shared entity.

Parameters:

ec - editing context

entityName - name of the entity

Returns:

if the entity is a shared entity

Throws:

IllegalStateException - if the entityName provided is null

getNextValFromSequenceNamed

@Deprecated
public static Number getNextValFromSequenceNamed(EOEditingContext ec,
                                                             String modelName,
                                                             String sequenceName)

Deprecated.

Convenience method to get the next unique ID from a sequence.

Parameters:

ec - editing context

modelName - name of the model which connects to the database that has the sequence in it

sequenceName - name of the sequence

Returns:

next value in the sequence

evaluateSQLWithEntityNamed

public static void evaluateSQLWithEntityNamed(EOEditingContext ec,
                                              String entityName,
                                              String exp)

Utility method used to execute arbitrary SQL. This has the advantage over the EOUtilities rawRowsForSQL in that it can be used with other statements besides just SELECT without throwing exceptions.

Parameters:

ec - editing context that determines which model group and database context to use.

entityName - name of an entity in the model connected to the database you wish to execute SQL against

exp - SQL expression

evaluateSQLWithEntity

public static void evaluateSQLWithEntity(EOEditingContext ec,
                                         EOEntity entity,
                                         String exp)

Utility method used to execute arbitrary SQL. This has the advantage over the EOUtilities rawRowsForSQL in that it can be used with other statements besides just SELECT without throwing exceptions.

Parameters:

ec - editing context that determines which model group and database context to use.

entity - an entity in the model connected to the database you wish to execute SQL against

exp - SQL expression

sqlForFetchSpecification

public static String sqlForFetchSpecification(EOEditingContext ec,
                                              EOFetchSpecification spec)

Creates the SQL which is used by the provides EOFetchSpecification.

Parameters:

ec - the EOEditingContext

spec - the EOFetchSpecification in question

Returns:

the SQL which the EOFetchSpecification would use

rawRowsForSQLExpression

public static NSArray<NSDictionary> rawRowsForSQLExpression(EOEditingContext ec,
                                                            String modelName,
                                                            EOSQLExpression expression)

Returns the raw rows for the given EOSQLExpression. When possible, you should use the variant of this method that requires you to pass in the array of EOAttributes you are fetching. If you do not pass in attributes, this will use channel.describeResults(), which can produce attributes that may not be able to be faulted back into EO's because of case mismatches.

Parameters:

ec - the EOEditingContext

modelName - the name of the model in question

expression - the EOSQLExpression in question

Returns:

array of dictionaries

rawRowsForSQLExpression

public static NSArray rawRowsForSQLExpression(EOEditingContext ec,
                                              EOModel model,
                                              EOSQLExpression expression,
                                              NSArray<EOAttribute> attributes)

Returns the raw rows for the given EOSQLExpression.

Parameters:

ec - the EOEditingContext

model - the model in question

expression - the EOSQLExpression to fetch with

attributes - the attributes to fetch

Returns:

array of dictionaries

sqlExpressionForFetchSpecification

public static EOSQLExpression sqlExpressionForFetchSpecification(EOEditingContext ec,
                                                                 EOFetchSpecification spec,
                                                                 long start,
                                                                 long end)

Creates the SQL which is used by the provided EOFetchSpecification, limited by the given range.

Parameters:

ec - the EOEditingContext

spec - the EOFetchSpecification in question

start - start of rows to fetch

end - end of rows to fetch (-1 if not used)

Returns:

the EOSQLExpression which the EOFetchSpecification would use

rowCountForFetchSpecification

public static int rowCountForFetchSpecification(EOEditingContext ec,
                                                EOFetchSpecification spec)

Returns the number of rows the supplied EOFetchSpecification would return.

Parameters:

ec - the EOEditingContext

spec - the EOFetchSpecification in question

Returns:

the number of rows

modelGroup

public static EOModelGroup modelGroup(EOEditingContext ec)

Similar to the helper in EOUtilities, but allows for null editingContext. If ec is null, it will try to get at the session via thread storage and use its defaultEditingContext. This is here now so we can remove the delegate in ERXApplication.

Parameters:

ec - editing context used to locate the model group (can be null)

Returns:

the model group associated with the editing context's root object store

entityNamed

public static EOEntity entityNamed(EOEditingContext ec,
                                   String entityName)

Similar to the helper in EOUtilities, but allows for null editingContext.

Parameters:

ec - editing context used to locate the model group (can be null)

entityName - entity name

Returns:

the entity with the specified name

createAggregateAttribute

public static EOAttribute createAggregateAttribute(EOEditingContext ec,
                                                   String function,
                                                   String attributeName,
                                                   String entityName)

Creates an aggregate integer attribute for a given function name. These can then be used to query on when using raw rows.

Parameters:

ec - editing context used to locate the model group

function - name of the function MAX, MIN, etc

attributeName - name of the attribute

entityName - name of the entity

Returns:

aggregate function attribute

createAggregateAttribute

public static EOAttribute createAggregateAttribute(EOEditingContext ec,
                                                   String function,
                                                   String attributeName,
                                                   String entityName,
                                                   Class valueClass,
                                                   String valueType)

Creates an aggregate attribute for a given function name. These can then be used to query on when using raw rows.

Parameters:

ec - editing context used to locate the model group

function - name of the function MAX, MIN, etc

attributeName - name of the attribute

entityName - name of the entity

valueClass - the java class of this attribute's values

valueType - the EOAttribute value type

Returns:

aggregate function attribute

createAggregateAttribute

public static EOAttribute createAggregateAttribute(EOEditingContext ec,
                                                   String function,
                                                   String attributeName,
                                                   String entityName,
                                                   Class valueClass,
                                                   String valueType,
                                                   String aggregateName)

Creates an aggregate attribute for a given function name. These can then be used to query on when using raw rows.

Parameters:

ec - editing context used to locate the model group

function - name of the function MAX, MIN, etc

attributeName - name of the attribute

entityName - name of the entity

aggregateName - the name to assign to the aggregate column in the query

valueClass - the java class of this attribute's values

valueType - the EOAttribute value type

Returns:

aggregate function attribute

createAggregateAttribute

public static EOAttribute createAggregateAttribute(EOEditingContext ec,
                                                   String function,
                                                   String attributeName,
                                                   String entityName,
                                                   Class valueClass,
                                                   String valueType,
                                                   String aggregateName,
                                                   String entityTableAlias)

Creates an aggregate attribute for a given function name. These can then be used to query on when using raw rows.

Parameters:

ec - editing context used to locate the model group

function - name of the function MAX, MIN, etc

attributeName - name of the attribute

entityName - name of the entity

aggregateName - the name to assign to the aggregate column in the query

valueClass - the java class of this attribute's values

valueType - the EOAttribute value type

entityTableAlias - the "t0"-style name of the attribute in this query (or null for "t0")

Returns:

aggregate function attribute

createAggregateAttribute

public static EOAttribute createAggregateAttribute(EOEditingContext ec,
                                                   String function,
                                                   String attributeName,
                                                   String entityName,
                                                   Class valueClass,
                                                   String valueType,
                                                   String aggregateName,
                                                   String entityTableAlias,
                                                   boolean usesDistinct)

Creates an aggregate attribute for a given function name. These can then be used to query on when using raw rows.

Parameters:

ec - editing context used to locate the model group

function - name of the function MAX, MIN, etc

attributeName - name of the attribute

entityName - name of the entity

aggregateName - the name to assign to the aggregate column in the query

valueClass - the java class of this attribute's values

valueType - the EOAttribute value type

entityTableAlias - the "t0"-style name of the attribute in this query (or null for "t0")

usesDistinct - true if function should be used on distinct values

Returns:

aggregate function attribute

createSchemaSQLForEntitiesInModelWithNameAndOptionsForOracle9

public static String createSchemaSQLForEntitiesInModelWithNameAndOptionsForOracle9(NSArray entities,
                                                                                   String modelName,
                                                                                   NSDictionary optionsCreate)

Oracle 9 has a maximum length of 30 characters for table names, column names and constraint names. Foreign key constraint names are defined like this from the plugin:

TABLENAME_FOEREIGNKEYNAME_FK

The whole statement looks like this:

ALTER TABLE [TABLENAME] ADD CONSTRAINT [CONSTRAINTNAME] FOREIGN KEY ([FK]) REFERENCES [DESTINATION_TABLE] ([PK]) DEFERRABLE INITIALLY DEFERRED

THIS means that the tablename and the columnname together cannot be longer than 26 characters.

This method checks each foreign key constraint name and if it is longer than 30 characters it is replaced with a unique name.

Parameters:

entities - a NSArray containing the entities for which create table statements should be generated or null if all entities in the model should be used.

modelName - the name of the EOModel

optionsCreate -

Returns:

a String containing SQL statements to create tables

See Also:

ERXSQLHelper.createSchemaSQLForEntitiesInModelWithNameAndOptions(NSArray, String, NSDictionary)

createSchemaSQLForEntitiesInModelWithNameAndOptions

@Deprecated
public static String createSchemaSQLForEntitiesInModelWithNameAndOptions(NSArray entities,
                                                                                     String modelName,
                                                                                     NSDictionary optionsCreate)

Deprecated.

Creates SQL to create tables for the specified Entities. This can be used with EOUtilities rawRowsForSQL method to create the tables.

Parameters:

entities - a NSArray containing the entities for which create table statements should be generated or null if all entities in the model should be used.

modelName - the name of the EOModel

optionsCreate - a NSDictionary containing the different options. Possible keys are

• EOSchemaGeneration.DropTablesKey
• EOSchemaGeneration.DropPrimaryKeySupportKey
• EOSchemaGeneration.CreateTablesKey
• EOSchemaGeneration.CreatePrimaryKeySupportKey
• EOSchemaGeneration.PrimaryKeyConstraintsKey
• EOSchemaGeneration.ForeignKeyConstraintsKey
• EOSchemaGeneration.CreateDatabaseKey
• EOSchemaGeneration.DropDatabaseKey

Possible values are YES and NO

Returns:

a String containing SQL statements to create tables

createSchemaSQLForEntitiesWithOptions

@Deprecated
public static String createSchemaSQLForEntitiesWithOptions(NSArray entities,
                                                                       EODatabaseContext databaseContext,
                                                                       NSDictionary optionsCreate)

Deprecated.

Creates the schema sql for a set of entities.

Parameters:

entities - the entities to create sql for

databaseContext - the database context to use

optionsCreate - the options (@see createSchemaSQLForEntitiesInModelWithNameAndOptions)

Returns:

a sql script

createSchemaSQLForEntitiesInModelWithName

@Deprecated
public static String createSchemaSQLForEntitiesInModelWithName(NSArray entities,
                                                                           String modelName)

Deprecated.

creates SQL to create tables for the specified Entities. This can be used with EOUtilities rawRowsForSQL method to create the tables.

Parameters:

entities - a NSArray containing the entities for which create table statements should be generated or null if all entities in the model should be used.

modelName - the name of the EOModel

This method uses the following defaults options:

• EOSchemaGeneration.DropTablesKey=YES
• EOSchemaGeneration.DropPrimaryKeySupportKey=YES
• EOSchemaGeneration.CreateTablesKey=YES
• EOSchemaGeneration.CreatePrimaryKeySupportKey=YES
• EOSchemaGeneration.PrimaryKeyConstraintsKey=YES
• EOSchemaGeneration.ForeignKeyConstraintsKey=YES
• EOSchemaGeneration.CreateDatabaseKey=NO
• EOSchemaGeneration.DropDatabaseKey=NO

Possible values are YES and NO

Returns:

a String containing SQL statements to create tables

createSchemaSQLForEntitiesInDatabaseContext

@Deprecated
public static String createSchemaSQLForEntitiesInDatabaseContext(NSArray entities,
                                                                             EODatabaseContext databaseContext,
                                                                             boolean create,
                                                                             boolean drop)

Deprecated.

creates SQL to create tables for the specified Entities. This can be used with EOUtilities rawRowsForSQL method to create the tables.

Parameters:

entities - a NSArray containing the entities for which create table statements should be generated or null if all entities in the model should be used.

databaseContext - the databaseContext

create - if true, tables and keys are created

drop - if true, tables and keys are dropped

Returns:

a String containing SQL statements to create tables

createIndexSQLForEntitiesForOracle

@Deprecated
public static String createIndexSQLForEntitiesForOracle(NSArray entities)

Deprecated.

createIndexSQLForEntities

@Deprecated
public static String createIndexSQLForEntities(NSArray entities)

Deprecated.

createIndexSQLForEntities

@Deprecated
public static String createIndexSQLForEntities(NSArray entities,
                                                           NSArray externalTypesToIgnore)

Deprecated.

entityUsesSeparateTable

public static boolean entityUsesSeparateTable(EOEntity entity)

attributeWithColumnNameFromEntity

public static EOAttribute attributeWithColumnNameFromEntity(String columnName,
                                                            EOEntity entity)

isOptimisticLockingFailure

public static boolean isOptimisticLockingFailure(EOGeneralAdaptorException e)

Returns true if the exception is an optimistic locking exception.

Parameters:

e - the exception as recieved from saveChanges()

Returns:

true if the error could be handled.

isUniqueFailure

public static boolean isUniqueFailure(EOGeneralAdaptorException e)

例外エラーが重複エラーの場合は true を戻します。

Parameters:

e - - saveChanges() から受けた例外エラーそのまま

Returns:

エラーが処理できた場合は true

snapshotsForObjectsFromRelationshipNamed

public static NSArray snapshotsForObjectsFromRelationshipNamed(NSArray eos,
                                                               String relKey)

Given an array of EOs, returns snapshot dictionaries for the given related objects.

primaryKeyDictionaryForEntity

public static NSDictionary primaryKeyDictionaryForEntity(EOEditingContext ec,
                                                         String entityName)

Utility method to generate a new primary key dictionary using the adaptor for a given entity. This is can be handy if you need to have a primary key for an object before it is saved to the database. This method uses the same method that EOF uses by default for generating primary keys. See ERXGeneratesPrimaryKeyInterfacefor more information about using a newly created dictionary as the primary key for an enterprise object.

Parameters:

ec - editing context

entityName - name of the entity to generate the primary key dictionary for.

Returns:

a dictionary containing a new primary key for the given entity.

primaryKeysForObjects

public static NSArray primaryKeysForObjects(NSArray<? extends EOEnterpriseObject> eos)

Creates an array containing all of the primary keys of the given objects.

Parameters:

eos - array of enterprise objects

Returns:

array of primary keys

lastRelationship

public static EORelationship lastRelationship(EORelationship relationship)

Crude hack to get at the end of a relationship path.

Parameters:

relationship -

attributePathForKeyPath

public static NSArray<EOProperty> attributePathForKeyPath(EOEntity entity,
                                                          String keyPath)

Creates an array of relationships and attributes from the given keypath to give to the EOSQLExpression method sqlStringForAttributePath. If the last element is a relationship, then the relationship's source attribute will get chosen. As such, this can only work for single-value relationships in the last element.

Parameters:

entity - base entity

keyPath - key path

Returns:

array of EOProperties that make up the given key path

sqlWhereClauseStringForKey

@Deprecated
public static String sqlWhereClauseStringForKey(EOSQLExpression e,
                                                            String key,
                                                            NSArray valueArray)

Deprecated.

Creates a where clause string " someKey IN ( someValue1,...)". Can migrate keyPaths.

databaseContextForObject

public static EODatabaseContext databaseContextForObject(EOEnterpriseObject eo)

Returns the database context for an EO.

Parameters:

eo - the EO to get a database context for

Returns:

the eo's database context

databaseContextForEntityNamed

public static EODatabaseContext databaseContextForEntityNamed(EOObjectStoreCoordinator osc,
                                                              String entityName)

Returns the database context for the given entity in the given EOObjectStoreCoordinator

Parameters:

entityName - entity name

osc - the object store coordinator

Returns:

database context

closeDatabaseConnections

public static boolean closeDatabaseConnections(EOObjectStoreCoordinator osc)

Closes the (JDBC) Connection from all database channels for the specified EOObjectStoreCoordinator

Parameters:

osc - the EOObjectStoreCoordinator from which the (JDBC)Connections should be closed

Returns:

true if all connections have been closed

destinationEntityForKeyPath

public static EOEntity destinationEntityForKeyPath(EOEntity entity,
                                                   String keyPath)

Returns the last entity for the given key path. If the path is empty or null, returns the given entity.

Parameters:

entity -

keyPath -

Returns:

entity object

entityForEo

public static EOEntity entityForEo(EOEnterpriseObject eo)

Returns the EOEntity for the provided EOEnterpriseObject if one exists

Parameters:

eo - the EOEnterpriseObject

Returns:

the EOEntity from the EOEnterpriseObject

classPropertiesNotInParent

public static NSArray classPropertiesNotInParent(EOEntity entity,
                                                 boolean includeAttributes,
                                                 boolean includeToOneRelationships,
                                                 boolean includeToManyRelationships)

externalNamesForEntity

public static NSArray externalNamesForEntity(EOEntity entity,
                                             boolean includeParentEntities)

externalNamesForEntityNamed

public static NSArray externalNamesForEntityNamed(String entityName,
                                                  boolean includeParentEntities)

rootEntityForEntity

public static EOEntity rootEntityForEntity(EOEntity entity)

Walks all of the parentEntity relationships to find the root entity.

Parameters:

entity - to find the root parent

Returns:

root parent entity

rootEntityForEntityNamed

public static EOEntity rootEntityForEntityNamed(String entityName)

Walks all of the parentEntity relationships to find the root entity.

Parameters:

entityName - to find the root parent

Returns:

root parent entity

logExpression

public static void logExpression(EOAdaptorChannel channel,
                                 EOSQLExpression expression,
                                 long startTime)

createLogString

public static String createLogString(EOAdaptorChannel channel,
                                     EOSQLExpression expression,
                                     long millisecondsNeeded)

qualifierFromAttributes

public static EOQualifier qualifierFromAttributes(NSArray<EOAttribute> attributes,
                                                  NSDictionary values)

Creates an AND qualifier of EOKeyValueQualifiers for every keypath in the given array of attributes.

Parameters:

attributes -

values -

Returns:

qualifier. EOAndQualifier for 2 or more elements in attributes, EOKeyValueQualifier for a single element attributes array, null when attributes is null or empty.

Author:

ak

relationshipsForAttribute

public static NSArray<EORelationship> relationshipsForAttribute(EOEntity entity,
                                                                EOAttribute attrib)

Filters a list of relationships for only the ones that have a given EOAttribute as a source attribute.

Parameters:

entity -

attrib - EOAttribute to filter source attributes of relationships.

Returns:

filtered array of EORelationship objects that have the given attribute as the source attribute.

sourceAttributeForRelationship

public static EOAttribute sourceAttributeForRelationship(EOEntity entity,
                                                         String relationshipName)

Returns the source attribute for the relationship named relationshipName on entity. Assumes there is only one join.

Parameters:

entity - EOEntity to find relationship on

relationshipName - name of relationship on entity

Returns:

source attribute for the relationship

sourceAttributeForRelationship

public static EOAttribute sourceAttributeForRelationship(EORelationship relationship)

Returns the source attribute for the relationship. Assumes there is only one join.

Parameters:

relationship - relationship on entity to return source attribute for

Returns:

source attribute for the relationship

sourceColumnForRelationship

public static String sourceColumnForRelationship(EOEntity entity,
                                                 String relationshipName)

Returns the external column name for the source attribute for the relationship named relationshipName on entity. Assumes there is only one join. This is intend to support the *RowsDescribedByQualifier methods when used with relationships.

Parameters:

entity - EOEntity to find relationship on

relationshipName - name of relationship on entity

Returns:

the external column name for the source attribute for the relationship

sourceColumnForRelationship

public static String sourceColumnForRelationship(EORelationship relationship)

Returns the external column name for the source attribute for the relationship named relationshipName on entity. Assumes there is only one join. This is intend to support the *RowsDescribedByQualifier methods when used with relationships.

Parameters:

relationship - relationship on entity to return the external column name for the source attribute for

Returns:

the external column name for the source attribute for the relationship

refetchFailedObject

public static EOEnterpriseObject refetchFailedObject(EOEditingContext ec,
                                                     EOGeneralAdaptorException e)

reapplyChanges

public static void reapplyChanges(EOEnterpriseObject eo,
                                  EOGeneralAdaptorException e)

Method used to apply a set of changes to a re-fetched eo. This method is used to re-apply changes to a given eo after it has been refetched.

Parameters:

eo - enterprise object to have the changes re-applied to.

e -

deleteRowsDescribedByQualifier

public static int deleteRowsDescribedByQualifier(EOEditingContext ec,
                                                 String entityName,
                                                 EOQualifier qualifier)

Deletes rows described by the qualifier. Note that the values and the qualifier need to be on an attribute and not on a relationship level. I.e. you need to give relationshipForeignKey = pk of object instead of relatedObject = object

Parameters:

ec -

entityName -

qualifier -

updateRowsDescribedByQualifier

public static int updateRowsDescribedByQualifier(EOEditingContext ec,
                                                 String entityName,
                                                 EOQualifier qualifier,
                                                 NSDictionary newValues)

Updates rows described by the qualifier. Note that the values and the qualifier need to be on an attribute and not on a relationship level. I.e. you need to give relationshipForeignKey = pk of object instead of relatedObject = object. The newValues dictionaries also holds foreign keys, not objects.

Parameters:

ec -

entityName -

qualifier -

newValues -

insertRow

public static int insertRow(EOEditingContext ec,
                            String entityName,
                            NSDictionary newValues)

Insert row described dictionary.

Parameters:

ec -

entityName -

newValues -

insertRows

public static int insertRows(EOEditingContext ec,
                             String entityName,
                             Collection<? extends NSDictionary<String,?>> newValues)

Insert rows described the array of dictionaries.

Parameters:

ec -

entityName -

newValues -

primaryKeysForNewRows

public static NSArray primaryKeysForNewRows(EOEditingContext ec,
                                            String entityName,
                                            int count)

Creates count new primary keys for the entity.

Parameters:

ec -

entityName -

count -

guessPluginName

public static String guessPluginName(EOModel model)

Tries to get the plugin name for a JDBC based model.

Parameters:

model - model name

Returns:

name of the JDBC plugin or null

guessPluginNameForConnectionDictionary

public static String guessPluginNameForConnectionDictionary(NSDictionary connectionDictionary)

Tries to get the plugin name for a connection dictionary.

Parameters:

connectionDictionary - the connectionDictionary to guess a plugin name for

Returns:

the plugin name

localizeFetchSpecification

public static EOFetchSpecification localizeFetchSpecification(EOEditingContext ec,
                                                              EOFetchSpecification fetchSpecification)

Returns a new fetch spec by morphing sort orderings containing the keys foo.name returning foo.name_de where appropriate.

Parameters:

ec -

fetchSpecification -

Returns:

localized fetch specification

batchFetchRelationship

public static void batchFetchRelationship(EODatabaseContext databaseContext,
                                          String entityName,
                                          String relationshipName,
                                          NSArray objects,
                                          EOEditingContext editingContext,
                                          boolean skipFaultedRelationships)

Batch fetch a relationship, optionally skipping any relationship that has already faulted in its to-many relationship.

Parameters:

databaseContext - the database context to fetch in

entityName - the name of the entity to fetch on

relationshipName - the name of the relationship in that entity to fetch

objects - the objects to fetch the relationship on

editingContext - the editingContext to fetch in

skipFaultedRelationships - if true, skip any object whose relationship has already been faulted

batchFetchRelationship

public static void batchFetchRelationship(EODatabaseContext databaseContext,
                                          EORelationship relationship,
                                          NSArray objects,
                                          EOEditingContext editingContext,
                                          boolean skipFaultedRelationships)

Batch fetch a relationship, optionally skipping any relationship that has already faulted in its to-many relationship.

Parameters:

databaseContext - the database context to fetch in

relationship - the relationship to fetch

objects - the objects to fetch the relationship on

editingContext - the editingContext to fetch in

skipFaultedRelationships - if true, skip any object whose relationship has already been faulted

verifyAllSnapshots

public static NSSet verifyAllSnapshots()

In a multi-OSC or multi-instance scenario, when there are bugs, it is possible for the snapshots to become out of sync with the database. It is useful to have some way to determine when exactly this condition occurs for writing test cases.

Returns:

a set of strings that describe the mismatches that occurred

makeEditableSharedEntityNamed

public static void makeEditableSharedEntityNamed(String entityName)

Utility method to make a shared entity editable. This can be useful if you want to have an administration application that can edit shared enterprise objects and need a way at start up to disable the sharing constraints.

Parameters:

entityName - name of the shared entity to make shareable.

createRelationship

public static EORelationship createRelationship(String relationshipName,
                                                String sourceEntityName,
                                                String sourceAttributeName,
                                                String destinationEntityName,
                                                String destinationAttributeName,
                                                boolean toMany,
                                                int deleteRule,
                                                boolean isMandatory,
                                                boolean isClassProperty,
                                                boolean shouldPropagatePrimaryKey)

Programatically adds a toOne or toMany relationship to an entity at runtime.

Parameters:

relationshipName - name of the relationship to be created on the source entity

sourceEntityName - name of the source entity

sourceAttributeName - name of the attribute in the source entity to be used by the join

destinationEntityName - name of the destination entity

destinationAttributeName - name of the attribute in the destination entity to be used by the join

toMany - if true, the relationship will be toMany, otherwise it will be toOne

deleteRule - EOClassDescription.DeleteRuleCascade || EOClassDescription.DeleteRuleDeny || EOClassDescription.DeleteRuleNoAction || EOClassDescription.DeleteRuleNullify

isMandatory - mandatory or not

isClassProperty - class property or not

shouldPropagatePrimaryKey - propagate primary key or not

Returns:

the newly created relationship

Author:

th

createFlattenedRelationship

public static EORelationship createFlattenedRelationship(String relationshipName,
                                                         String sourceEntityName,
                                                         String definition,
                                                         int deleteRule,
                                                         boolean isMandatory,
                                                         boolean isClassProperty)

Programatically adds a flattened relationship to an entity at runtime.

Parameters:

relationshipName - name of the relationship to be created on the source entity

sourceEntityName - name of the source entity

definition - data path of the relationship (e.g. department.facility)

deleteRule - EOClassDescription.DeleteRuleCascade || EOClassDescription.DeleteRuleDeny || EOClassDescription.DeleteRuleNoAction || EOClassDescription.DeleteRuleNullify

isMandatory - mandatory or not

isClassProperty - class property or not

Returns:

the newly created relationship

Author:

th

executeDatabaseContextOperation

public static <T> T executeDatabaseContextOperation(EODatabaseContext databaseContext,
                                                    int maxAttempts,
                                                    ERXEOAccessUtilities.DatabaseContextOperation<T> operation)

Executes the given database context operation within a database context lock, retrying up to maxRetryCount times if the database connection dropped.

Type Parameters:

T - the type of the results of this operation

Parameters:

databaseContext - the (possibly unlocked) database context to operate on

maxAttempts - the maximum number of times to reattempt the operation before failing

operation - the database context operation to perform

executeAdaptorChannelOperation

public static <T> T executeAdaptorChannelOperation(EODatabaseContext databaseContext,
                                                   int maxAttempts,
                                                   ERXEOAccessUtilities.AdaptorChannelOperation<T> operation)

Executes the given adaptor channel operation within a database context lock and with a requested open channel, retrying up to maxRetryCount times if the database connection dropped.

Type Parameters:

T - the type of the results of this operation

Parameters:

databaseContext - the (possibly unlocked) database context to operate on

maxAttempts - the maximum number of times to reattempt the operation before failing

operation - the adaptor channel operation to perform

executeAdaptorChannelOperation

public static <T> T executeAdaptorChannelOperation(String modelName,
                                                   int maxAttempts,
                                                   ERXEOAccessUtilities.AdaptorChannelOperation<T> operation)

Executes the given adaptor channel operation within a database context lock and with a requested open channel, retrying up to maxRetryCount times if the database connection dropped.

Type Parameters:

T - the type of the results of this operation

Parameters:

modelName - the name of the model to lookup a database context for

maxAttempts - the maximum number of times to reattempt the operation before failing

operation - the adaptor channel operation to perform

setIsClassProperty

public static void setIsClassProperty(EOProperty property,
                                      boolean isClassProperty)

Add or remove a class property from its entity.

Parameters:

property - The property to add or remove from the class properties array

isClassProperty - true adds the property to the list of class properties, false removes it.

setIsAttributeUsedForLocking

public static void setIsAttributeUsedForLocking(EOAttribute attr,
                                                boolean isUsedForLocking)

Add or remove an attribute from the entities list of attributes used for locking

Parameters:

attr - the attribute to add or remove

isUsedForLocking - true adds the attribute, false removes it

entityHierarchyNamesForEntityNamed

public static NSArray<String> entityHierarchyNamesForEntityNamed(EOEditingContext ec,
                                                                 String rootEntityName)

Utility method used to find all of the non-abstract sub entity names for a given entity including itself.

Parameters:

ec - editing context

rootEntityName - name of entity to walk all of the subEntities relationships

Returns:

a list of all concrete entity names that inherit from rootEntityName, including rootEntityName itself if it is concrete.

entityHierarchyForEntity

public static NSArray<EOEntity> entityHierarchyForEntity(EOEditingContext ec,
                                                         EOEntity rootEntity)

Utility method used to find all of the non-abstract sub entities for a given entity including itself.

Parameters:

ec - editing context

rootEntity - to walk all of the subEntities relationships

Returns:

a list of all concrete entities that inherit from rootEntity, including rootEntity itself if it is concrete.

allSubEntitiesForEntity

public static NSArray<EOEntity> allSubEntitiesForEntity(EOEntity rootEntity,
                                                        boolean includeAbstracts)

Utility method used to find all of the sub entities for a given entity.

Parameters:

rootEntity - to walk all of the subEntities relationships

includeAbstracts - determines if abstract entities should be included in the returned array

Returns:

all of the sub-entities for a given entity.