# The SQL Hibernate sent for each request (recorded by a StatementInspector)


--- create:  POST /api/books  ->  HTTP 201 ---
insert into book (author,isbn,price,title) values (?,?,?,?)

--- read one:  GET /api/books/1  ->  HTTP 200 ---
select b1_0.id,b1_0.author,b1_0.isbn,b1_0.price,b1_0.title from book b1_0 where b1_0.id=?

--- list page 0, size 2:  GET /api/books?page=0&size=2  ->  HTTP 200 ---
select b1_0.id,b1_0.author,b1_0.isbn,b1_0.price,b1_0.title from book b1_0 order by b1_0.id limit ?,?
select count(b1_0.id) from book b1_0

--- list filtered by author:  GET /api/books?author=bloch  ->  HTTP 200 ---
select b1_0.id,b1_0.author,b1_0.isbn,b1_0.price,b1_0.title from book b1_0 where upper(b1_0.author) like upper(?) escape '\\' order by b1_0.id limit ?

--- update:  PUT /api/books/1  ->  HTTP 200 ---
select b1_0.id,b1_0.author,b1_0.isbn,b1_0.price,b1_0.title from book b1_0 where b1_0.id=?
update book set author=?,isbn=?,price=?,title=? where id=?

--- delete:  DELETE /api/books/1  ->  HTTP 204 ---
select b1_0.id,b1_0.author,b1_0.isbn,b1_0.price,b1_0.title from book b1_0 where b1_0.id=?
delete from book where id=?