Bookstore Tutorial

import javax.persistence.Entity;
import javax.persistence.Table;
...

@Entity
@Table(uniqueConstraints = @UniqueConstraint(  (1)
		columnNames={"surname", "firstname", "title", "calendarYear"})
)
public class Book implements Serializable {
	private static final long serialVersionUID = 1L;
	@Version (2)
	private long version;
	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY) (3)
	private Long id; (3)
	private String surname;
	private String firstname;
	private String title;
	private Double price;
	private Boolean onsale;
	private Integer calendarYear;
	private String description;
	private Integer inventory;
	...

create table Book (id bigint not null auto_increment, calendarYear integer, description varchar(255), firstname varchar(255), inventory integer, onsale bit, price double precision, surname varchar(255), title varchar(255), version bigint not null, primary key (id)) engine=InnoDB;
alter table Book add constraint UK9u3gktk5oqaaxduqbu8hql9yy unique (surname, firstname, title, calendarYear);

import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
...

@Repository
@Transactional(readOnly = true) (1)
public class BookDao {
	private final transient Logger log = LoggerFactory.getLogger(getClass()); (2)

    @PersistenceContext private EntityManager em;

    @Transactional(readOnly = false) (1)
    public void createBook(String surname, String firstname,
        String title, Double price, Boolean onsale, Integer calendarYear,
        String description, Integer inventory) {
        Book book = new Book(surname, firstname, title, price,
                onsale, calendarYear, description, inventory);
        em.persist(book);
        log.info("Persisted book {}", title); (2)
    }

    public List<Book> getBooks() {
        return em.createQuery("FROM Book ORDER BY id", Book.class).getResultList(); (3)
    }
    ...

<setup>
	<books>
		<book>
			<surname>Duke</surname>
			<firstname></firstname>
			<title>My Early Years: Growing Up on *7</title>
			<price>30.75</price>
			<onsale>false</onsale>
			<calendarYear>2005</calendarYear>
			<description>What a cool book.</description>
			<inventory>20</inventory>
		</book>
		<book>
			<surname>Jeeves</surname>
			<firstname></firstname>
			<title>Web Servers for Fun and Profit</title>
			<price>40.75</price>
			<onsale>true</onsale>
			<calendarYear>2010</calendarYear>
			<description>What a cool book.</description>
			<inventory>20</inventory>
		</book>
		...

public List<Book> getInitialBooks() {
	List<Book> result = new ArrayList<>();
	List<ImmutableHierarchicalConfiguration> booksSetup = configuration.immutableConfigurationsAt("config/setup/books/book");
	for (ImmutableHierarchicalConfiguration bookSetup : booksSetup) {
		String surname = bookSetup.getString("surname");
		String firstname = bookSetup.getString("firstname");
		String title = bookSetup.getString("title");
		Double price = bookSetup.getDouble("price");
		Boolean onsale = bookSetup.getBoolean("onsale", false); // Defaults to false
		Integer calendarYear = bookSetup.getInt("calendarYear");
		String description = bookSetup.getString("description");
		Integer inventory = bookSetup.getInt("inventory");
		Book book = new Book(surname, firstname, title, price, onsale, calendarYear, description, inventory);
		result.add(book);
	}
	return result;
}

 @Override
 protected void setupApplication() {
	 List<Book> configuredBooks = config.getInitialBooks();
	 bookDao.createWhenMissing(configuredBooks);
 }

@Transactional(readOnly = false)
public void createWhenMissing(List<Book> configuredBooks) {
	String sql = "insert ignore into Book (surname, firstname, title, price, onsale, calendarYear, description, inventory) "
		+ "values (:surname, :firstname, :title, :price, :onsale, :calendarYear, :description, :inventory)"; (1)
	for (Book book : configuredBooks) {
		em.createNativeQuery(sql)
			.setParameter("surname", book.getSurname())
			.setParameter("firstname", book.getFirstname())
			.setParameter("title", book.getTitle())
			.setParameter("price", book.getPrice())
			.setParameter("onsale", book.getOnsale())
			.setParameter("calendarYear", book.getCalendarYear())
			.setParameter("description", book.getDescription())
			.setParameter("inventory", book.getInventory())
			.executeUpdate();
	}
}