Package org.openiam.common.authmanager.jdbc.impl

Class JdbcMembershipDAO

java.lang.Object

org.springframework.dao.support.DaoSupport

org.springframework.jdbc.core.support.JdbcDaoSupport

org.openiam.common.authmanager.jdbc.impl.AbstractJDBCDao

org.openiam.common.authmanager.jdbc.impl.JdbcMembershipDAO

All Implemented Interfaces:

MembershipDAO, org.springframework.beans.factory.InitializingBean

@Repository("jdbcMembershipDAO")
public class JdbcMembershipDAO
extends AbstractJDBCDao
implements MembershipDAO

Field Summary

Fields inherited from class org.openiam.common.authmanager.jdbc.impl.AbstractJDBCDao

schemaName

Fields inherited from class org.springframework.dao.support.DaoSupport

logger

Constructor Summary

Constructors

Constructor	Description
JdbcMembershipDAO()

Method Summary

Modifier and Type	Method	Description
List<MembershipRightDTO>	getEntitlementRightsStateForResources()
List<MembershipRightDTO>	getEntitlementRightsStateForUsers()
List<MembershipDTO>	getEntitlementStateForResources(Date date)
List<MembershipDTO>	getEntitlementStateForUser(String userId, Date date)
List<MembershipDTO>	getEntitlementStateForUsers(Date date)
List<AuthorizationGroup>	getGroups()
List<LanguageMapping>	getLanguageMappings(Collection<String> ids, String referenceType)
List<AuthorizationOrganization>	getOrganizations()
List<AuthorizationResource>	getPublicResources()
List<AuthorizationResource>	getResources()
List<AuthorizationRole>	getRoles()
InternalAuthorizationUser	getUser(String id, Date date)	Gets the current user's entitlements based on the id and date.
List<AuthorizationUser>	getUsers()
List<AuthorizationUser>	getUsersNotInsertedIntoGraph()
protected void	initSqlStatements()

Methods inherited from class org.openiam.common.authmanager.jdbc.impl.AbstractJDBCDao

getSchemaName, initDataSource

Methods inherited from class org.springframework.jdbc.core.support.JdbcDaoSupport

checkDaoConfig, createJdbcTemplate, getConnection, getDataSource, getExceptionTranslator, getJdbcTemplate, initTemplateConfig, releaseConnection, setDataSource, setJdbcTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet, initDao

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcMembershipDAO

public JdbcMembershipDAO()

Method Detail

initSqlStatements

protected void initSqlStatements()

Specified by:

initSqlStatements in class AbstractJDBCDao

getEntitlementRightsStateForUsers

public List<MembershipRightDTO> getEntitlementRightsStateForUsers()

Specified by:

getEntitlementRightsStateForUsers in interface MembershipDAO

getEntitlementRightsStateForResources

public List<MembershipRightDTO> getEntitlementRightsStateForResources()

Specified by:

getEntitlementRightsStateForResources in interface MembershipDAO

getEntitlementStateForUser

public List<MembershipDTO> getEntitlementStateForUser(String userId,
                                                      Date date)

Specified by:

getEntitlementStateForUser in interface MembershipDAO

getEntitlementStateForUsers

public List<MembershipDTO> getEntitlementStateForUsers(Date date)

Specified by:

getEntitlementStateForUsers in interface MembershipDAO

getEntitlementStateForResources

public List<MembershipDTO> getEntitlementStateForResources(Date date)

Specified by:

getEntitlementStateForResources in interface MembershipDAO

getOrganizations

public List<AuthorizationOrganization> getOrganizations()

Specified by:

getOrganizations in interface MembershipDAO

getGroups

public List<AuthorizationGroup> getGroups()

Specified by:

getGroups in interface MembershipDAO

getRoles

public List<AuthorizationRole> getRoles()

Specified by:

getRoles in interface MembershipDAO

getResources

public List<AuthorizationResource> getResources()

Specified by:

getResources in interface MembershipDAO

getPublicResources

public List<AuthorizationResource> getPublicResources()

Specified by:

getPublicResources in interface MembershipDAO

getUsers

public List<AuthorizationUser> getUsers()

Specified by:

getUsers in interface MembershipDAO

getUser

public InternalAuthorizationUser getUser(String id,
                                         Date date)

Gets the current user's entitlements based on the id and date. Note that the 'date' filtering is *not* done on the database level, as that requires a full table scan on 4 different results sets (as this is a Union) When doing this query on Bechtel, the COST (via EXPLAIN) with the data filtering was over 70000, while the COST without was only ~500.

Specified by:

getUser in interface MembershipDAO

getLanguageMappings

public List<LanguageMapping> getLanguageMappings(Collection<String> ids,
                                                 String referenceType)

Specified by:

getLanguageMappings in interface MembershipDAO

getUsersNotInsertedIntoGraph

public List<AuthorizationUser> getUsersNotInsertedIntoGraph()

Specified by:

getUsersNotInsertedIntoGraph in interface MembershipDAO