Class ResourceReferenceDAO
- java.lang.Object
-
- com.ibm.fhir.persistence.jdbc.dao.impl.ResourceReferenceDAO
-
- All Implemented Interfaces:
IResourceReferenceDAO
,AutoCloseable
- Direct Known Subclasses:
Db2ResourceReferenceDAO
,DerbyResourceReferenceDAO
,PostgresResourceReferenceDAO
public abstract class ResourceReferenceDAO extends Object implements IResourceReferenceDAO, AutoCloseable
DAO to handle maintenance of the local and external reference tables which contain the relationships described by "reference" elements in each resource (e.g. Observation.subject). The DAO uses a cache for looking up the ids for various entities. The DAO can create new entries, but these can only be used locally until the transaction commits, at which point they can be consolidated into the shared cache. This has the benefit that we reduce the number of times we need to lock the global cache, because we only update it once per transaction. For improved performance, we also make use of batch statements which are managed as member variables. This is why it's important to close this DAO before the transaction commits, ensuring that any outstanding DML batched but not yet executed is processed. Calling close does not close the provided Connection. That is up to the caller to manage. Close does close any statements which are opened inside the class.
-
-
Field Summary
Fields Modifier and Type Field Description protected static int
BATCH_SIZE
-
Constructor Summary
Constructors Constructor Description ResourceReferenceDAO(IDatabaseTranslator t, Connection c, String schemaName, ICommonTokenValuesCache cache)
Public constructor
-
Method Summary
All Methods Instance Methods Abstract Methods Concrete Methods Modifier and Type Method Description void
addCommonTokenValues(String resourceType, Collection<ResourceTokenValueRec> xrefs)
Add TOKEN_VALUE_MAP records, creating any CODE_SYSTEMS and COMMON_TOKEN_VALUES as necessaryvoid
close()
abstract void
doCodeSystemsUpsert(String paramList, Collection<String> systemNames)
Insert any missing values into the code_systems tableprotected abstract void
doCommonTokenValuesUpsert(String paramList, Collection<CommonTokenValue> tokenValues)
Execute the insert (upsert) into the common_token_values table for the given collection of values.void
flush()
Execute any statements with pending batch entriesprotected ICommonTokenValuesCache
getCache()
Getter for theICommonTokenValuesCache
held by this DAOprotected Connection
getConnection()
Getter for theConnection
held by this DAOICommonTokenValuesCache
getResourceReferenceCache()
Get the cache used by the DAOprotected String
getSchemaName()
Getter for subclass access to the schemaNameprotected IDatabaseTranslator
getTranslator()
Getter for theIDatabaseTranslator
held by this DAOprotected void
insertResourceTokenRefs(String resourceType, Collection<ResourceTokenValueRec> xrefs)
Insert the values in the resource-type-specific _resource_token_refs table.void
persist(Collection<ResourceTokenValueRec> records)
Persist the records, which may span multiple resource typesCommonTokenValueResult
readCommonTokenValueId(String codeSystem, String tokenValue)
Find the database id for the given token value and systemList<Long>
readCommonTokenValueIdList(String tokenValue)
Fetch the list of matching common_token_value_id records for the given tokenValue.void
upsertCodeSystems(List<ResourceTokenValueRec> systems)
Add all the systems we currently don't have in the database.void
upsertCommonTokenValues(List<ResourceTokenValueRec> values)
Add reference value records for each unique reference name in the given list
-
-
-
Field Detail
-
BATCH_SIZE
protected static final int BATCH_SIZE
- See Also:
- Constant Field Values
-
-
Constructor Detail
-
ResourceReferenceDAO
public ResourceReferenceDAO(IDatabaseTranslator t, Connection c, String schemaName, ICommonTokenValuesCache cache)
Public constructor- Parameters:
c
-
-
-
Method Detail
-
getTranslator
protected IDatabaseTranslator getTranslator()
Getter for theIDatabaseTranslator
held by this DAO- Returns:
-
getCache
protected ICommonTokenValuesCache getCache()
Getter for theICommonTokenValuesCache
held by this DAO- Returns:
-
getConnection
protected Connection getConnection()
Getter for theConnection
held by this DAO- Returns:
-
getSchemaName
protected String getSchemaName()
Getter for subclass access to the schemaName- Returns:
-
flush
public void flush() throws FHIRPersistenceException
Description copied from interface:IResourceReferenceDAO
Execute any statements with pending batch entries- Specified by:
flush
in interfaceIResourceReferenceDAO
- Throws:
FHIRPersistenceException
-
close
public void close() throws FHIRPersistenceException
- Specified by:
close
in interfaceAutoCloseable
- Throws:
FHIRPersistenceException
-
getResourceReferenceCache
public ICommonTokenValuesCache getResourceReferenceCache()
Description copied from interface:IResourceReferenceDAO
Get the cache used by the DAO- Specified by:
getResourceReferenceCache
in interfaceIResourceReferenceDAO
- Returns:
-
readCommonTokenValueId
public CommonTokenValueResult readCommonTokenValueId(String codeSystem, String tokenValue)
Description copied from interface:IResourceReferenceDAO
Find the database id for the given token value and system- Specified by:
readCommonTokenValueId
in interfaceIResourceReferenceDAO
- Returns:
- the matching id from common_token_values.common_token_value_id or null if not found
-
addCommonTokenValues
public void addCommonTokenValues(String resourceType, Collection<ResourceTokenValueRec> xrefs)
Description copied from interface:IResourceReferenceDAO
Add TOKEN_VALUE_MAP records, creating any CODE_SYSTEMS and COMMON_TOKEN_VALUES as necessary- Specified by:
addCommonTokenValues
in interfaceIResourceReferenceDAO
-
insertResourceTokenRefs
protected void insertResourceTokenRefs(String resourceType, Collection<ResourceTokenValueRec> xrefs)
Insert the values in the resource-type-specific _resource_token_refs table. This is a simple batch insert because all the FKs have already been resolved and updated in the ResourceTokenValueRec records- Parameters:
resourceType
-xrefs
-
-
upsertCodeSystems
public void upsertCodeSystems(List<ResourceTokenValueRec> systems)
Add all the systems we currently don't have in the database. If all target databases handled MERGE properly this would be easy, but they don't so we go old-school with a negative outer join instead (which is pretty much what MERGE does behind the scenes anyway).- Parameters:
systems
-
-
doCodeSystemsUpsert
public abstract void doCodeSystemsUpsert(String paramList, Collection<String> systemNames)
Insert any missing values into the code_systems table- Parameters:
paramList
-systems
-
-
upsertCommonTokenValues
public void upsertCommonTokenValues(List<ResourceTokenValueRec> values)
Add reference value records for each unique reference name in the given list- Parameters:
values
-
-
doCommonTokenValuesUpsert
protected abstract void doCommonTokenValuesUpsert(String paramList, Collection<CommonTokenValue> tokenValues)
Execute the insert (upsert) into the common_token_values table for the given collection of values. Note, this insert from negative outer join requires the database concurrency implementation to be correct. This does not work for Postgres, hence Postgres gets its own implementation of this method- Parameters:
paramList
-tokenValues
-
-
persist
public void persist(Collection<ResourceTokenValueRec> records)
Description copied from interface:IResourceReferenceDAO
Persist the records, which may span multiple resource types- Specified by:
persist
in interfaceIResourceReferenceDAO
-
readCommonTokenValueIdList
public List<Long> readCommonTokenValueIdList(String tokenValue)
Description copied from interface:IResourceReferenceDAO
Fetch the list of matching common_token_value_id records for the given tokenValue.- Specified by:
readCommonTokenValueIdList
in interfaceIResourceReferenceDAO
- Returns:
-
-