org.lexevs.dao.database.ibatis.valuesets
Class IbatisPickListDao

java.lang.Object
  extended by org.lexevs.dao.database.access.AbstractBaseDao
      extended by org.lexevs.dao.database.ibatis.AbstractIbatisDao
          extended by org.lexevs.dao.database.ibatis.valuesets.IbatisPickListDao
All Implemented Interfaces:
LexGridSchemaVersionAwareDao, PickListDao, org.springframework.beans.factory.InitializingBean

public class IbatisPickListDao
extends AbstractIbatisDao
implements PickListDao

The Class IbatisPickListDao.

Author:
Kevin Peterson

Nested Class Summary
 
Nested classes/interfaces inherited from interface org.lexevs.dao.database.access.LexGridSchemaVersionAwareDao
LexGridSchemaVersionAwareDao.IndividualDaoCallback<T>
 
Field Summary
static java.lang.String DELETE_CONTEXT_BY_PARENT_GUID_AND_TYPE_SQL
           
static java.lang.String DELETE_PICKLIST_ENTRY_CONTEXT_BY_PICKLIST_GUID_SQL
           
static java.lang.String DELETE_SOURCE_BY_PARENT_GUID_AND_TYPE_SQL
           
static java.lang.String DELETE_URIMAPS_BY_REFERENCE_GUID_SQL
           
static java.lang.String GET_CONTEXT_LIST_BY_PARENT_GUID_AND_TYPE_SQL
           
static java.lang.String GET_CONTEXT_LIST_FROM_HISTORY_BY_PARENT_ENTRYSTATEGUID_AND_TYPE_SQL
           
static java.lang.String GET_PICKLIST_DEFINITION_BY_PICKLISTID_SQL
          The GE t_ picklis t_ definitio n_ b y_ picklisti d_ sql.
static java.lang.String GET_PICKLIST_DEFINITION_ID_FOR_ENTITYCODE_ENTITYCODENAMESPACE_PROPERTYID_SQL
           
static java.lang.String GET_PICKLIST_DEFINITION_ID_FOR_ENTITYCODE_ENTITYCODENAMESPACE_SQL
           
static java.lang.String GET_PICKLIST_DEFINITION_ID_FOR_VALUESET_DEFINITION_URI_SQL
           
static java.lang.String GET_PICKLIST_DEFINITION_METADATA_BY_PICKLISTID_SQL
           
static java.lang.String GET_PICKLIST_ENTRYNODE_BEAN_BY_PICKLIST_GUID_SQL
           
static java.lang.String GET_PICKLIST_ENTRYNODEGUID_BY_PICKLISTID_AND_PLENTRYID_SQL
           
static java.lang.String GET_PICKLIST_GUID_BY_PICKLISTID_SQL
          The GE t_ picklis t_ gui d_ b y_ picklisti d_ sql.
static java.lang.String GET_PICKLIST_IDS_SQL
          The GE t_ picklis t_ id s_ sql.
static java.lang.String GET_PICKLISTID_FOR_SUPPORTED_TAG_AND_VALUE_SQL
           
static java.lang.String GET_SOURCE_LIST_BY_PARENT_GUID_AND_TYPE_SQL
           
static java.lang.String GET_SOURCE_LIST_FROM_HISTORY_BY_PARENT_ENTRYSTATEGUID_AND_TYPE_SQL
           
static java.lang.String GET_URIMAPS_BY_REFERENCE_GUID_LOCALNAME_AND_TYPE_SQL
           
static java.lang.String GET_URIMAPS_BY_REFERENCE_GUID_SQL
           
static java.lang.String INSERT_MULTI_ATTRIB_SQL
           
static java.lang.String INSERT_PICKLIST_DEFINITION_SQL
          The INSER t_ picklis t_ definitio n_ sql.
static java.lang.String INSERT_URIMAPS_SQL
           
static java.lang.String PICKLIST_ENTRYNODE_NAMESPACE
           
