com.edorasware.commons.core.persistence

Class PersistenceUtils

java.lang.Object

com.edorasware.commons.core.persistence.PersistenceUtils

public class PersistenceUtils
extends Object

Provides utility methods related to persistence operations.

Method Summary

Modifier and Type	Method and Description
static SqlMappingContext	createSqlMappingContext(List<org.springframework.core.io.Resource> resources, DatabaseType databaseType, EntityResolver entityResolver) Reads the specified XML resources into a SqlMappingContext.
static SqlMappingContext	createSqlMappingContext(String[] fileNames, DatabaseType databaseType, EntityResolver entityResolver) Reads the specified XML file resources into a SqlMappingContext.
static List<String>	extractParameterNames(String sql) Extracts the parameter names from the given sql statement.
static com.google.common.collect.ImmutableMap<String,Integer>	extractParameterSqlTypes(String sql) Extracts the sql type information for each named parameter from the given sql statement.
static <T extends ComponentEntity> com.google.common.collect.ImmutableMap<String,Set<T>>	mapByForeignKey(Collection<T> components) Separates the given component entities by their source reference.
static String	removeParameterSqlTypes(String sql) Removes the sql type information from the given sql statement.
static String	replaceParameterName(String sql, String parameterName, String newParameterName) Replaces the given parameter name with a new parameter name in the given sql statement.

Methods inherited from class java.lang.Object

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

Method Detail

createSqlMappingContext

public static SqlMappingContext createSqlMappingContext(String[] fileNames,
                                                        DatabaseType databaseType,
                                                        EntityResolver entityResolver)
                                                 throws Exception

Reads the specified XML file resources into a SqlMappingContext.

Parameters:

fileNames - the XML file resources to be read

databaseType - the type of database for which to read the mappings

entityResolver - the resolver used to locate XML entities

Returns:

the context encapsulating the loaded mappings

Throws:

Exception - thrown in case something goes wrong during the XML loading/parsing process

createSqlMappingContext

public static SqlMappingContext createSqlMappingContext(List<org.springframework.core.io.Resource> resources,
                                                        DatabaseType databaseType,
                                                        EntityResolver entityResolver)
                                                 throws Exception

Reads the specified XML resources into a SqlMappingContext.

Parameters:

resources - the XML resources to be read

databaseType - the type of database for which to read the mappings

entityResolver - the resolver used to locate XML entities

Returns:

the context encapsulating the loaded mappings

Throws:

Exception - thrown in case something goes wrong during the XML loading/parsing process

replaceParameterName

public static String replaceParameterName(String sql,
                                          String parameterName,
                                          String newParameterName)

Replaces the given parameter name with a new parameter name in the given sql statement. <p> A named parameter and its sql type are defined as :<name>{<TYPE>}, e.g. :id{VARCHAR}.

Parameters:

sql - the sql statement to process

parameterName - the parameter name to replace

newParameterName - the new parameter name

Returns:

the substituted sql statement

extractParameterNames

public static List<String> extractParameterNames(String sql)

Extracts the parameter names from the given sql statement. <p> A named parameter and its sql type are defined as :<name>{<TYPE>}, e.g. :id{VARCHAR}.

Parameters:

sql - the sql statement to process

Returns:

the name of each parameter

extractParameterSqlTypes

public static com.google.common.collect.ImmutableMap<String,Integer> extractParameterSqlTypes(String sql)

Extracts the sql type information for each named parameter from the given sql statement. <p> A named parameter and its sql type are defined as :<name>{<TYPE>}, e.g. :id{VARCHAR}.

Parameters:

sql - the sql statement to process

Returns:

the sql type for each named parameter

removeParameterSqlTypes

public static String removeParameterSqlTypes(String sql)

Removes the sql type information from the given sql statement. <p> A named parameter and its sql type are defined as :<name>{<TYPE>}, e.g. :id{VARCHAR}.

Parameters:

sql - the sql statement to process

Returns:

the sql statement without any sql type information

mapByForeignKey

public static <T extends ComponentEntity> com.google.common.collect.ImmutableMap<String,Set<T>> mapByForeignKey(Collection<T> components)

Separates the given component entities by their source reference.

Type Parameters:

T - component entity

Parameters:

components - the component entities to separate

Returns:

the component entities separated by their source reference