Developing Java Applications with Spring and Spring Boot

How to do it...

1. Our first step will be to create a resources directory in the src/test directory at the root of our project.
2. In this directory, we will start placing our fixture SQL data files. Let's create a new file named test-data.sql in the resources directory with the following content:

INSERT INTO author (id, first_name, last_name) VALUES (2, 'Greg', 'Turnquist') 
INSERT INTO book (isbn, title, author_id, publisher_id) VALUES ('978-1-78439-302-1', 'Learning Spring Boot', 2, 1) 

3. We now need a way to load this file when our test runs. We will modify our BookPubApplicationTests class in the following way:

public class BookPubApplicationTests { ... @Autowired private BookRepository repository; @Autowired private RestTemplate restTemplate; ...