static java.lang.String PICKLIST_NAMESPACE
          The PICKLIS t_ namespace.
static java.lang.String REMOVE_PICKLIST_DEFINITION_BY_PICKLISTID_SQL
           
static java.lang.String REMOVE_PICKLIST_ENTRY_BY_PICKLISTGUID_SQL
           
static java.lang.String UPDATE_URIMAPS_BY_LOCALID_SQL
           
static java.lang.String VS_MAPPING_NAMESPACE
           
static java.lang.String VS_MULTIATTRIB_NAMESPACE
           
 
Fields inherited from class org.lexevs.dao.database.ibatis.AbstractIbatisDao
VERSIONS_NAMESPACE, VSENTRYSTATE_NAMESPACE
 
Constructor Summary
IbatisPickListDao()
           
 
Method Summary
protected  InsertOrUpdateURIMapBean buildInsertOrUpdateURIMapBean(java.lang.String prefix, java.lang.String uriMapId, java.lang.String referenceGuid, java.lang.String supportedAttributeTag, URIMap uriMap)
          Builds the insert uri map bean.
 void deletePickListDefinitionMappings(java.lang.String referenceGuid)
           
 java.util.List<LexGridSchemaVersion> doGetSupportedLgSchemaVersions()
          Do get supported lg schema versions.
 boolean entryStateExists(java.lang.String entryStateUId)
           
 java.lang.String getLatestRevision(java.lang.String pickListDefUId)
           
 PickListDefinition getPickListDefinitionById(java.lang.String pickListId)
          Gets the pick list definition by id.
 java.util.List<java.lang.String> getPickListDefinitionIdForEntityReference(java.lang.String entityCode, java.lang.String entityCodeNameSpace, java.lang.String propertyId)
           
 java.util.List<java.lang.String> getPickListDefinitionIdForSupportedTagAndValue(java.lang.String supportedTag, java.lang.String value)
          Returns all the pickListIds that contain supplied supported tag and value.
 java.util.List<java.lang.String> getPickListDefinitionIdForValueSetDefinitionURI(java.lang.String valueSetDefURI)
          Gets the list of pick list definitions that are derived by supplied value set definition URI.
 PickListEntryNodeDao getPickListEntryNodeDao()
           
 java.lang.String getPickListEntryNodeGuidByPickListIdAndPLEntryId(java.lang.String pickListDefinitionId, java.lang.String plEntryId)
          Returns the plEntryGUID for pickListId and pickListEntryId.
 java.lang.String getPickListEntryStateUId(java.lang.String pickListDefUId)
           
 java.lang.String getPickListGuidFromPickListId(java.lang.String pickListId)
          Gets the guid from pick list id.
 java.util.List<java.lang.String> getPickListIds()
          Gets the pick list ids.
protected  java.lang.String getPrefix()
          Gets the prefix.
 VersionsDao getVersionsDao()
          Gets the versions dao.
 VSEntryStateDao getVsEntryStateDao()
           
 VSPropertyDao getVsPropertyDao()
           
 java.lang.String insertHistoryPickListDefinition(java.lang.String pickListDefUId, java.lang.String pickListId)
           
 void insertMappings(java.lang.String referenceGuid, Mappings mappings)
           
 java.lang.String insertPickListDefinition(PickListDefinition definition, java.lang.String systemReleaseUri, Mappings mappings)
          Insert pick list definition.
 void insertURIMap(java.lang.String referenceGuid, java.util.List<URIMap> urimapList)
           
 void insertURIMap(java.lang.String referenceGuid, URIMap uriMap)
           
 void removePickListDefinitionByPickListId(java.lang.String pickListDefinitionId)
          Delete pick list definition by pick list id.
 PickListDefinition resolvePickListByRevision(java.lang.String pickListId, java.lang.String revisionId, java.lang.Integer sortType)
           
 void setPickListEntryNodeDao(PickListEntryNodeDao pickListEntryNodeDao)
           
 void setVersionsDao(VersionsDao versionsDao)
          Sets the versions dao.
 void setVsEntryStateDao(VSEntryStateDao vsEntryStateDao)
           
 void setVsPropertyDao(VSPropertyDao vsPropertyDao)
           
 void updateEntryStateUId(java.lang.String pickListDefUId, java.lang.String entryStateUId)
           
 java.lang.String updatePickListDefinition(java.lang.String pickListDefUId, PickListDefinition definition)
           
 java.lang.String updateVersionableAttributes(java.lang.String pickListDefUId, PickListDefinition definition)
           
 
