/* * Copyright 2002-2016 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.jdbc; import javax.sql.DataSource; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Primary; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseBuilder; import org.springframework.test.annotation.DirtiesContext; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import org.springframework.test.jdbc.JdbcTestUtils; import org.springframework.test.transaction.TransactionTestUtils; import static org.junit.Assert.*; /** * Integration tests that ensure that <em>primary</em> data sources are * supported. * * @author Sam Brannen * @since 4.3 * @see org.springframework.test.context.transaction.PrimaryTransactionManagerTests */ @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration @DirtiesContext public class PrimaryDataSourceTests { @Configuration static class Config { @Primary @Bean public DataSource primaryDataSource() { // @formatter:off return new EmbeddedDatabaseBuilder() .generateUniqueName(true) .addScript("classpath:/org/springframework/test/context/jdbc/schema.sql") .build(); // @formatter:on } @Bean public DataSource additionalDataSource() { return new EmbeddedDatabaseBuilder().generateUniqueName(true).build(); } } private JdbcTemplate jdbcTemplate; @Autowired public void setDataSource(DataSource dataSource) { this.jdbcTemplate = new JdbcTemplate(dataSource); } @Test @Sql("data.sql") public void dataSourceTest() { TransactionTestUtils.assertInTransaction(false); assertEquals("Number of rows in the 'user' table.", 1, JdbcTestUtils.countRowsInTable(this.jdbcTemplate, "user")); } }