Package com.ibm.fhir.persistence.jdbc.dao.impl

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

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 necessary
void	close()
abstract void	doCodeSystemsUpsert(String paramList, Collection<String> systemNames)	Insert any missing values into the code_systems table
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.
void	flush()	Execute any statements with pending batch entries
protected ICommonTokenValuesCache	getCache()	Getter for the ICommonTokenValuesCache held by this DAO
protected Connection	getConnection()	Getter for the Connection held by this DAO
ICommonTokenValuesCache	getResourceReferenceCache()	Get the cache used by the DAO
protected String	getSchemaName()	Getter for subclass access to the schemaName
protected IDatabaseTranslator	getTranslator()	Getter for the IDatabaseTranslator held by this DAO
protected 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 types
CommonTokenValueResult	readCommonTokenValueId(String codeSystem, String tokenValue)	Find the database id for the given token value and system
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

Methods inherited from class java.lang.Object

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

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 the IDatabaseTranslator held by this DAO

Returns:

getCache

protected ICommonTokenValuesCache getCache()

Getter for the ICommonTokenValuesCache held by this DAO

Returns:

getConnection

protected Connection getConnection()

Getter for the Connection 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 interface IResourceReferenceDAO

Throws:

FHIRPersistenceException

close

public void close()
           throws FHIRPersistenceException

Specified by:

close in interface AutoCloseable

Throws:

FHIRPersistenceException

getResourceReferenceCache

public ICommonTokenValuesCache getResourceReferenceCache()

Description copied from interface: IResourceReferenceDAO

Get the cache used by the DAO

Specified by:

getResourceReferenceCache in interface IResourceReferenceDAO

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 interface IResourceReferenceDAO

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 interface IResourceReferenceDAO

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 interface IResourceReferenceDAO