Package edu.internet2.middleware.grouper.sqlCache

Class SqlCacheMembershipDao

java.lang.Object
edu.internet2.middleware.grouper.sqlCache.SqlCacheMembershipDao
public class SqlCacheMembershipDao extends Object
dao for sql cache memberships

  • Constructor Details

    • SqlCacheMembershipDao

      public SqlCacheMembershipDao()

  • Method Details

    • store

      public static boolean store(SqlCacheMembership sqlCacheMembership)
      Parameters:
      connectionName -
      Returns:
      true if changed

    • retrieveByInternalId

      public static SqlCacheMembership retrieveByInternalId(Long id)
      select grouper sync by id
      Parameters:
      theConnectionName -
      id -
      Returns:
      the sync

    • delete

      public static void delete(SqlCacheMembership sqlCacheMembership)
      Parameters:
      sqlCacheMembership -

    • insertSqlCacheMembershipsIfCacheable

      public static int insertSqlCacheMembershipsIfCacheable(Collection<MultiKey> groupNameFieldNameSourceIdSubjectIdStartedMillis)
      things to add to sql cache memberships. 5 fields in multikey: groupName, fieldName, sourceId, subjectId, millisSince1970whenMembershipStarted (Long)
      Parameters:
      groupNameFieldNameSourceIdSubjectIdStartedMillis -
      Returns:
      number of changes

    • insertSqlCacheMembershipsAsNeededFromSource

      public static int insertSqlCacheMembershipsAsNeededFromSource(Collection<MultiKey> groupNamesFieldNames)
      note the sql cache group record needs to be already inserted
      Parameters:
      groupNamesFieldNames -
      Returns:
      the number of inserts

    • deleteSqlCacheMembershipsIfCacheable

      public static int deleteSqlCacheMembershipsIfCacheable(Collection<MultiKey> groupNameFieldNameSourceIdSubjectIds)
      things to delete to sql cache memberships. 4 fields in multikey: groupName, fieldName, sourceId, subjectId
      Parameters:
      groupNameFieldNameSourceIdSubjectIdStartedMillis -
      Returns:
      number of changes

    • retrieveByGroupNamesFieldNamesSourceIdsSubjectIds

      public static Map<MultiKey,SqlCacheMembership> retrieveByGroupNamesFieldNamesSourceIdsSubjectIds(Collection<MultiKey> groupNamesFieldNamesSourceIdsSubjectIds)
      select caches by group names and field names and source ids and subject ids
      Parameters:
      groupNamesFieldNamesSourceIdsSubjectIds -
      Returns:
      the caches if they exist by groupName and fieldName and source ids and subject ids

    • store

      public static int store(Collection<SqlCacheMembership> sqlCacheMemberships)
      Parameters:
      connectionName -
      Returns:
      number of changes

    • retrieveByCacheGroupInternalIdsMemberInternalIds

      public static Map<MultiKey,SqlCacheMembership> retrieveByCacheGroupInternalIdsMemberInternalIds(Collection<MultiKey> cacheGroupInternalIdsMemberInternalIds)
      select caches by cache group internal ids and member internal ids
      Parameters:
      cacheGroupInternalIdsMemberInternalIds -
      Returns:
      the caches if they exist

    • retrieveOrCreateBySqlMembershipCache

      public static void retrieveOrCreateBySqlMembershipCache(Collection<SqlCacheMembership> sqlCacheMemberships)
      retrieve cache group by group name field name or created
      Parameters:
      sqlCacheMemberships -