Package edu.internet2.middleware.grouperClient.jdbc.tableSync

Class GcGrouperSyncMembershipDao

java.lang.Object
edu.internet2.middleware.grouperClient.jdbc.tableSync.GcGrouperSyncMembershipDao
public class GcGrouperSyncMembershipDao extends Object
membership dao

  • 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

      public int membershipDelete(GcGrouperSyncMembership gcGrouperSyncMembership, boolean deleteLogs)
      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 too
      deleteLogs - delete logs too
      Returns:
      the syncs

    • membershipRetrieveAll

      public List<GcGrouperSyncMembership> 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

      public GcGrouperSyncMembership membershipRetrieveById(String gcGrouperSyncMembershipId)
      select grouper sync membership by membership id
      Parameters:
      gcGrouperSyncMembershipId -
      Returns:
      the membership

    • internal_membershipCacheDeleteBySyncGroupId

      public void internal_membershipCacheDeleteBySyncGroupId(String syncGroupId)
      delete from cache by syncGroupId
      Parameters:
      syncGroupId -

    • internal_membershipCacheDeleteBySyncMemberId

      public void internal_membershipCacheDeleteBySyncMemberId(String syncMemberId)
      delete from cache by syncMemberId
      Parameters:
      syncMemberId -

    • membershipDeleteBySyncGroupIds

      public int membershipDeleteBySyncGroupIds(Collection<String> syncGroupIds, boolean deleteLogs)
      Parameters:
      syncGroupIds -
      Returns:
      number deleted

    • membershipDeleteBySyncMemberIds

      public int membershipDeleteBySyncMemberIds(Collection<String> syncMemberIds, boolean deleteLogs)
      Parameters:
      syncMemberIds -
      Returns:
      number deleted

    • membershipDeleteBySyncGroupId

      public int membershipDeleteBySyncGroupId(String syncGroupId, boolean deleteLogs)
      Parameters:
      syncGroupId -
      Returns:
      number deleted

    • membershipDeleteBySyncMemberId

      public int membershipDeleteBySyncMemberId(String syncMemberId, boolean deleteLogs)
      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

      public GcGrouperSyncLog membershipCreateLog(GcGrouperSyncMembership gcGrouperSyncMembership)
      Parameters:
      gcGrouperSyncMembershipId -
      Returns:
      log

    • internal_membershipCacheDelete

      public void internal_membershipCacheDelete(GcGrouperSyncMembership gcGrouperSyncMembership)
      Parameters:
      gcGrouperSyncMembership -

    • internal_membershipRetrieveFromDbAll

      public List<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

      public int internal_membershipRetrieveFromDbCountByGroupSyncId(String syncGroupId)
      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

      public GcGrouperSync getGcGrouperSync()
      Returns:

    • setGcGrouperSync

      public void setGcGrouperSync(GcGrouperSync gcGrouperSync)
      Parameters:
      gcGrouperSync -

    • internal_membershipStoreAll

      public int internal_membershipStoreAll()
      Returns:
      number of memberships stored

    • internal_membershipStore

      public int internal_membershipStore(Collection<GcGrouperSyncMembership> gcGrouperSyncMemberships)
      store batch, generally call this from store all objects from GcGrouperSync
      Parameters:
      gcGrouperSyncMemberships -
      Returns:
      number of changes

    • internal_membershipStore

      public void internal_membershipStore(GcGrouperSyncMembership gcGrouperSyncMembership)
      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

      public Map<String,Integer> retrieveErrorCountByCode()
      get count of rows per error code
      Returns: