org.ikasan.mapping.dao.constants.MappingConfigurationDaoConstants Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of ikasan-mapping Show documentation
Show all versions of ikasan-mapping Show documentation
A library for managing mapping configurations for the Ikasan platform
The newest version!
/*
* $Id$
* $URL$
*
* ====================================================================
* Ikasan Enterprise Integration Platform
*
* Distributed under the Modified BSD License.
* Copyright notice: The copyright for this software and a full listing
* of individual contributors are as shown in the packaged copyright.txt
* file.
*
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* - Redistributions of source code must retain the above copyright notice,
* this list of conditions and the following disclaimer.
*
* - Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* - Neither the name of the ORGANIZATION nor the names of its contributors may
* be used to endorse or promote products derived from this software without
* specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
* FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
* DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
* SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
* CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
* OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
* USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
* ====================================================================
*/
package org.ikasan.mapping.dao.constants;
/**
* @author Ikasan Development Team
*
*/
public interface MappingConfigurationDaoConstants
{
/** Static strings representing parameter values to set on the query */
public static final String CONFIGURATION_TYPE = "configurationType";
public static final String SOURCE_CONTEXT = "sourceContext";
public static final String TARGET_CONTEXT = "targetContext";
public static final String SOURCE_SYSTEM_VALUE = "sourceSystemValue";
public static final String SOURCE_SYSTEM_VALUE_NAME = "name";
public static final String TARGET_SYSTEM_VALUE = "targetSystemValue";
public static final String SOURCE_SYSTEM_VALUE_SIZE_CONFIRM = "sourceSystemValueSizeConfirm";
public static final String NUMBER_OF_PARAMS = "numberOfParams";
public static final String CONFIGURATION_SERVICE_CLIENT_NAME = "configurationServiceClientName";
public static final String TARGET_CONFIGURATION_VALUE_ID = "targetConfigurationValueId";
public static final String SIZE = "size";
public static final String GROUPING_ID = "groupingId";
/** The base HQL query used to access the mapping configurations. */
public static final String REVERSE_MAPPING_CONFIGURATION_QUERY = "select distinct scv.sourceSystemValue from ConfigurationType as ct," +
" MappingConfiguration as mc, TargetConfigurationValue as tcv, SourceConfigurationValue as scv, ConfigurationServiceClient as csc" +
" where ct.name = :" + CONFIGURATION_TYPE +
" and ct.id = mc.configurationType" +
" and mc.sourceContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + SOURCE_CONTEXT + ")" +
" and mc.targetContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + TARGET_CONTEXT + ")" +
" and mc.numberOfParams = 1" +
" and mc.configurationServiceClient = csc.id" +
" and csc.name = :" + CONFIGURATION_SERVICE_CLIENT_NAME +
" and mc.id = scv.mappingConfigurationId" +
" and tcv.id = scv.targetConfigurationValue" +
" and tcv.targetSystemValue = :" + TARGET_SYSTEM_VALUE;
/** The base HQL query used to access the mapping configurations. */
public static final String MAPPING_CONFIGURATION_QUERY = "select distinct tcv.targetSystemValue from ConfigurationType as ct," +
" MappingConfiguration as mc, TargetConfigurationValue as tcv, SourceConfigurationValue as scv, ConfigurationServiceClient as csc" +
" where ct.name = :" + CONFIGURATION_TYPE +
" and ct.id = mc.configurationType" +
" and mc.sourceContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + SOURCE_CONTEXT + ")" +
" and mc.targetContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + TARGET_CONTEXT + ")" +
" and mc.numberOfParams = :" + NUMBER_OF_PARAMS +
" and mc.configurationServiceClient = csc.id" +
" and csc.name = :" + CONFIGURATION_SERVICE_CLIENT_NAME +
" and mc.id = scv.mappingConfigurationId" +
" and tcv.id = scv.targetConfigurationValue";
/** This fragment of HQL is used to narrow the results based on n number of source system values. */
public static final String NARROW_SOURCE_SYSTEM_FRAGMENT = " and scv.targetConfigurationValue in (select scv2.targetConfigurationValue " +
"from SourceConfigurationValue as scv2 where scv2.sourceSystemValue = :" + SOURCE_SYSTEM_VALUE;
/** This fragment of HQL is used to narrow the results based on n number of source system values. */
public static final String NARROW_SOURCE_SYSTEM_WITH_NAME_FRAGMENT = " and scv.targetConfigurationValue in (select scv2.targetConfigurationValue " +
"from SourceConfigurationValue as scv2 where scv2.sourceSystemValue = :" + SOURCE_SYSTEM_VALUE + "index and scv2.name = :" + SOURCE_SYSTEM_VALUE_NAME + "index)";
public static final String KEY_LOCATION_QUERY_QUERY = "select klq.value from ConfigurationType as ct," +
" MappingConfiguration as mc, KeyLocationQuery as klq, ConfigurationServiceClient as csc" +
" where ct.name = :" + CONFIGURATION_TYPE +
" and ct.id = mc.configurationType" +
" and mc.sourceContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + SOURCE_CONTEXT + ")" +
" and mc.targetContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + TARGET_CONTEXT + ")" +
" and mc.configurationServiceClient = csc.id" +
" and csc.name = :" + CONFIGURATION_SERVICE_CLIENT_NAME +
" and mc.id = klq.mappingConfigurationId";
public static final String MAPPING_CONFIGURATION_BY_CLIENT_TYPE_AND_CONTEXT_QUERY = "select mc from ConfigurationType as ct," +
" MappingConfiguration as mc, ConfigurationServiceClient as csc" +
" where ct.name = :" + CONFIGURATION_TYPE +
" and ct.id = mc.configurationType" +
" and mc.configurationServiceClient = csc.id" +
" and csc.name = :" + CONFIGURATION_SERVICE_CLIENT_NAME +
" and mc.sourceContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + SOURCE_CONTEXT + ")" +
" and mc.targetContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + TARGET_CONTEXT + ")";
public static final String NUMBER_OF_SOURCE_CONFIGURATION_VALUES_REFERENCING_TARGET_CONFIGURATION_VALUE = "select count(*) from SourceConfigurationValue as scv," +
"TargetConfigurationValue as tcv where scv.targetConfigurationValue = tcv.id and tcv.id =:" + TARGET_CONFIGURATION_VALUE_ID;
public static final String MAPPING_CONFIGURATION_EXISTS_QUERY = "select count(*) from ConfigurationType as ct," +
" MappingConfiguration as mc, ConfigurationServiceClient as csc" +
" where ct.name = :" + CONFIGURATION_TYPE +
" and ct.id = mc.configurationType" +
" and mc.configurationServiceClient = csc.id" +
" and csc.name = :" + CONFIGURATION_SERVICE_CLIENT_NAME +
" and mc.sourceContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + SOURCE_CONTEXT + ")" +
" and mc.targetContext = (select cc.id from ConfigurationContext as cc where cc.name = :" + TARGET_CONTEXT + ")";
public static final String NARROW_CONFIGURATION_TYPE_BASE_QUERY =
"select DISTINCT t from ConfigurationType as t, " +
"ConfigurationServiceClient as c, MappingConfiguration as mc " +
"where t.id = mc.configurationType " +
"and c.id = mc.configurationServiceClient ";
public static final String NARROW_SOURCE_CONFIGURATION_BASE_QUERY =
"select DISTINCT s from ConfigurationContext as s, ConfigurationType as t, " +
"ConfigurationServiceClient as c, MappingConfiguration as mc " +
"where t.id = mc.configurationType " +
"and c.id = mc.configurationServiceClient " +
"and s.id = mc.sourceContext ";
public static final String NARROW_TARGET_CONFIGURATION_BASE_QUERY =
"select DISTINCT tg from ConfigurationContext as tg, ConfigurationContext as s, ConfigurationType as t, " +
"ConfigurationServiceClient as c, MappingConfiguration as mc " +
"where t.id = mc.configurationType " +
"and c.id = mc.configurationServiceClient " +
"and s.id = mc.sourceContext " +
"and tg.id = mc.targetContext ";
public static final String MAPPING_CONFIGURATION_BASE_QUERY = "select mc from ConfigurationType as t," +
" MappingConfiguration as mc, ConfigurationServiceClient as c" +
" where t.id = mc.configurationType" +
" and mc.configurationServiceClient = c.id";
public static final String MAPPING_CONFIGURATION_LITE_BASE_QUERY = "select mc from ConfigurationType as t," +
" MappingConfigurationLite as mc, ConfigurationServiceClient as c" +
" where t.id = mc.configurationType" +
" and mc.configurationServiceClient = c.id";
public static final String CONFIGURATION_TYPE_PREDICATE = " and t.name = :" + CONFIGURATION_TYPE;
public static final String SOURCE_SYSTEM_PREDICATE = " and s.name = :" + SOURCE_SYSTEM_VALUE;
public static final String CONFIGURATION_CLIENT_PREDICATE =" and c.name = :" + CONFIGURATION_SERVICE_CLIENT_NAME;
public static final String SOURCE_CONTEXT_PREDICATE = " and mc.sourceContext = (select cc.id from " +
"ConfigurationContext as cc where cc.name = :" + SOURCE_CONTEXT + ")";
public static final String TARGET_CONTEXT_PREDICATE = " and mc.targetContext = (select cc.id from " +
"ConfigurationContext as cc where cc.name = :" + TARGET_CONTEXT + ")";
public static final String CONFIRM_RESULT_SIZE_PREDICATE_START =
" and (" +
":" + SIZE + " = (select distinct count(*) " +
"from SourceConfigurationValue s where " +
"mc.id = s.mappingConfigurationId " +
"and(";
public static final String CONFIRM_RESULT_NARROW_BY_SOURCE_SYSTEM = "s.sourceSystemValue = :" + SOURCE_SYSTEM_VALUE_SIZE_CONFIRM;
public static final String CONFIRM_RESULT_SIZE_PREDICATE_END =
") and scv.targetConfigurationValue = s.targetConfigurationValue group by s.targetConfigurationValue)) " +
" and ( mc.numberOfParams - :" + SIZE + " = (select count(*) " +
"from SourceConfigurationValue s1 where " +
"mc.id = s1.mappingConfigurationId " +
"and s1.sourceSystemValue = '' and scv.targetConfigurationValue = s1.targetConfigurationValue))";
public static final String MANY_TO_MAPPING_CONFIGURATION_QUERY = "select tcv from" +
" ManyToManyTargetConfigurationValue as tcv" +
" where tcv.groupId = :" + GROUPING_ID;
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy