/** * Copyright (C) 2011-2020 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.flywaydb.test.sample.spring3; import org.flywaydb.test.annotation.FlywayTest; import org.flywaydb.test.dbunit.DBUnitSupport; import org.flywaydb.test.dbunit.DatabaseConnectionFactory; import org.flywaydb.test.dbunit.FlywayDBUnitTestExecutionListener; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.TestExecutionListeners; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import org.springframework.test.context.support.DependencyInjectionTestExecutionListener; import static org.junit.Assert.assertEquals; import static org.junit.Assert.assertTrue; /** * Simple Test to show how the annotation can be used inside test execution.<p/> * This test execute the identically tests as {@link Spring3DBunitTest}, but * with using a own {@link DatabaseConnectionFactory}.<br/> * Important are the usage of a own application context * <pre> * ContextConfiguration(locations = { "/context/dbunit_connection_applicationContext.xml" }) * </pre> * This application conntext contains the bean definition of {@link TestDatabaseConnectionFactory}<p/> * * @author florian * * @version 1.7 * @since 1.7.0 * @version 2012-10-03 * */ @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration(locations = { "/context/dbunit_connection_applicationContext.xml" }) @TestExecutionListeners({ DependencyInjectionTestExecutionListener.class, FlywayDBUnitTestExecutionListener.class }) @FlywayTest @DBUnitSupport(loadFilesForRun = { "INSERT", "/dbunit3/dbunit.cus1.xml"}) public class Spring3DBunitConnectionFactoryTest extends BaseDBHelper { /** * Normal test method nothing done per startup */ @Test public void dummyTestNoLoad() throws Exception { int res = countCustomer(); assertTrue("This test must runs without an error, because we can not guarantee that this test method run as first. " + res, true); } /** * Made a clean init migrate usage before execution of test methods */ @Test @FlywayTest public void dummyTestMethodLoad() throws Exception { int res = countCustomer(); assertEquals("Count of customer", 0, res); } /** * Made a clean init migrate and insert sql with dbunit */ @Test @FlywayTest @DBUnitSupport(loadFilesForRun = { "INSERT", "/dbunit3/dbunit.cus1.xml"}) public void loadDBUnitSQLs() throws Exception { int res = countCustomer(); assertEquals("Count of customer", 2, res); } /** * Made a clean init migrate with inserts from flyway and store it * afterwards */ @Test @FlywayTest(locationsForMigrate = {"loadmsql"}) @DBUnitSupport(saveTableAfterRun = { "CUSTOMER", "select * from CUSTOMER" }, saveFileAfterRun = "target/dbunitresult/customer1.xml") public void storeDBUnitSQLs() throws Exception { int res = countCustomer(); assertEquals("Count of customer", 2, res); } }