Methods inherited from class org.lexevs.dao.database.ibatis.AbstractIbatisDao
afterPropertiesSet, entryStateExists, executeInTransaction, getBatchTemplateInserter, getNonBatchTemplateInserter, getSqlMapClientTemplate, setNonBatchTemplateInserter, setSqlMapClientTemplate, vsEntryStateExists
 
Methods inherited from class org.lexevs.dao.database.access.AbstractBaseDao
createRandomIdentifier, createUniqueId, getPrefixResolver, getPrimaryKeyIncrementer, setPrefixResolver, setPrimaryKeyIncrementer, supportsLgSchemaVersion
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface org.lexevs.dao.database.access.LexGridSchemaVersionAwareDao
executeInTransaction, supportsLgSchemaVersion
 

Field Detail

PICKLIST_NAMESPACE

public static java.lang.String PICKLIST_NAMESPACE
The PICKLIS t_ namespace.


PICKLIST_ENTRYNODE_NAMESPACE

public static java.lang.String PICKLIST_ENTRYNODE_NAMESPACE

VS_MULTIATTRIB_NAMESPACE

public static java.lang.String VS_MULTIATTRIB_NAMESPACE

VS_MAPPING_NAMESPACE

public static java.lang.String VS_MAPPING_NAMESPACE

INSERT_PICKLIST_DEFINITION_SQL

public static java.lang.String INSERT_PICKLIST_DEFINITION_SQL
The INSER t_ picklis t_ definitio n_ sql.


GET_PICKLIST_IDS_SQL

public static java.lang.String GET_PICKLIST_IDS_SQL
The GE t_ picklis t_ id s_ sql.


GET_PICKLIST_GUID_BY_PICKLISTID_SQL

public static java.lang.String GET_PICKLIST_GUID_BY_PICKLISTID_SQL
The GE t_ picklis t_ gui d_ b y_ picklisti d_ sql.


GET_PICKLIST_ENTRYNODEGUID_BY_PICKLISTID_AND_PLENTRYID_SQL

public static java.lang.String GET_PICKLIST_ENTRYNODEGUID_BY_PICKLISTID_AND_PLENTRYID_SQL

GET_PICKLIST_DEFINITION_BY_PICKLISTID_SQL

public static java.lang.String GET_PICKLIST_DEFINITION_BY_PICKLISTID_SQL
The GE t_ picklis t_ definitio n_ b y_ picklisti d_ sql.


GET_PICKLIST_DEFINITION_METADATA_BY_PICKLISTID_SQL

public static java.lang.String GET_PICKLIST_DEFINITION_METADATA_BY_PICKLISTID_SQL

GET_PICKLIST_DEFINITION_ID_FOR_VALUESET_DEFINITION_URI_SQL

public static java.lang.String GET_PICKLIST_DEFINITION_ID_FOR_VALUESET_DEFINITION_URI_SQL

GET_PICKLIST_ENTRYNODE_BEAN_BY_PICKLIST_GUID_SQL

public static java.lang.String GET_PICKLIST_ENTRYNODE_BEAN_BY_PICKLIST_GUID_SQL

GET_PICKLIST_DEFINITION_ID_FOR_ENTITYCODE_ENTITYCODENAMESPACE_SQL

