Package edu.internet2.middleware.grouper.sqlCache

Class SqlCacheGroupDao

java.lang.Object

edu.internet2.middleware.grouper.sqlCache.SqlCacheGroupDao

public class SqlCacheGroupDao
extends Object

dao for sql cache groups

Constructor Summary

Constructors

Constructor	Description
SqlCacheGroupDao()

Method Summary

Modifier and Type	Method	Description
static void	delete(SqlCacheGroup sqlCacheGroup)
static SqlCacheGroup	retrieveByGroupInternalIdFieldInternalId(long groupInternalId, long fieldInternalId, Connection connection)
static Map<MultiKey,SqlCacheGroup>	retrieveByGroupInternalIdsFieldInternalIds(Collection<MultiKey> groupInternalIdsFieldInternalIds)	select caches by group internal ids and field internal ids
static Map<MultiKey,SqlCacheGroup>	retrieveByGroupInternalIdsFieldInternalIds(Collection<MultiKey> groupInternalIdsFieldInternalIds, Connection connection)	select caches by group internal ids and field internal ids
static Map<MultiKey,SqlCacheGroup>	retrieveByGroupNamesFieldNames(Collection<MultiKey> groupNamesFieldNames)	select caches by group names and field names
static Map<MultiKey,Long>	retrieveByGroupNamesFieldNamesToInternalId(Collection<MultiKey> groupNamesFieldNames)	select caches by group names and field names
static SqlCacheGroup	retrieveByInternalId(Long id)	select grouper sync by id
static Map<MultiKey,SqlCacheGroup>	retrieveByOwnerIdsFieldNames(Collection<MultiKey> ownerIdsFieldNames, Connection connection)	select caches by owner ids and field names
static SqlCacheGroup	retrieveOrCreateBySqlGroupCache(SqlCacheGroup sqlCacheGroup)	retrieve cache group by group name field name or created
static Map<MultiKey,SqlCacheGroup>	retrieveOrCreateBySqlGroupCache(Collection<SqlCacheGroup> sqlCacheGroups)	retrieve cache group by group name field name or created
static boolean	store(SqlCacheGroup sqlCacheGroup)
static int	store(Collection<SqlCacheGroup> sqlCacheGroups)
static int	store(Collection<SqlCacheGroup> sqlCacheGroups, Connection connection, boolean isInsert)

Methods inherited from class java.lang.Object

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

Constructor Details

SqlCacheGroupDao

public SqlCacheGroupDao()

Method Details

store

public static boolean store(SqlCacheGroup sqlCacheGroup)

Parameters:

sqlCacheGroup -

Returns:

true if changed

store

public static int store(Collection<SqlCacheGroup> sqlCacheGroups)

Parameters:

sqlCacheGroups -

Returns:

number of changes

store

public static int store(Collection<SqlCacheGroup> sqlCacheGroups,
 Connection connection,
 boolean isInsert)

Parameters:

sqlCacheGroups -

connection - optionally pass connection to use

isInsert -

Returns:

number of changes

retrieveByInternalId

public static SqlCacheGroup retrieveByInternalId(Long id)

select grouper sync by id

Parameters:

theConnectionName -

id -

Returns:

the sync

delete

public static void delete(SqlCacheGroup sqlCacheGroup)

Parameters:

sqlCacheMembership -

retrieveByOwnerIdsFieldNames

public static Map<MultiKey,SqlCacheGroup> retrieveByOwnerIdsFieldNames(Collection<MultiKey> ownerIdsFieldNames,
 Connection connection)

select caches by owner ids and field names

Parameters:

ownerIdsFieldNames -

connection - optionally pass connection to use

Returns:

the caches if they exist by ownerId and fieldName

retrieveByGroupNamesFieldNames

public static Map<MultiKey,SqlCacheGroup> retrieveByGroupNamesFieldNames(Collection<MultiKey> groupNamesFieldNames)

select caches by group names and field names

Parameters:

groupNamesFieldNames -

Returns:

the caches if they exist by groupName and fieldName

retrieveByGroupNamesFieldNamesToInternalId

public static Map<MultiKey,Long> retrieveByGroupNamesFieldNamesToInternalId(Collection<MultiKey> groupNamesFieldNames)

select caches by group names and field names

Parameters:

groupNamesFieldNames -

Returns:

the caches if they exist by groupName and fieldName

retrieveByGroupInternalIdsFieldInternalIds

public static Map<MultiKey,SqlCacheGroup> retrieveByGroupInternalIdsFieldInternalIds(Collection<MultiKey> groupInternalIdsFieldInternalIds)

select caches by group internal ids and field internal ids

Parameters:

groupInternalIdsFieldInternalIds -

Returns:

the caches if they exist

retrieveByGroupInternalIdsFieldInternalIds

public static Map<MultiKey,SqlCacheGroup> retrieveByGroupInternalIdsFieldInternalIds(Collection<MultiKey> groupInternalIdsFieldInternalIds,
 Connection connection)

select caches by group internal ids and field internal ids

Parameters:

groupInternalIdsFieldInternalIds -

connection - optionally pass connection to use

Returns:

the caches if they exist

retrieveByGroupInternalIdFieldInternalId

public static SqlCacheGroup retrieveByGroupInternalIdFieldInternalId(long groupInternalId,
 long fieldInternalId,
 Connection connection)

Parameters:

groupInternalId -

fieldInternalId -

connection - optionally pass connection to use

Returns:

the cache if it exist

retrieveOrCreateBySqlGroupCache

public static SqlCacheGroup retrieveOrCreateBySqlGroupCache(SqlCacheGroup sqlCacheGroup)

retrieve cache group by group name field name or created

Parameters:

sqlCacheGroups -

retrieveOrCreateBySqlGroupCache

public static Map<MultiKey,SqlCacheGroup> retrieveOrCreateBySqlGroupCache(Collection<SqlCacheGroup> sqlCacheGroups)

retrieve cache group by group name field name or created

Parameters:

sqlCacheGroups -

Returns:

groupInternalId / fieldInternalId to sql cache group