当创建新条目时，没有使用JPA和spring更新数据库

Question

我正在使用Spring框架配置一个简单的JPA应用程序。我的目标是在JUnit测试运行期间用数据填充db。我明白这并不理想。但我想要它有不同的用途。

下面是我的persistence.xml

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    version="1.0">
    <persistence-unit name="tothought-tutorial-test" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <properties>
        <!--    <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />
        <property name="hibernate.hbm2ddl.auto" value="create-drop" /> -->
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />
            <property name="hibernate.hbm2ddl.auto" value="update" />
            <property name="hibernate.show_sql" value="true"/>
        </properties>
    </persistence-unit>
</persistence>

test-context.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:jdbc="http://www.springframework.org/schema/jdbc"
    xmlns:jpa="http://www.springframework.org/schema/data/jpa"
    xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.2.xsd">

    <!-- Database -->
    <!--  <jdbc:embedded-database id="datasource" type="H2"></jdbc:embedded-database> -->

    <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/to_thought_tutorial" />
        <property name="username" value="demo" />
        <property name="password" value="demo" />
    </bean>

    <!-- Entity Manager -->
    <bean id="entityManagerFactory"
        class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="datasource" />
        <property name="persistenceUnitName" value="tothought-tutorial-test" />
    </bean>

    <!-- Transaction Manager -->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory" />
    </bean>

    <!-- Jpa Repositories -->
    <jpa:repositories base-package="com.cloudfoundry.tothought.repositories"></jpa:repositories>
</beans>

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations="classpath:META-INF/test-context.xml")
@Transactional
public class PostPartRepositoryTest {

    @Autowired
    PostPartRepository repository;

    @Test
    public void test() {
        PostPart postPart = new PostPart();
        String body = "Hello";
        postPart.setBody(body);

        repository.save(postPart);

        PostPart dbPostPart = repository.findOne(postPart.getPostPartId());
        assertNotNull(dbPostPart);
        assertEquals(body, dbPostPart.getBody());
    }

    @Test
    public void insertTest(){

        Post post = new Post();
        post.setPostDate(new Date());
        post.setTitle("First Post");

        PostPart postPart = new PostPart();
        String body = "Hello";
        postPart.setBody(body);

        postPart.setPost(post);

        repository.save(postPart);

        PostPart dbPostPart = repository.findOne(postPart.getPostPartId());
        assertNotNull(dbPostPart);
        assertNotNull(dbPostPart.getPost());
        assertEquals(body, dbPostPart.getBody());
    }

}

Answer 1

您不会看到任何条目，因为您使用@transactional使用SpringJunit4ClassRunner运行测试。使用@transactional运行测试的默认情况是，一旦测试完成，任何数据库更改都将自动回滚。有关更多信息，请参见此问题

这些事情发生的顺序如下：

1. 开始测试，运行安装脚本，从而创建表。
2. 测试在事务性上下文中开始运行。
3. 测试完成运行，测试期间所做的任何数据库更改都会自动回滚，使数据库保持测试运行前的状态。