public static java.lang.String GET_PICKLIST_DEFINITION_ID_FOR_ENTITYCODE_ENTITYCODENAMESPACE_SQL

GET_PICKLIST_DEFINITION_ID_FOR_ENTITYCODE_ENTITYCODENAMESPACE_PROPERTYID_SQL

public static java.lang.String GET_PICKLIST_DEFINITION_ID_FOR_ENTITYCODE_ENTITYCODENAMESPACE_PROPERTYID_SQL

REMOVE_PICKLIST_DEFINITION_BY_PICKLISTID_SQL

public static java.lang.String REMOVE_PICKLIST_DEFINITION_BY_PICKLISTID_SQL

REMOVE_PICKLIST_ENTRY_BY_PICKLISTGUID_SQL

public static java.lang.String REMOVE_PICKLIST_ENTRY_BY_PICKLISTGUID_SQL

GET_SOURCE_LIST_BY_PARENT_GUID_AND_TYPE_SQL

public static java.lang.String GET_SOURCE_LIST_BY_PARENT_GUID_AND_TYPE_SQL

GET_SOURCE_LIST_FROM_HISTORY_BY_PARENT_ENTRYSTATEGUID_AND_TYPE_SQL

public static java.lang.String GET_SOURCE_LIST_FROM_HISTORY_BY_PARENT_ENTRYSTATEGUID_AND_TYPE_SQL

GET_CONTEXT_LIST_BY_PARENT_GUID_AND_TYPE_SQL

public static java.lang.String GET_CONTEXT_LIST_BY_PARENT_GUID_AND_TYPE_SQL

GET_CONTEXT_LIST_FROM_HISTORY_BY_PARENT_ENTRYSTATEGUID_AND_TYPE_SQL

public static java.lang.String GET_CONTEXT_LIST_FROM_HISTORY_BY_PARENT_ENTRYSTATEGUID_AND_TYPE_SQL

INSERT_MULTI_ATTRIB_SQL

public static java.lang.String INSERT_MULTI_ATTRIB_SQL

DELETE_SOURCE_BY_PARENT_GUID_AND_TYPE_SQL

public static java.lang.String DELETE_SOURCE_BY_PARENT_GUID_AND_TYPE_SQL

DELETE_CONTEXT_BY_PARENT_GUID_AND_TYPE_SQL

public static java.lang.String DELETE_CONTEXT_BY_PARENT_GUID_AND_TYPE_SQL

DELETE_PICKLIST_ENTRY_CONTEXT_BY_PICKLIST_GUID_SQL

public static java.lang.String DELETE_PICKLIST_ENTRY_CONTEXT_BY_PICKLIST_GUID_SQL

GET_URIMAPS_BY_REFERENCE_GUID_SQL

public static java.lang.String GET_URIMAPS_BY_REFERENCE_GUID_SQL

GET_URIMAPS_BY_REFERENCE_GUID_LOCALNAME_AND_TYPE_SQL

public static java.lang.String GET_URIMAPS_BY_REFERENCE_GUID_LOCALNAME_AND_TYPE_SQL

GET_PICKLISTID_FOR_SUPPORTED_TAG_AND_VALUE_SQL

public static java.lang.String GET_PICKLISTID_FOR_SUPPORTED_TAG_AND_VALUE_SQL

INSERT_URIMAPS_SQL

public static java.lang.String INSERT_URIMAPS_SQL

UPDATE_URIMAPS_BY_LOCALID_SQL

public static java.lang.String UPDATE_URIMAPS_BY_LOCALID_SQL

DELETE_URIMAPS_BY_REFERENCE_GUID_SQL

public static java.lang.String DELETE_URIMAPS_BY_REFERENCE_GUID_SQL
Constructor Detail

IbatisPickListDao

public IbatisPickListDao()
Method Detail

getPickListDefinitionById

public PickListDefinition getPickListDefinitionById(java.lang.String pickListId)
Description copied from interface: PickListDao
Gets the pick list definition by id.

