如何配置SpringBoot、SpringJPA、SpringTest和Hibernate来创建、使用和删除给定的PostgreSQL模式？

Question

如何配置SpringBoot、SpringDataJPA、SpringTest和Hibernate来为保存和检索对象的单元测试创建、使用和删除给定的PostgreSQL模式？

在测试开始之前，Spring测试应该为测试创建数据库模式。每个测试方法都应该在单个事务中运行，并且在它完成后，测试方法应该回滚所有数据库操作。在所有测试方法结束时，测试应该删除模式。

在目前的形式中，AcCountRepositoryTest传递，但在模式公共中创建表帐户，而不是在新模式springstart中创建表帐户。

配置：

• Spring靴1.3.0。构建快照
• Spring数据JPA1.9.0。发布
• Spring试验4.2.3。构建快照
• 冬眠4.3.11。期末考试
• PostgreSQL 9.5.4

AccountRepositoryTest。JAVA

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(Application.class)
public class AccountRepositoryTest {
    final static Logger logger = LoggerFactory.getLogger(AccountRepositoryTest.class);

    @Autowired
    AccountRepository accountRepository;

    @Test
    public void testSaveAccount() {
        final Account newAccount = accountRepository.save(new Account("123", "Derek Mahar", 500.00));
        final Account readAccount = accountRepository.findOne(newAccount.getId());
        logger.info("New account UUID={}", newAccount.getId());
        assertEquals(newAccount.getBalance(), readAccount.getBalance(), 0.001);
        assertEquals(newAccount.getNumber(), readAccount.getNumber());
        assertEquals(newAccount.getOwner(), readAccount.getOwner());
    }

    @Test
    public void testFindByNumber() {
        final Account newAccount = accountRepository.save(new Account("456", "Steve Balmer", 500.00));
        final Account readAccount = accountRepository.findByNumber(newAccount.getNumber());
        logger.info("New account UUID={}", newAccount.getId());
        assertEquals(newAccount.getBalance(), readAccount.getBalance(), 0.001);
        assertEquals(newAccount.getNumber(), readAccount.getNumber());
        assertEquals(newAccount.getOwner(), readAccount.getOwner());
    }

    @Test
    public void testFindByOwner() {
        final Account newAccount = accountRepository.save(new Account("789", "Bill Gates", 500.00));
        final Account readAccount = accountRepository.findByNumber(newAccount.getNumber());
        logger.info("New account UUID={}", newAccount.getId());
        assertEquals(newAccount.getBalance(), readAccount.getBalance(), 0.001);
        assertEquals(newAccount.getNumber(), readAccount.getNumber());
        assertEquals(newAccount.getOwner(), readAccount.getOwner());
    }
}

AccountRepository。JAVA

public interface AccountRepository extends CrudRepository<Account, UUID> {
    Account findByNumber(String number);
    Account findByOwner(String owner);
}

账户JAVA

@Entity
public class Account implements Serializable {
    @Column(nullable = false)
    private double balance;

    @Id
    @GeneratedValue(generator = "uuid2")
    @GenericGenerator(name = "uuid2", strategy = "uuid2")
    @Column
    private UUID id;

    @Column(nullable = false)
    private String number;

    @Column(nullable = false)
    private String owner;

    public Account(String number, String owner, double balance) {
        this.number = number;
        this.owner = owner;
        this.balance = balance;
    }

    public Account() {
    }

    public double getBalance() {
        return balance;
    }

    public UUID getId() {
        return id;
    }

    public String getNumber() {
        return number;
    }

    public String getOwner() {
        return owner;
    }
}

application.properties

spring.datasource.url=jdbc:postgresql:springboot
spring.datasource.username=springboot
spring.datasource.password=springboot
spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.schema=springboot
spring.datasource.initialize=true

spring.jpa.database=springboot
spring.jpa.generate-ddl=true
spring.jpa.hibernate.ddl-auto=create-drop
spring.jpa.show-sql=true

Answer 1

最好的办法是使用spring.jpa.hibernate.ddl-autoSpring Boot属性。将其包含在application-test.properties（或application-test.yaml，视情况而定）中，并将其值设置为create-drop（例如，spring.jpa.hibernate.ddl-car=create-drop）.更多详细信息请参阅Spring Boot留档。

但是，我建议您使用内存中的数据库来运行测试，因为您不会冒将测试指向实际数据库架构的风险，测试将运行得更快，并且您将能够在第三方系统（如Travis CI或Shippable）上运行持续集成构建。