Class GcGrouperSyncMembershipDao
java.lang.Object
edu.internet2.middleware.grouperClient.jdbc.tableSync.GcGrouperSyncMembershipDao
membership dao
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionvoid
internal_membershipCacheDelete
(GcGrouperSyncMembership gcGrouperSyncMembership) void
internal_membershipCacheDeleteBySyncGroupId
(String syncGroupId) delete from cache by syncGroupIdvoid
internal_membershipCacheDeleteBySyncMemberId
(String syncMemberId) delete from cache by syncMemberIdinternal_membershipCreateBySyncGroupIdAndSyncMemberIdHelper
(String syncGroupId, String syncMemberId) create grouper sync membership.internal_membershipRetrieveFromCacheById
(String gcGrouperSyncMembershipId) select grouper sync membership by membership idselect grouper sync membership by sync id and membership idinternal_membershipRetrieveFromDbById
(String gcGrouperSyncMembershipId) select grouper sync membership by gcGrouperSyncMembershipId idinternal_membershipRetrieveFromDbByIds
(Collection<String> syncMembershipIdsCollection) select grouper sync membership by sync id and membership idinternal_membershipRetrieveFromDbBySyncGroupIdAndSyncMemberId
(String syncGroupId, String syncMemberId) select grouper sync membership by membership idinternal_membershipRetrieveFromDbBySyncGroupIds
(Collection<String> syncGroupIds) select grouper sync membership by group sync idsinternal_membershipRetrieveFromDbBySyncGroupIdsAndSyncMemberIds
(String grouperSyncId, Collection<MultiKey> syncGroupIdsAndSyncMemberIds) select grouper sync membership by sync id and membership idinternal_membershipRetrieveFromDbBySyncMemberIds
(Collection<String> syncMemberIds) select grouper sync membership by member sync idsint
select count of memberships for the given sync group idvoid
internal_membershipStore
(GcGrouperSyncMembership gcGrouperSyncMembership) store batch, generally call this from store all objects from GcGrouperSyncint
internal_membershipStore
(Collection<GcGrouperSyncMembership> gcGrouperSyncMemberships) store batch, generally call this from store all objects from GcGrouperSyncint
membershipCreateByGroupAndMember
(GcGrouperSyncGroup gcGrouperSyncGroup, GcGrouperSyncMember gcGrouperSyncMember) select grouper sync membership by group id and member id.membershipCreateBySyncGroupIdAndSyncMemberId
(String syncGroupId, String syncMemberId) select grouper sync membership by group id and member id.membershipCreateLog
(GcGrouperSyncMembership gcGrouperSyncMembership) int
membershipDelete
(GcGrouperSyncMembership gcGrouperSyncMembership, boolean deleteLogs) delete sync membershipint
membershipDelete
(Collection<GcGrouperSyncMembership> gcGrouperSyncMemberships, boolean deleteLogs) delete batchint
membershipDeleteAll
(boolean deleteLogs) delete all memberships for a syncint
membershipDeleteBySyncGroupId
(String syncGroupId, boolean deleteLogs) int
membershipDeleteBySyncGroupIds
(Collection<String> syncGroupIds, boolean deleteLogs) int
membershipDeleteBySyncMemberId
(String syncMemberId, boolean deleteLogs) int
membershipDeleteBySyncMemberIds
(Collection<String> syncMemberIds, boolean deleteLogs) select grouper sync membership by sync id and membership idmembershipRetrieveByGroupIdAndMemberId
(String groupId, String memberId) select grouper sync membership by group uuid and member uuid, note this assumes the syncGroup and syncMember existmembershipRetrieveByGroupIds
(Set<String> groupIdsToRetrieveMemberships) membershipRetrieveByGroupIdsAndMemberIds
(String grouperSyncId, Collection<MultiKey> groupIdsAndMemberIds) select grouper syncs membership by group uuids and member uuids, note this assumes the syncGroup and syncMember existmembershipRetrieveByGroupIdsAndMemberIds
(Collection<MultiKey> groupIdsAndMemberIds) Deprecated.membershipRetrieveByGroupIdsMap
(Set<String> groupIdsToRetrieveMemberships) retrieve membershipsmembershipRetrieveById
(String gcGrouperSyncMembershipId) select grouper sync membership by membership idmembershipRetrieveByMemberIds
(Set<String> memberIdsToRetrieveMemberships) membershipRetrieveByMemberIdsMap
(Set<String> memberIdsToRetrieveMemberships) retrieve membershipsmembershipRetrieveBySyncGroupIdAndSyncMemberId
(String syncGroupId, String syncMemberId) select grouper sync membership by membership idmembershipRetrieveBySyncGroupIdsAndSyncMemberIds
(String grouperSyncId, Collection<MultiKey> syncGroupIdsAndSyncMemberIds) select grouper sync membership by sync id and membership idmembershipRetrieveBySyncGroupIdsAndSyncMemberIds
(Collection<MultiKey> syncGroupIdsAndSyncMemberIds) Deprecated.membershipRetrieveOrCreateByGroupIdAndMemberId
(String groupId, String memberId) select or create grouper sync membership by group uuid and member uuid, note this assumes the syncGroup and syncMember have been retrieved and are in cache.membershipRetrieveOrCreateByGroupIdsAndMemberIds
(String grouperSyncId, Collection<MultiKey> groupIdsAndMemberIds) select or create grouper sync membership by group uuid and member uuid, note this assumes the syncGroup and syncMember have been retrieved and are in cache.membershipRetrieveOrCreateByGroupIdsAndMemberIds
(Collection<MultiKey> groupIdsAndMemberIds) Deprecated.membershipRetrieveOrCreateBySyncGroupIdAndSyncMemberId
(String syncGroupId, String syncMemberId) select grouper sync membership by membership id.membershipRetrieveOrCreateBySyncGroupIdsAndSyncMemberIds
(String grouperSyncId, Collection<MultiKey> syncGroupIdsAndSyncMemberIdsCollection) select grouper sync membership by membership id.membershipRetrieveOrCreateBySyncGroupIdsAndSyncMemberIds
(Collection<MultiKey> syncGroupIdsAndSyncMemberIdsCollection) Deprecated.get count of rows per error coderetrieveGroupIdMemberIdsWithErrorsAfterMillis
(Timestamp errorTimestampCheckFrom) get membership ids with errors after error timestampvoid
setGcGrouperSync
(GcGrouperSync gcGrouperSync)
-
Constructor Details
-
GcGrouperSyncMembershipDao
public GcGrouperSyncMembershipDao()
-
-
Method Details
-
membershipCreateByGroupAndMember
public GcGrouperSyncMembership membershipCreateByGroupAndMember(GcGrouperSyncGroup gcGrouperSyncGroup, GcGrouperSyncMember gcGrouperSyncMember) select grouper sync membership by group id and member id. Note: this doesnt store to db yet, you do that at the end- Parameters:
connectionName
-membershipId
-- Returns:
- the membership
-
internal_membershipCreateBySyncGroupIdAndSyncMemberIdHelper
public GcGrouperSyncMembership internal_membershipCreateBySyncGroupIdAndSyncMemberIdHelper(String syncGroupId, String syncMemberId) create grouper sync membership. Note: this doesnt store to db yet, you do that at the end- Parameters:
connectionName
-groupId
-- Returns:
- the group
-
membershipCreateBySyncGroupIdAndSyncMemberId
public GcGrouperSyncMembership membershipCreateBySyncGroupIdAndSyncMemberId(String syncGroupId, String syncMemberId) select grouper sync membership by group id and member id. Note: this doesnt store to db yet, you do that at the end- Parameters:
connectionName
-membershipId
-- Returns:
- the membership
-
membershipDelete
public int membershipDelete(Collection<GcGrouperSyncMembership> gcGrouperSyncMemberships, boolean deleteLogs) delete batch- Parameters:
gcGrouperSyncMemberships
-- Returns:
- rows deleted (memberships and logs)
-
membershipDelete
delete sync membership- Parameters:
gcGrouperSyncMembership
-- Returns:
- rows deleted (memberships and logs)
-
membershipDeleteAll
public int membershipDeleteAll(boolean deleteLogs) delete all memberships for a sync- Parameters:
deleteMemberships
- true if delete memberships and logs for memberships toodeleteLogs
- delete logs too- Returns:
- the syncs
-
membershipRetrieveAll
select grouper sync membership by sync id and membership id- Parameters:
grouperSyncId
-provisionerName
-- Returns:
- the syncs
-
membershipRetrieveBySyncGroupIdAndSyncMemberId
public GcGrouperSyncMembership membershipRetrieveBySyncGroupIdAndSyncMemberId(String syncGroupId, String syncMemberId) select grouper sync membership by membership id- Parameters:
connectionName
-membershipId
-- Returns:
- the membership
-
membershipRetrieveByGroupIdAndMemberId
public GcGrouperSyncMembership membershipRetrieveByGroupIdAndMemberId(String groupId, String memberId) select grouper sync membership by group uuid and member uuid, note this assumes the syncGroup and syncMember exist- Parameters:
groupId
-memberId
-- Returns:
- the membership
-
membershipRetrieveOrCreateByGroupIdsAndMemberIds
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveOrCreateByGroupIdsAndMemberIds(Collection<MultiKey> groupIdsAndMemberIds) Deprecated.select or create grouper sync membership by group uuid and member uuid, note this assumes the syncGroup and syncMember have been retrieved and are in cache. if they arent there this is an error. create the groups and members before the membership!- Parameters:
groupIdsAndMemberIds
-- Returns:
- the membership
-
membershipRetrieveOrCreateByGroupIdsAndMemberIds
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveOrCreateByGroupIdsAndMemberIds(String grouperSyncId, Collection<MultiKey> groupIdsAndMemberIds) select or create grouper sync membership by group uuid and member uuid, note this assumes the syncGroup and syncMember have been retrieved and are in cache. if they arent there this is an error. create the groups and members before the membership!- Parameters:
grouperSyncId
-groupIdsAndMemberIds
-- Returns:
- the membership
-
membershipRetrieveOrCreateByGroupIdAndMemberId
public GcGrouperSyncMembership membershipRetrieveOrCreateByGroupIdAndMemberId(String groupId, String memberId) select or create grouper sync membership by group uuid and member uuid, note this assumes the syncGroup and syncMember have been retrieved and are in cache. if they arent there this is an error. create the groups and members before the membership!- Parameters:
groupId
-memberId
-- Returns:
- the membership
-
membershipRetrieveBySyncGroupIdsAndSyncMemberIds
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveBySyncGroupIdsAndSyncMemberIds(Collection<MultiKey> syncGroupIdsAndSyncMemberIds) Deprecated.select grouper sync membership by sync id and membership id- Parameters:
syncGroupIdsAndSyncMemberIds
-- Returns:
- the membershipId to syncMembership map
-
membershipRetrieveBySyncGroupIdsAndSyncMemberIds
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveBySyncGroupIdsAndSyncMemberIds(String grouperSyncId, Collection<MultiKey> syncGroupIdsAndSyncMemberIds) select grouper sync membership by sync id and membership id- Parameters:
syncGroupIdsAndSyncMemberIds
-- Returns:
- the membershipId to syncMembership map
-
internal_membershipRetrieveFromCacheById
public GcGrouperSyncMembership internal_membershipRetrieveFromCacheById(String gcGrouperSyncMembershipId) select grouper sync membership by membership id- Parameters:
gcGrouperSyncMembershipId
-- Returns:
- the membership
-
membershipRetrieveById
select grouper sync membership by membership id- Parameters:
gcGrouperSyncMembershipId
-- Returns:
- the membership
-
internal_membershipCacheDeleteBySyncGroupId
delete from cache by syncGroupId- Parameters:
syncGroupId
-
-
internal_membershipCacheDeleteBySyncMemberId
delete from cache by syncMemberId- Parameters:
syncMemberId
-
-
membershipDeleteBySyncGroupIds
- Parameters:
syncGroupIds
-- Returns:
- number deleted
-
membershipDeleteBySyncMemberIds
- Parameters:
syncMemberIds
-- Returns:
- number deleted
-
membershipDeleteBySyncGroupId
- Parameters:
syncGroupId
-- Returns:
- number deleted
-
membershipDeleteBySyncMemberId
- Parameters:
syncMemberId
-- Returns:
- number deleted
-
membershipRetrieveOrCreateBySyncGroupIdsAndSyncMemberIds
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveOrCreateBySyncGroupIdsAndSyncMemberIds(Collection<MultiKey> syncGroupIdsAndSyncMemberIdsCollection) Deprecated.select grouper sync membership by membership id. note, this does not store the memberships to the database, do that later- Parameters:
syncGroupIdsAndSyncMemberIdsCollection
-- Returns:
- the membershipId to syncMembership map
-
membershipRetrieveOrCreateBySyncGroupIdsAndSyncMemberIds
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveOrCreateBySyncGroupIdsAndSyncMemberIds(String grouperSyncId, Collection<MultiKey> syncGroupIdsAndSyncMemberIdsCollection) select grouper sync membership by membership id. note, this does not store the memberships to the database, do that later- Parameters:
grouperSyncId
-syncGroupIdsAndSyncMemberIdsCollection
-- Returns:
- the membershipId to syncMembership map
-
membershipCreateLog
- Parameters:
gcGrouperSyncMembershipId
-- Returns:
- log
-
internal_membershipCacheDelete
- Parameters:
gcGrouperSyncMembership
-
-
internal_membershipRetrieveFromDbAll
select grouper sync membership by sync id and membership id- Parameters:
grouperSyncId
-provisionerName
-- Returns:
- the syncs
-
internal_membershipRetrieveFromDbBySyncGroupIdAndSyncMemberId
public GcGrouperSyncMembership internal_membershipRetrieveFromDbBySyncGroupIdAndSyncMemberId(String syncGroupId, String syncMemberId) select grouper sync membership by membership id- Parameters:
connectionName
-syncGroupId
-syncMemberId
-- Returns:
- the membership
-
internal_membershipRetrieveFromDbBySyncGroupIdsAndSyncMemberIds
public Map<MultiKey,GcGrouperSyncMembership> internal_membershipRetrieveFromDbBySyncGroupIdsAndSyncMemberIds(String grouperSyncId, Collection<MultiKey> syncGroupIdsAndSyncMemberIds) select grouper sync membership by sync id and membership id- Parameters:
grouperSyncId
-grouperMembershipIdsCollection
-provisionerName
-- Returns:
- the membershipId to syncMembership map
-
internal_membershipRetrieveFromDbBySyncGroupIds
public List<GcGrouperSyncMembership> internal_membershipRetrieveFromDbBySyncGroupIds(Collection<String> syncGroupIds) select grouper sync membership by group sync ids- Parameters:
syncGroupIds
-- Returns:
- the syncMemberships
-
internal_membershipRetrieveFromDbCountByGroupSyncId
select count of memberships for the given sync group id- Parameters:
syncGroupId
-- Returns:
- the count of memberships for the given sync group id
-
internal_membershipRetrieveFromDbBySyncMemberIds
public List<GcGrouperSyncMembership> internal_membershipRetrieveFromDbBySyncMemberIds(Collection<String> syncMemberIds) select grouper sync membership by member sync ids- Parameters:
syncMemberIds
-- Returns:
- the syncMemberships
-
internal_membershipRetrieveFromDbById
public GcGrouperSyncMembership internal_membershipRetrieveFromDbById(String gcGrouperSyncMembershipId) select grouper sync membership by gcGrouperSyncMembershipId id- Parameters:
gcGrouperSyncMembershipId
-- Returns:
- the gcGrouperSyncMembership
-
internal_membershipRetrieveFromDbByIds
public Map<String,GcGrouperSyncMembership> internal_membershipRetrieveFromDbByIds(Collection<String> syncMembershipIdsCollection) select grouper sync membership by sync id and membership id- Parameters:
grouperSyncId
-syncMembershipIdsCollection
-provisionerName
-- Returns:
- the id to syncMembership map
-
getGcGrouperSync
- Returns:
-
setGcGrouperSync
- Parameters:
gcGrouperSync
-
-
internal_membershipStoreAll
public int internal_membershipStoreAll()- Returns:
- number of memberships stored
-
internal_membershipStore
store batch, generally call this from store all objects from GcGrouperSync- Parameters:
gcGrouperSyncMemberships
-- Returns:
- number of changes
-
internal_membershipStore
store batch, generally call this from store all objects from GcGrouperSync- Parameters:
gcGrouperSyncMemberships
-
-
membershipRetrieveOrCreateBySyncGroupIdAndSyncMemberId
public GcGrouperSyncMembership membershipRetrieveOrCreateBySyncGroupIdAndSyncMemberId(String syncGroupId, String syncMemberId) select grouper sync membership by membership id. Note: this doesnt store to db yet, you do that at the end- Parameters:
connectionName
-syncGroupId
-syncMemberId
-- Returns:
- the membership
-
membershipRetrieveByGroupIdsAndMemberIds
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveByGroupIdsAndMemberIds(Collection<MultiKey> groupIdsAndMemberIds) Deprecated.select grouper syncs membership by group uuids and member uuids, note this assumes the syncGroup and syncMember exist- Parameters:
groupIdsAndMemberIds
-- Returns:
- the membership
-
membershipRetrieveByGroupIdsAndMemberIds
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveByGroupIdsAndMemberIds(String grouperSyncId, Collection<MultiKey> groupIdsAndMemberIds) select grouper syncs membership by group uuids and member uuids, note this assumes the syncGroup and syncMember exist- Parameters:
grouperSyncId
-groupIdsAndMemberIds
-- Returns:
- the membership
-
membershipRetrieveByGroupIds
public List<GcGrouperSyncMembership> membershipRetrieveByGroupIds(Set<String> groupIdsToRetrieveMemberships) -
membershipRetrieveByGroupIdsMap
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveByGroupIdsMap(Set<String> groupIdsToRetrieveMemberships) retrieve memberships- Parameters:
groupIdsToRetrieveMemberships
-- Returns:
- groupIdMemberId to gc sync membership
-
membershipRetrieveByMemberIdsMap
public Map<MultiKey,GcGrouperSyncMembership> membershipRetrieveByMemberIdsMap(Set<String> memberIdsToRetrieveMemberships) retrieve memberships- Parameters:
memberIdsToRetrieveMemberships
-- Returns:
- groupIdMemberId to gc sync membership
-
membershipRetrieveByMemberIds
public List<GcGrouperSyncMembership> membershipRetrieveByMemberIds(Set<String> memberIdsToRetrieveMemberships) -
retrieveGroupIdMemberIdsWithErrorsAfterMillis
public List<Object[]> retrieveGroupIdMemberIdsWithErrorsAfterMillis(Timestamp errorTimestampCheckFrom) get membership ids with errors after error timestamp- Parameters:
errorTimestampCheckFrom
- if null get all- Returns:
- group ids and member ids
-
retrieveErrorCountByCode
get count of rows per error code- Returns:
-