From e2d69b23de157ab9a105a3b20f98c441106d204a Mon Sep 17 00:00:00 2001 From: Bogumil Zebek Date: Tue, 14 Jan 2020 12:00:51 +0100 Subject: Extract query Issue-ID: DCAEGEN2-2019 Signed-off-by: Zebek Bogumil Change-Id: I5f22589af67e11bf5bf7292f95df9f416007a15f --- .../impl/DcaeServiceTypesQueryStatementTest.java | 234 +++++++++++++++++++++ 1 file changed, 234 insertions(+) create mode 100644 src/test/java/io/swagger/api/impl/DcaeServiceTypesQueryStatementTest.java (limited to 'src/test/java/io/swagger/api/impl/DcaeServiceTypesQueryStatementTest.java') diff --git a/src/test/java/io/swagger/api/impl/DcaeServiceTypesQueryStatementTest.java b/src/test/java/io/swagger/api/impl/DcaeServiceTypesQueryStatementTest.java new file mode 100644 index 0000000..ff6aabf --- /dev/null +++ b/src/test/java/io/swagger/api/impl/DcaeServiceTypesQueryStatementTest.java @@ -0,0 +1,234 @@ +/*- + * ============LICENSE_START======================================================= + * dcae-inventory + * ================================================================================ + * Copyright (C) 2020 Nokia Intellectual Property. All rights reserved. + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * ============LICENSE_END========================================================= + */ +package io.swagger.api.impl; + +import org.junit.Test; + +import static org.assertj.core.api.Assertions.assertThat; + + +public class DcaeServiceTypesQueryStatementTest { + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypes() { + // when + final String sql = DcaeServiceTypesQueryStatement.create(null, true, true, + null, null, null, null, null, null, + null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastDeactivatedDcaeServiceTypes() { + //when + final String sql = DcaeServiceTypesQueryStatement.create(null, true, false, + null, null, null, null, null, + null, null, null); + + //then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where created < :createdCutoff order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForActiveDcaeServiceTypes() { + // when + final String sql = DcaeServiceTypesQueryStatement.create(null, false, true, + null, null, null, null, null, + null, null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types where created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForDeactivatedDcaeServiceTypes() { + // when + final String sql = DcaeServiceTypesQueryStatement.create(null, false, false, + null, null, null, null, null, + null, null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types where created < :createdCutoff order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithAsteriskTypeName() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("*", true, true, + null, null, null, null, null, null, + null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where type_name LIKE :typeName and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeName() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + null, null, null, null, null, null, + null, null); + + // then + assertThat(sql).isEqualTo("select * from dcae_service_types_latest where :typeName = type_name and created < :createdCutoff and deactivated is null order by created desc"); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfType() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", null, null, null, null, null, + null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceId() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", null, null, null, + null, null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceIdAndServiceLocation() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", "serviceLocation", null, + null, null, null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and (:serviceLocation = any(service_locations) or service_locations = '{}' or service_locations is null) and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceIdAndServiceLocationAndAsdcServiceIdSetToNone() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", "serviceLocation", "none", + null, null, null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and (:serviceLocation = any(service_locations) or service_locations = '{}' or service_locations is null) and asdc_service_id is null and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceIdAndServiceLocationAndAsdcServiceId() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", "serviceLocation", "asdcServiceId", + null, null, null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and (:serviceLocation = any(service_locations) or service_locations = '{}' or service_locations is null) and :asdcServiceId = asdc_service_id and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceIdAndServiceLocationAndAsdcServiceIdAndAsdcResourceIdSetToNone() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", "serviceLocation", "none", + "none", null, null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and (:serviceLocation = any(service_locations) or service_locations = '{}' or service_locations is null) and asdc_service_id is null and asdc_resource_id is null and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceIdAndServiceLocationAndAsdcServiceIdAndAsdcResourceId() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", "serviceLocation", "asdcServiceId", + "asdcResourceId", null, null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and (:serviceLocation = any(service_locations) or service_locations = '{}' or service_locations is null) and :asdcServiceId = asdc_service_id and :asdcResourceId = asdc_resource_id and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceIdAndServiceLocationAndAsdcServiceIdAndAsdcResourceIdAndOwner() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", "serviceLocation", "asdcServiceId", + "asdcResourceId", "owner", null, null); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and (:serviceLocation = any(service_locations) or service_locations = '{}' or service_locations is null) and :asdcServiceId = asdc_service_id and :asdcResourceId = asdc_resource_id and :owner = owner and created < :createdCutoff and deactivated is null order by created desc" + ); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceIdAndServiceLocationAndAsdcServiceIdAndAsdcResourceIdAndOwnerAndApplication() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", "serviceLocation", "asdcServiceId", + "asdcResourceId", "owner", "application", null); + + // then + assertThat(sql).isEqualTo("select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and (:serviceLocation = any(service_locations) or service_locations = '{}' or service_locations is null) and :asdcServiceId = asdc_service_id and :asdcResourceId = asdc_resource_id and :owner = owner and :application = application and created < :createdCutoff and deactivated is null order by created desc"); + } + + @Test + public void shouldReturnSqlTemplateForLastActiveDcaeServiceTypesWithTypeNameAndVnfTypeAndServiceIdAndServiceLocationAndAsdcServiceIdAndAsdcResourceIdAndOwnerAndApplicationAndComponent() { + // when + final String sql = DcaeServiceTypesQueryStatement.create("typeName", true, true, + "vnfType", "serviceId", "serviceLocation", "asdcServiceId", + "asdcResourceId", "owner", "application", "component"); + + // then + assertThat(sql).isEqualTo( + "select * from dcae_service_types_latest where :typeName = type_name and lower(:vnfType) = any(lower(vnf_types\\:\\:text)\\:\\:text[]) and (:serviceId = any(service_ids) or service_ids = '{}' or service_ids is null) and (:serviceLocation = any(service_locations) or service_locations = '{}' or service_locations is null) and :asdcServiceId = asdc_service_id and :asdcResourceId = asdc_resource_id and :owner = owner and :application = application and :component = component and created < :createdCutoff and deactivated is null order by created desc" + ); + } +} -- cgit 1.2.3-korg