Specified by:
getPickListDefinitionById in interface PickListDao
Parameters:
pickListId - the pick list id
Returns:
the pick list definition by id

getPickListGuidFromPickListId

public java.lang.String getPickListGuidFromPickListId(java.lang.String pickListId)
Description copied from interface: PickListDao
Gets the guid from pick list id.

Specified by:
getPickListGuidFromPickListId in interface PickListDao
Parameters:
pickListId - the pick list id
Returns:
the guid from pick list id

getPickListDefinitionIdForValueSetDefinitionURI

public java.util.List<java.lang.String> getPickListDefinitionIdForValueSetDefinitionURI(java.lang.String valueSetDefURI)
Description copied from interface: PickListDao
Gets the list of pick list definitions that are derived by supplied value set definition URI.

Specified by:
getPickListDefinitionIdForValueSetDefinitionURI in interface PickListDao
Returns:
the pick list id

insertPickListDefinition

public java.lang.String insertPickListDefinition(PickListDefinition definition,
                                                 java.lang.String systemReleaseUri,
                                                 Mappings mappings)
Description copied from interface: PickListDao
Insert pick list definition.

Specified by:
insertPickListDefinition in interface PickListDao
Parameters:
definition - the definition
systemReleaseUri - the system release uri
Returns:
the string

getPickListIds

public java.util.List<java.lang.String> getPickListIds()
Description copied from interface: PickListDao
Gets the pick list ids.

Specified by:
getPickListIds in interface PickListDao
Returns:
the pick list ids

getPrefix

protected java.lang.String getPrefix()
Gets the prefix.

Returns:
the prefix

doGetSupportedLgSchemaVersions

public java.util.List<LexGridSchemaVersion> doGetSupportedLgSchemaVersions()
Description copied from class: AbstractBaseDao
Do get supported lg schema versions.

Specified by:
doGetSupportedLgSchemaVersions in class AbstractBaseDao
Returns:
the list< lex grid schema version>

getVersionsDao

public VersionsDao getVersionsDao()
Gets the versions dao.

Returns:
the versions dao

setVersionsDao

public void setVersionsDao(VersionsDao versionsDao)
Sets the versions dao.

Parameters:
versionsDao - the new versions dao

removePickListDefinitionByPickListId

public void removePickListDefinitionByPickListId(java.lang.String pickListDefinitionId)
Description copied from interface: PickListDao
Delete pick list definition by pick list id.

Specified by:
removePickListDefinitionByPickListId in interface PickListDao
Parameters:
pickListDefinitionId - the pick list definition id

getPickListEntryNodeGuidByPickListIdAndPLEntryId

public java.lang.String getPickListEntryNodeGuidByPickListIdAndPLEntryId(java.lang.String pickListDefinitionId,
                                                                         java.lang.String plEntryId)
Description copied from interface: PickListDao
Returns the plEntryGUID for pickListId and pickListEntryId.

Specified by:
getPickListEntryNodeGuidByPickListIdAndPLEntryId in interface PickListDao
Returns:
the plEntryGuid

insertMappings

public void insertMappings(java.lang.String referenceGuid,
                           Mappings mappings)

insertURIMap

public void insertURIMap(java.lang.String referenceGuid,
                         java.util.List<URIMap> urimapList)

insertURIMap

public void insertURIMap(java.lang.String referenceGuid,
                         URIMap uriMap)

buildInsertOrUpdateURIMapBean

protected InsertOrUpdateURIMapBean buildInsertOrUpdateURIMapBean(java.lang.String prefix,
                                                                 java.lang.String uriMapId,
                                                                 java.lang.String referenceGuid,
                                                                 java.lang.String supportedAttributeTag,
                                                                 URIMap uriMap)
Builds the insert uri map bean.

Parameters:
prefix - the prefix
uriMapId - the uri map id
codingSchemeId - the coding scheme id
supportedAttributeTag - the supported attribute tag
uriMap - the uri map
Returns:
the insert uri map bean

