/* * Copyright 2002-2018 the original author or authors. * * 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. */ package org.springframework.test.context.junit.jupiter.nested; import org.junit.jupiter.api.Nested; import org.junit.jupiter.api.Test; import org.junit.jupiter.api.TestInstance; import org.junit.jupiter.api.TestInstance.Lifecycle; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.test.context.jdbc.PopulatedSchemaDatabaseConfig; import org.springframework.test.context.jdbc.Sql; import org.springframework.test.context.junit.jupiter.SpringExtension; import org.springframework.test.context.junit.jupiter.SpringJUnitConfig; import org.springframework.test.context.transaction.AfterTransaction; import org.springframework.test.context.transaction.BeforeTransaction; import org.springframework.test.jdbc.JdbcTestUtils; import org.springframework.transaction.annotation.Transactional; import static org.junit.jupiter.api.Assertions.assertEquals; /** * Integration tests that verify support for {@link Nested @Nested} test classes in * conjunction with the {@link SpringExtension}, {@link Sql @Sql}, and * {@link Transactional @Transactional} in a JUnit Jupiter environment. * * @author Sam Brannen * @since 5.1.3 */ @SpringJUnitConfig(PopulatedSchemaDatabaseConfig.class) @Transactional @TestInstance(Lifecycle.PER_CLASS) class NestedTestsWithSqlScriptsAndJUnitJupiterTests { @Autowired JdbcTemplate jdbcTemplate; @BeforeTransaction @AfterTransaction void checkInitialDatabaseState() { assertEquals(0, countRowsInTable("user")); } @Test @Sql("/org/springframework/test/context/jdbc/data.sql") void sqlScripts() { assertEquals(1, countRowsInTable("user")); } private int countRowsInTable(String tableName) { return JdbcTestUtils.countRowsInTable(this.jdbcTemplate, tableName); } @Nested @SpringJUnitConfig(PopulatedSchemaDatabaseConfig.class) @Transactional class NestedTests { @Autowired JdbcTemplate jdbcTemplate; @BeforeTransaction @AfterTransaction void checkInitialDatabaseState() { assertEquals(0, countRowsInTable("user")); } @Test @Sql("/org/springframework/test/context/jdbc/data.sql") void nestedSqlScripts() { assertEquals(1, countRowsInTable("user")); } private int countRowsInTable(String tableName) { return JdbcTestUtils.countRowsInTable(this.jdbcTemplate, tableName); } } }