deletePickListDefinitionMappings

public void deletePickListDefinitionMappings(java.lang.String referenceGuid)

getVsPropertyDao

public VSPropertyDao getVsPropertyDao()
Returns:
the vsPropertyDao

setVsPropertyDao

public void setVsPropertyDao(VSPropertyDao vsPropertyDao)
Parameters:
vsPropertyDao - the vsPropertyDao to set

getPickListDefinitionIdForEntityReference

public java.util.List<java.lang.String> getPickListDefinitionIdForEntityReference(java.lang.String entityCode,
                                                                                  java.lang.String entityCodeNameSpace,
                                                                                  java.lang.String propertyId)
Specified by:
getPickListDefinitionIdForEntityReference in interface PickListDao
Returns:

getVsEntryStateDao

public VSEntryStateDao getVsEntryStateDao()
Returns:
the vsEntryStateDao

setVsEntryStateDao

public void setVsEntryStateDao(VSEntryStateDao vsEntryStateDao)
Parameters:
vsEntryStateDao - the vsEntryStateDao to set

getPickListDefinitionIdForSupportedTagAndValue

public java.util.List<java.lang.String> getPickListDefinitionIdForSupportedTagAndValue(java.lang.String supportedTag,
                                                                                       java.lang.String value)
Description copied from interface: PickListDao
Returns all the pickListIds that contain supplied supported tag and value.

Specified by:
getPickListDefinitionIdForSupportedTagAndValue in interface PickListDao
Parameters:
supportedTag - like SupportedCodingScheme, SupportedAssociation etc.
value - value to look for
Returns:
list of pickListIds that contains supportedTag with value.

insertHistoryPickListDefinition

public java.lang.String insertHistoryPickListDefinition(java.lang.String pickListDefUId,
                                                        java.lang.String pickListId)
Specified by:
insertHistoryPickListDefinition in interface PickListDao

updatePickListDefinition

public java.lang.String updatePickListDefinition(java.lang.String pickListDefUId,
                                                 PickListDefinition definition)
Specified by:
updatePickListDefinition in interface PickListDao

updateVersionableAttributes

public java.lang.String updateVersionableAttributes(java.lang.String pickListDefUId,
                                                    PickListDefinition definition)
Specified by:
updateVersionableAttributes in interface PickListDao

getPickListEntryStateUId

public java.lang.String getPickListEntryStateUId(java.lang.String pickListDefUId)
Specified by:
getPickListEntryStateUId in interface PickListDao

updateEntryStateUId

public void updateEntryStateUId(java.lang.String pickListDefUId,
                                java.lang.String entryStateUId)
Specified by:
updateEntryStateUId in interface PickListDao

getPickListEntryNodeDao

public PickListEntryNodeDao getPickListEntryNodeDao()
Returns:
the pickListEntryNodeDao

setPickListEntryNodeDao

public void setPickListEntryNodeDao(PickListEntryNodeDao pickListEntryNodeDao)
Parameters:
pickListEntryNodeDao - the pickListEntryNodeDao to set

getLatestRevision

public java.lang.String getLatestRevision(java.lang.String pickListDefUId)
Specified by:
getLatestRevision in interface PickListDao

entryStateExists

public boolean entryStateExists(java.lang.String entryStateUId)
Specified by:
entryStateExists in interface PickListDao

resolvePickListByRevision

public PickListDefinition resolvePickListByRevision(java.lang.String pickListId,
                                                    java.lang.String revisionId,
                                                    java.lang.Integer sortType)
                                             throws LBRevisionException
Specified by:
resolvePickListByRevision in interface PickListDao
Throws:
LBRevisionException

Copyright: (c) 2004-2006 Mayo Foundation for Medical Education and Research (MFMER). All rights reserved. MAYO, MAYO CLINIC, and the triple-shield Mayo logo are trademarks and service marks of MFMER.